Saturday, December 23, 2023

Altium DBlib - MySQL Connection String Example

DRIVER={MySQL ODBC 8.0 ANSI Driver};SERVER=server.com;OPTION=3;PORT=3306;DATABASE=parts;USER=username;PWD=password;PERSIST SECURITY INFO=True;

Change server.com to your Hostname.
Change username and password as needed.

Bug:  If you open an existing DBlib that was connected to Access and edit the connection string for a MySQL connection the connection will most likely fail.  

Solution: Enter the MySQL connection string, then Save, Close and Open the DBLib.

That's it!

No comments: