MySql in VB .Net

[Raymond]

Dear all,

I have download the mysql database. And I have installed .Net enterprise
software with vb.net.
But when I new the VB. Net web application and want to connect to mysql
database. I don't see the mysql database to connect to in the server option.
How can I do to make mysql avaible for .Net. As I see it in the ODBC, but
not in . Net environment?

 

[Alvin Bruney]

how are you trying to connect? all you need do is import the bytefx.data
namespace in your code and use the appropriate connection strings. All the
ADO components are prefixed with MYSQL. Ex MYSQLcommand etc. These names are
available only after you import the namespace. In addition you would have to
set two references, one to bytefx the other to sharpziplib.dll which you
would have on your system if you install the mysql server. These are oledb
providers by the way, not odbc.
happy camping.

 

[Carl Prothman [MVP]]

Raymond,
Try downloading and using the following .NET Data Provider for MySQL
http://www.able-consulting.com/dotnet/adonet/Data_Providers.htm#MySQLNETNativeProvider

--

Thanks,
Carl Prothman
Microsoft ASP.NET MVP
http://www.able-consulting.com