Connection Strings (OLEDB)

Connection Strings

Infiniti uses connection strings to establish a connection to an external data system. For web services or RSS feeds, the connection string will simply be the URL that points to the required service.

For OLEDB and ODBC data sources, the connection string identifies all the properties necessary to establish a connection, including the data provider, security information, database source and name.

A simple way to build a connection string to an OLEDB or ODBC source is to create and configure a Universal Data Link (.udl) file. This file, once created, contains a valid connection string that can be inserted into Director using copy and paste. For information about Universal Data Link files, refer to the MSDN article Creating and Configuring Universal Data Link (.udl) Files



Once a .UDL file has been created and opened, you will be presented with the Provider tab. If you are creating a connection string to a SQL Server, click on the appropriate Provider and click "Next". 



On the Connection tab, ensure you have filled in the relevant sections. It is very important to tick the "Allow saving password"; if this is not selected the password will not be inserted into the Connection String.

Click the "Test Connection" at the bottom of the Connection tab to test whether the Connection was successful. Click OK.

Opening in Text Editor

A UDL file when opened in a text editor such as Notepad will appear similar to the following: 

Everything after this line is an OLE DB initstring

Provider=SQLOLEDB.1;Integrated Security=SSPI;Initial Catalog=[db_name];Data Source=[sql_instance] 


Related Articles



UDL File OLE DB initstring open text editor test connection tab strings external data