Database connectivity using Mysql

[Shun]

Hello,

I am new to .net Platform.
I want to build a sample application using VB.net and backend mysql.
now my problem is how to connect to the mysql database.
which is the better provider( oledb or odbc).
can you give any sample program.
I am using VS 2005.

Thanks in advance

Regards
Shun

 

[Pritcham]

Hi Shun

Take a look on the mysql.com website as they have released a mySQL
connector specifically for .Net 2 (which I've briefly used with no
problems) - if you search on their site for Connector.Net you should
find it quite easily.

Cheers
Martin

 

[Jeroen Vandezande]

Hello,

I am new to .net Platform.
I want to build a sample application using VB.net and backend mysql.
now my problem is how to connect to the mysql database.
which is the better provider( oledb or odbc).
can you give any sample program.
I am using VS 2005.

Hi,

I am using MySQL in VS2005 (not with VB.net but with Chrome, but that does
not make any difference) and it works fine...
You can download an ADO.net connector here :
http://dev.mysql.com/downloads/connector/net/5.0.html
Here is a tutorial about using MySQL in VB.net :
http://www.vbmysql.com/articles/vbdotnet-mysql/the-vbnet-mysql-tutorial-part-3/

Best Regards,

Jeroen Vandezande