This works fine from VB6. Install the MyODBC driver (get it from the
MySQL web site), then set up a datasource just as you usually would.
Ideally, you won't have to change any of your VB code - just bind the
ADO/DAO controls to the MySQL datasource rather than the Access
datasource.
Note that depending on your application, you may have to select
different options in the MyODBC datasource configuration. On my box
(Win2k SP2, MySQL 3.23.36) I got some irritating runtime errors with ADO
controls until I checked "Return Matching Rows" and "Change BIGINT
Columns To INT".
Ben
On Tuesday, May 29, 2001, at 12:37 PM, Thompson, Mike wrote:
> Howdy,
>
> I currently have an application which uses DAO and ADO coding in VBA/VB
> as
> well as databound objects in VB to access a MS Access database. Can
> DAO and
> ADO in VBA/VB and databound objects in VB be made to work with a MySQL
> database?
>
> Anybody done this successfully?
>
> Cheers,
> Mike
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php