I need to connect to MySQL and have not been able to do this using a custom Data Abstract server in Delphi, but I cannot connect to the same connection in Relativity Server. I’ve tried any combination of MySQL.net connectors that I could find online but haven’t had any luck. I’m using MySQL 5.5.7.29 because that is the last version with 32-bit drivers which are required to get through the DA project wizard for a custom server.
The error I get when trying to use the FireDAC based connection is:
Unknown driver FireDAC.
That string looks like this:
FireDAC?AuxDriver=MySQL;Port=4401;Server=localhost;Database=webadm;UserID=root;Password=passwordhere;
This makes sense since that driver isn’t listed and Relativity Server seems to be .Net based.
When trying to use the MySQL.Net Connector it claims it isn’t installed
Connection String Builder
An exception occurred on the server: Unable to find the requested .Net Framework Data Provider. It may not be installed.
Even though it is, according to the MySQL installer:
That string looks like:
MySql.NET?Port=4401;Server=localhost;Database=webadm;User ID=root;Password=passwordhere;
So, what am I doing wrong here? Is there a known-good version of the MySQL Connector for .Net that can still be downloaded that will work properly? I can use either MySQL 5.7 or 8.0, doesn’t matter to me.