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:
Post a Comment