Friday, January 26, 2024

MySQL Configuration for Altium DBLib and Parts

Link to MySQL Community Downloads

Video Link https://youtu.be/W-L1IPFr2Fc

Recommended Download: MySQL Installer for Windows

Recommended Configuration for Altium DBLIB and Parts.


MySQL Server Version 8.0.36
MySQL Workbench Version 8.0.36
MySQL Connector/ODBC Version 8.0.32

Notes:

Connector/ODBC Version 8.0.32 is Highly Recommended for use with Parts.

Connector/ODBC Version 8.0.33 and higher are NOT Recommended for use with Parts.

Click on the Archives Tab and look for MySQL Connector/ODBC Version 8.0.32

In Altium . . . Create a New DBLib ! ! !

Open Altium > File > New > Library > Database > Create

Select Use Connection String
Enter Connection String
Advanced >  Enter tick marks > Ok
Connect

There is a bug in Altium . . .  if you edit an existing DBLIB the connection it may fail. 

Example Error msg in Altium DBLIB . . . 


Could not get column list for table . . . 

If the Altium DBLib connection to the server fails then try creating a new DBLIB.

That's it !

No comments: