mysql connection

[solaar]

Hi

I am trying to connect to MySql using VB.net, i have downloaded MySQL Connector/NET (available at http://dev.mysql.com/downloads/connector/net/. ) although i don't think visual studio is aware of it because when i use Imports MySql.Data.MySqlClient in a form the debugger says: -

Namespace or type 'MySqlClient' for the Imports 'MySql.Data.MySqlClient' cannot be found.

Can anyone tell me what i'm doing wrong?

Regards

Solaar

 

[Schenz]

It sounds like you are just missing one step. You need to add a reference to mysql.data.dll (usually located at C:\Program Files\MySQL\MySQL Connector Net 1.0.7\bin\.NET 1.1). Just right click on the references forlder, and browse to where the mysql.data.dll file is located on your computer. Once the dll is referenced and you have the imports statement everything should worf just fine for you.

 

[solaar]

that's great, cheers mate.