How to connect to a MYSQL server using Data Tools with and ODBC Drivers
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report
Hi,
I'm trying to connect Data Tools to a remote MySql Server, I have tried everything already and I don't know what else to do. I have a copy of the database with the same tables and data sets in a local MS SQL Express Server and it does works, thus I know the SQL String and Fields settings are right. The issue has to be with the Connection String.
Windows 7 64b
Navisworks Manage 2016 64b
MySql 5.6 in a remote server
MySql ODBC 5.3 64b Driver
SQL Express 2014 64b local
-- SQL String -- Confirmed working with local SQL Server
SELECT * FROM mytable;
-- Hold Open for application lifetime always checked
My first approach was to set a System DSN and have Navisworks to connect to this preconfigured DSN. the DSN works. I was able to query the db with ODBC Test (64b) a tool from Microsoft Data Access 2.8 so the DSN is working. Navisworks produced the following connection string after selecting the DSN from the dropdown.
DSN={navis};
This produces no tab, or error. I ran navisworks with the "-log" command but it didn't log anything relevant.
Second approach was to try to use the MySql driver directly with the following string. (with actual IP and Password of course)
Provider=MSDASQL;Driver={MySQL ODBC 5.3 ANSI Driver};Server=x.x.x.x;
Database=navisworks;User=root;Password=xxxxxx;Option=3;
This again produced no error. I tried many versions of this string, with-without provider, with-without driver brackets etc. I never produced an error or log an error. I also tried with Unicode driver and with previous drivers versions.
What else should I try?