ADOxtra for Macromedia Director

Can ADOxtra connect to mySQL database?

ADO (and therefore ADOxtra) can connect to any database via ODBC driver, if one is installed. MySQL provides an ODBC driver MyODBC, which allows using MySQL databases via ADO.

Note also, MyODBC is not installed on usual user's system. That is why there is probably no sense to use it from Shockwave... So remote databasing using ADO is actually possible with IIS web server only.

But it could be used from usual Director movie, which can install appropriate ODBC driver to a user's system.

MyODBC driver is available at www.mysql.com

The connection string for MyODBC looks like:
cnnString = "DRIVER={MySQL};Server=" & ServerDB & ";DB=" & Database & ";UID=" & User & ";PWD=" & Password ";"