[2008] Connect to MySql.Data.dll Read / Write?

[cmmorris1]

I've been looking for anything that can help me figure this out and so far it's not going so well. I have a .dll file ( MySql.Data.dll ) that I'd like to be able to open, view and possibly edit the database but I can't find any examples or documentation on doing so.

Does anyone have the code that can share it with me so I can learn how to construct this type of application or point me in the right direction? I'd really appreciate it.

Chris

[jmcilhinney]

Any ADO.NET examples will do. Follow the ADO.NET Examples link in my signature. The code uses SQL Server-specific classes but you simply substitute the MySQL-specific equivalents, e.g. MySqlConnection instead of SqlConnection. You can get the connection string format from www.connectionstrings.com.

[cmmorris1]

Thanks jmcilhinney. Been having issues connecting here. I will check it out and hopefully find something useful.

Chris

[jmcilhinney]

Thanks jmcilhinney. Been having issues connecting here. I will check it out and hopefully find something useful.

Chris

Me too. Must have been a server issue or something at that end.

[gep13]

Hey,

What jm said is perfectly correct, but if you are looking for some specific examples of using MySQL with VB.Net, have a look at the link in my signature, there is a very good set of articles describing just how to do it.

Hope this helps!!

Gary

[cmmorris1]

Thanks Gary...I was trying to make it work using jm's stuff but haven't figured it out yet.

Chris

[gep13]

Hey,

You should be able to get it to work using jm's suggestion, the techniques are exactly the same, but the tutorial I linked to shows specific MySQL examples.

You might want to post some code though to see if we can help out.

Gary