I've done it by installing the MyODBC driver on NT4.0 WS running VB6sp2, and
connecting to a RHLinux6.2 box running MySQL vs .36 -
I've only done it w/ ADO over the ODBC layer, and it seems to work fine,
however I am using disconnected recordsets and have not attempted binding a
control to the backend...
Good Luck.
ChrisB
MCSE MCDBA
-----Original Message-----
From: Cal Evans [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 29, 2001 11:14 AM
To: Thompson, Mike; [EMAIL PROTECTED]
Subject: Re: VBA/VB DAO/ADO MS Access to MySQL?
Yes it can, via ODBC.
I've never done it though. (I don't work in VB)
Cal
----- Original Message -----
From: "Thompson, Mike" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, May 29, 2001 12:37 PM
Subject: VBA/VB DAO/ADO MS Access to MySQL?
> 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
---------------------------------------------------------------------
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