Wednesday, October 7, 2020

MySQL ODBC Driver:

These instructions assume you have installed MySQL locally or you are connecting to a cloud hosted MySQL database. 

And you have created the Parts schemas and tables in the MySQL database. 

Note if are using a hosted MySQL solution then Download MySQL Workbench

You must have a MySQL user account with the appropriate permissions.

Install ODBC Drivers for MySQL and Altium:

Then try Connecting to your MySQL database again.



Jan 2024 - Recommended MySQL Configuration for Local Area Networks















As of 9/17/2023

For MySQL 8.0 use ODBC Driver 8.00.32.00 or Older !

MySQL ODBC Drivers (newer than 8.00.32.00) are NOT compatible with Office 365  and Access 16, please install MySQL ODBC driver 8.00.32.00 or an older version of MySQL ODBC driver 8.xx.xx.xx.

After completing the above steps.

In Altium create a *.DBLIB library that is linked to the MySQL parts database.


If Altium fails to connect  . . .

Then try Connecting to your MySQL database again.

Troubleshooting ODBC Connections:

In the Windows Search Box enter ODBC

Open ODBC x64 and select the Drivers Tab

Verify the MySQL the ODBC 8.x ANSI Driver is installed

Tip: 

Select the Archives Tab to locate older versions of MySQL ODBC Drivers.











Contact Parts if you have questions or need technical support.

That's It !

No comments: