Hi I have used vb to link to an access 2003 database using the adodc component- (connection string etc etc). Right I am now working with mysql (which I would like to say I am loving it) and I have migrated the access 2003 db's into mysql using the migration toolkit . How can I link to mysql db in a similar fashion. Please reply. Thanx. kvarnerexpress

Reply

Hello kvarnerexpress,

Please follow the site http://www.connectionstrings.com/ where you get all connection string.

Reply

I'm a bit late, but I will give my contribution to this. On Planet Source Code (here's the link: Planet Source Code), there is a project in Visual Basic, called MyVbQL, that compiles into ActiveX DLL, and can be used to access MySQL databases.

I have used this project, and I can say it works pretty fine, it is stable, and runs fast. It relies fully on libmysql.dll, and even if you upgrade your MySQL server, it will work fine.

Reply

hi, all,

there is no longer need to use thrid-party component that may be not function correctly(of course, some component would be stable as Galahad said)

coz mysql company have made a conponent that is odbc compatible.
you can go here to download.

P.S. .net version component also are here.

Reply

Thanks so much for that link. I always thought that it would take so much to connect to a MySQL server in .Net programs. How on earth you you use ODBC databases in .Net? I heard of the MySQL OCBC component before, used it once or twice....

Reply

Why don't you use VB.net? It gives you much more flexibility and a better secure connection! Just try It! O.K?

Reply

I was using Microsoft Access database once ago for my project done in JSP (Java Server Pages - similar to PHP). Rather my school only taught me to use Microsoft Access. But I've found a way to connect to MySQL database for an alternative database method.

You will need another connector driver. By default, Microsoft uses ODBC (Open DataBase Connectivity) for it's Microsoft-based databases. A bridge driver is needed to connected Java applications into ODBC, which then connects to the database itself. For Java, the bridge is called JDBC (Java DataBase Connectivity).

As for your case, the current versions of Visual Basics should be based on .NET framework. MySQL has also developed a driver to connect .NET applications to MySQL databases. You will need to download and install the driver to enable the connectivity.
http://dev.mysql.com/downloads/connector/net/1.0.html

The source codes in VB for connecting to MySQL databases should remain unchanged. The only changes that has to be done is to link your MySQL database into ODBC in Administrative Tools in Control Panel.
For more information of these steps, visit the following sites :
http://www.nusphere.com/products/library/d..._mysql_odbc.htm
http://www.15seconds.com/issue/050407.htm

 

 

 

Reply