How to connect to a MYSQL server using Data Tools with and ODBC Drivers

Anonymous — Fri, 29 Jan 2016 16:19:07 GMT

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?

Re: How to connect to a MYSQL server using Data Tools with and ODBC Drivers

Anonymous — Mon, 12 Dec 2016 18:50:34 GMT

Hi csaleman,

Any Luck? I am trying to and did the same things you had mentioned so far?

Thanks

Re: How to connect to a MYSQL server using Data Tools with and ODBC Drivers

Anonymous — Mon, 12 Dec 2016 21:07:52 GMT

I could't find a way. I gave up.

Re: How to connect to a MYSQL server using Data Tools with and ODBC Drivers

Anonymous — Fri, 21 Apr 2017 19:59:12 GMT

You could use an add-on like iConstruct to bring your data into the navisworks model.

You can download a free trial here:

https://iconstruct.com/download/

If you need some help to get set up or have me look at your data just give me a message.

topic Re: How to connect to a MYSQL server using Data Tools with and ODBC Drivers in Navisworks Forum

How to connect to a MYSQL server using Data Tools with and ODBC Drivers

Re: How to connect to a MYSQL server using Data Tools with and ODBC Drivers

Re: How to connect to a MYSQL server using Data Tools with and ODBC Drivers

Re: How to connect to a MYSQL server using Data Tools with and ODBC Drivers