Forum

I need to read and maybe write data from/to a database in MySQL 5 DBMS. Is it possible? And how can I do that?

Yes, its possible. At first you need driver, and then

ConnectionString = "DRIVER={MySQL ODBC 5.1 Driver};SERVER=localhost;Port=3306;
|DATABASE=someDatabase;UID=user;PASSWORD=pass;
|OPTION=3;STMT=SET CHARACTER SET cp1251";
Connection     = New COMObject("ADODB.Connection");
Connection.Open(ConnectionString);

Command = New COMObject("ADODB.Command");
Command.ActiveConnection = Connection;
Command.CommandText = "select id fr om table";
Command.CommandType = 1;
       
RecordSet = New COMObject("ADODB.RecordSet");
RecordSet = Command.Execute();
While Not RecordSet.EOF Do
     Message(RecordSet.Fields("id").Value);
     RecordSet.MoveNext();
EndDo;

I received the following error:

{ManagedApplicationModule(7)}: Error calling context method (Open)
Connection.Open(ConnectionString);
because:
An exception has occurred (Microsoft OLE DB Provider for ODBC Drivers): [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

check driver for proper installation
I use mysql-connector-odbc-5.2.2-win32.msi from mysql odbc driver

im not sure, but maybe win64 will approach too

and also remove text wrapping in connection string, I do it for nice view at forum

It works!
I have downloaded and installed Connector/ODBC 5.2.2 Windows (x86, 32-bit), MSI Installer Connector-ODBC and changed the driver name to MySQL ODBC 5.2w Driver. By the way, the 64-bit version did not appeared in MS Excel when I tried to create a new data source to get a list of available ODBC connectors.
Thanks to Ivan!

P.S.:
It works fine even without of this line:

RecordSet = New COMObject("ADODB.RecordSet");