Hi,
If you don't wish to use ODBC you can try GMySQL Type Library(Extension
library for libmysql.dll).Interface between VB or VBA and MySQL API
functions.
You can download it from :
http://www.a1vbcode.com/app.asp?ID=1764
or
http://www.simtel.net/pub/pd/59731.html
Regards,
Gelu
If you're in VB and want to connect to a mySQL database then why not use
myODBC? it's what it's there for.
A simple connection string would be:
strConnectionString="DRIVER={MySQL}; SERVER=server;
DATABASE=database; UID=username; PWD=password;"
To access and manipulate the data use ADO: