Connecting to a SQL database with Navisworks Datatools

[a_village82]

I have been trying to connect to a SQL database with datatools and have been unsuccessful. The database has a column for name, status, and issues. The data in the name column matches the value in the DWF-Text tab in Navis. All I want to do is bring in a tab that has the status and issues in it. I would appreciate any help, thanks.

[bwilliams711941]

I'm pretty sure it's your SQL string. I can't quite read it properly, but I'm pretty sure that's your problem.

[j_menacker]

The SQL string must point to the value of the element property %prop("DWF - Text",value). It appears that the string in the image above is pointing to the element property name %prop("DWF - Text","Unit tag").

Of course the proper database driver must be selected and with a pointer to the database. It looks like you should have a table named "dbo.equipment" with a column named "name"?

HTH

Joe M