By removing this string, the call to the database should work. SQL Server 2008 - SqlConnection Connection String. Windows Authentication and SQL Server Authentication. SQL Server Database has two types of Connection Strings i.e.
Data Source=myServer\myInstance: The server name is "myServer" and the instance name is "myInstance"Ĭomparing this string with the one in the connection string in the ActiveX call, we can see that there is an extra string Integrated Security=SSPI. Here Mudassar Ahmed Khan has explained with an example, how to set SQL Server Connection String in AppSettings.json in.Initial Catalog=myDatabase: The name of the database on the server is "myDatabase".User ID=myUsername: The user name is "myUsername".
Persist Security Info=True: You will allow saving the password (password is saved in the udl file).Password=myPassword: The password is "myPassword".Provider=SQLOLEDB.1: The OLE DB provider is "Microsoft OLE DB Provider for SQL Server".
We can interpret the string in the following way:
Provider=SQLOLEDB.1 Password=myPassword Persist Security Info=True User ID=myUsername Initial Catalog=myDatabase Data Source=myServer\myInstance Chosing the Microsoft OLE DB Provider for SQL Server option, you could proceed through the rest of the connection details with the following details:Īfter clicking OK, you would generate a UDL file, containing the following string: SolutionWhen you create a UDL file from a LabVIEW VI, you would access that from the menu Tools✼reate Data Link.