Error -2147467259 w/ DB Tools Open Connect while using .exe

[wmorris77]

I am using LabVIEW 2015 (32-bit) and I am having an issue connecting to a SQL database while running the executable. The program works fine while in the development environment but once it's built the .exe won't connect. I'm connecting through the DB Tools Open connection default vi and feeding it a connection string from a config file.

Any help would be appreciated.

[aputman]

I assume you are on Win64.

Use the ODBC tool found in c:\Windows\sysWOW64\odbcad32.exe.

[aputman]

Also what does your connection string look like?  Are you sure that you're reading the connection string properly from the config file?  Do you have the proper path to the config?  Most often, when reading from a file works in DevEnv but not in EXE, there is an issue with the path. 

[wmorris77]

To remove that possibility, I have just hardcoded the connection string in the mean time.

[wmorris77]

This is the error that keeps showing up.

[aputman]

Did you try using the ODBC tool in the sysWOW64 directory to configure the connection?  Either the connection string is wrong or you are using the wrong ODBC tool.

[wmorris77]

The connection string is correct as I can access the database in the development environment and the string does not change. I'm not quite sure how to use the ODBC tool, and IT is not quite sure how it needs to be configured. Can you clarify on that?

[aputman]

What is your connection string?

[wmorris77]

Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=Test_Database;Data Source=SQLTEST

[wmorris77]

I've also tried a UDL which didn't change the outcome either.