SilverTab

What would be the best way to access an online MySQL db from a VB app? Can I do it with ADO? (My program is already using ADO to access an Access DB...) I heard about MyODBC too, but would it worth using it since my program already use ADO?
(any place where I can find a sample connection string??)

Thinker

You use the OLEDB provider for ODBC data sources. This will use
myODBC. I am not aware of any other way using ADO.

SilverTab

Ok but, would it be easier to manage the queries with PHP for example, then execute them with a WebBrowser object from VB? Or should I access to the MySQL DB directly with VB?

Thinker

If you can only access the database via HTTP, then forget VB/ADO.
You should do it with PHP on the server. VB/myODBC/ADO is only
going to work if you can connect direct to mySQL via the IP
address/domain name of the server.

SilverTab

Ok I guess i'll have to ask my host about this one...
But if it turns out that I can access it, how would I found out the IP? (I guess my host would also fill me out on this one?) and where could I find connection string example??

JimCamel

There's code here which allows you to access a mySQL database using the IP/DNS without using ADO/DAO or OBDC (or so they say).