Accessing MySQL on Linux from Window

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

Threaded View
Is it possible to have a visual basic application running under windows and
access MySQL database on a Linux box?

Any extra drivers required for this?

Any help greatly appreciated.


Re: Accessing MySQL on Linux from Window

Quoted text here. Click to load it

Yes, you can use an ODBC datasource to access from VB a client/server
database on another host, such as MySQL on Linux.

You need the MySQL Connector/ODBC.  There are lots of docs available here:

You need to install the MySQL ODBC driver on your Windows PC, and then your
VB application can use that via ADO or whatever.  The SQL requests are sent
by the ODBC driver to the MySQL server, and result sets are returned to the
VB application.

Bill K.

Site Timeline