Graphics

Hi

I am trying to access a MySQL database with Datalinq. I can't see the provider listed though, and installing the 32 bit (have tried 64 as well just in case!) connector version it still doesn't appear. So adding a MySQL database fails, as it can't find the provider.

I can connect to the database using the ODBC Data Sources in Windows, and can connect Datalinq to that via DSN. But I get nothing back when browsing the tables.  Enabling the Debug on the ODBC Data Source, it looks like Datalinq is talking to MySQL with Microsoft SQL Server SQL, which is why it is failing.

I'm on XPression v7.2 4000

Any ideas on how to get this going please? It looks like the issue is putting square brackets around the table name.

Thanks

Hello Simon,

In the datalinq configuration -> Advanced Tab , set the compatibility to "Mysql" .

Connection String for "MS SQL Server (ODBC)" template is something like this :

Provider=MSDASQL;
Driver={MySQL ODBC 5.3 Unicode Driver};
Server=[ServerName];
Database=[DataBaseName];
Uid=[UserName];
Pwd=[Password];
Port=[port];

Connection String for "Mysql" template looks like this :

Server=[ServerName];
Data Source=[DataBaseName];
Port=[port];
User Id=[UserName];
Password=[Password];

note that provider info is removed in this case

both template should work with a mysql database as soon as you set the compatibility to "mysql"

hope it helps,

Antoine

That's brilliant, thank you.

I can now connect via a DSN to the ODBC connection I had earlier and that works.

I can't get the MySql template above to work though. When I test the connection, I get "Data source name not found and no default driver specified". I get the same error when using the MSDASQL version above as well.

Simon