Jump to content
xisto Community
Sign in to follow this  
kvarnerexpress

Linking To Mysql From Vb

Recommended Posts

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

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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.

200664[/snapback]

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....

Share this post


Link to post
Share on other sites

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://forums.xisto.com/no_longer_exists/
http://www.codeguru.com/csharp/.net/net_data/article.php/c19493/A-StepbyStep-Guide-To-Using-MySQL-with-ASPNET--Part-2.htm

Share this post


Link to post
Share on other sites

Try to use vb2mysql to resolve the connectivity of vb6 and mysql

Linking To Mysql From Vb

 

Hi, I have wrote vb6 code for almost 9 years. Since mysql was released, then I decided to use it as database in my projects. Then I've found on the internet an amazing tool to easily connect and manipulate data, this tool was Vb2MySQL. I always use this tool in all my projects. I think you should try this tool.

 

-reply by Supriyanto

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×
×
  • Create New...

Important Information

Terms of Use | Privacy Policy | Guidelines | We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.