Hello, I am trying to find the correct connection string when using the Data tools in Navisworks. I have installed the SQLite3 Drivers also. I have tried the 2 methods allowed from with the Data tools configuration window. These are 2 different connections stings I researched on the web. We are using Navisworks 2023.
Sample: DSN=myDsn;Uid=myUsername;Pwd=;
1. Created a system DSN=(Test) that connects to the database needed.
2. Connection string used : DSN=(Test);
3. Select statement: SELECT * FROM [PipeLines] WHERE "PET_PLG_LNumber" = %prop("AutoCad", "Line Number");
Sample: RIVER=SQLite3 ODBC Driver;Database=c:\mydb.db;LongNames=0;Timeout=1000;NoTXN=0;SyncPragma=NORMAL;StepAPI=0;
1. Installed the SQLite3 Drivers
2. Select statement: SELECT * FROM [PipeLines] WHERE "PET_PLG_LNumber" = %prop("AutoCad", "Line Number");
I have tried both of these and can not seem to connect to the databases to retrieve the data.
When I use I-Constructs Data Link method using the ODBC System DSN, it works like it should and reads the data. Any ideas would be help full.
