Accessing MySQL on Linux from Window

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.

Tks
John

Re: Accessing MySQL on Linux from Window

"zMisc" wrote in message
news:L9kCf.228352$V7.137693@news-server.bigpond.net.au...
> 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?

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:
http://dev.mysql.com/doc/refman/5.0/en/odbc-connector.html

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.

Regards,
Bill K.