In my Application,I use the LabSQL which connected to SQLServer.but it should build the DSN out of the application,I want to know if create the DSN in the application ,what should I do ?In the LabSQL ,what should be written in the "connection string " for the "ADO Open connection" ?Thanks in advance!

LabVIEW

Just in case someone else needed the same thing.

I had some issues with DSN and found that this made everything much easier.

Using LabSQl instead of a UDL file just enter the connection string directly or read from file:

connection string for SQL Server:

Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=DataBaseName;Data Source=SQLServerName\SERVER

Hope it helps

JCollado

Message 21 of 21

(667 Views)