Visual Basic .NET » Database Programming
Connecting to MySQL -- YunielLealYanes --

I need connect to MySQL database, how can I do???



I'm using Visual Studio 2005, and intalled
"mysql-connector-odbc-5.0.0-alpha-win32.msi", but this not work (in Server Explorer-Data Connections not show me the tables).



Please help me.



PD: My english is awful (I'm sorry).


Le invitamos a participar en la VII Conferencia Cientifica Internacional UNICA 2006 del 18 al 21 de Octubre de 2006


-- YunielLealYanes --

I need connect to MySQL database, how can I do???



I'm using Visual Studio 2005, and intalled
"mysql-connector-odbc-5.0.0-alpha-win32.msi", but this not work (in Server Explorer-Data Connections not show me the tables).



Please help me.



PD: My english is awful (I'm sorry).


Le invitamos a participar en la VII Conferencia Cientifica Internacional UNICA 2006 del 18 al 21 de Octubre de 2006


-- BradleyPeter --


IMO there's really no point in using the ODBC drivers. Fully functioning MySQL drivers exist (see the url in my previous post), so unless you are trying to create a program that will connect to any ODBC compliant database, you're just making life more difficult for yourself by using the ODBC drivers.

Since the OP seems to know that his system will use MySQL, it's going to be easier and more effective to use the specific drivers.

Just my 2c. YMMV
Peter
-----Original Message-----
From: DotNetDevelopment
Re: Connecting to MySQL
Hi Yuniel

First simply install ODBC diver for MySQL in your system(that is available free. you can search on google.com), then using ODBCConnection object of ADO.NET you can connect with MySQL.
Hope It'd be usefull to you.
Cheers!
Mridul


-- Mridul --


Hi Yuniel

First simply install ODBC diver for MySQL in your system(that is available free. you can search on google.com), then using ODBCConnection object of ADO.NET you can connect with MySQL.
Hope It'd be usefull to you.
Cheers!
Mridul

[Submit Comment]Home