sql query

[Steven Low]

hi guys

i wanna connect my vb.net to mysql database. but i found out that you need a database connecter. Can anyone please give me the link to the connecter driver i would be using to connect mysql with vb.net thanks

 

[lingsn]

I think you can try out this link

http://dev.mysql.com/downloads/connector/net/1.0.html

 

[LookitsPuck]

You can also download and use the MyODBC connector if you want to use an ODBC connector instead of the native .NET MySQL connector, even though the .NET connector is better. I think they worked out the kink of some connections not closing.

 

[Steven Low]

Hi guys

keep getting an error. Installer always fails with "Error writing to file: MySql.Data.dll". its the same with version 1 and version 5. I even turned my firewall off still getting the same thing.

need help with this guys.

 

[lingsn]

Try to use the custom install and choosing the version of the driver for the framework you have in your machine.

 

[Steven Low]

Hi guys

ive installed version conecter 1.07 is that okey. the mysql i am using is 5.0.27 would this be okey with 1.07 connecter.

Also could u guys recommend me a guide i can use for adding records using vb.net in mysql...I am new to using sql with vb.net but i have experince of sql commands before.

Thanks guys