OLE DB Universal Data Link (.udl) files provide a convenient way to create and verify an ActiveX Data Objects (ADO) connection string that is used to connect to an OLE DB data source. The connection string information is persisted in a specific format to a file with the .udl extension. You can reference a .udl file in the ConnectionString property of an ADO.NET OleDbConnection object to specify the connection string that the object should use to connect to a database. Use the File Name parameter of the connection string to specify the name of the .udl file that contains the connection string information.
It is important to note the following information, which is taken from the "OleDbConnection.ConnectionString Property" article in the .NET Framework Class Library documentation (see the References section):
- Use the SQL Server OLE DB Provider to connect to one of your Microsoft SQL Server databases and create a .udl file named Test.udl in the root folder of drive C.
You can also use the Microsoft OLE DB Provider for Jet 4.0 to configure the .udl file to connect to a Microsoft Access 97 or 2000 database if you do not have access to a SQL Server database.For additional information about how to create a .udl file, click the article number below to view the article in the Microsoft Knowledge Base:189680 How To Use Data Link Files with ADO
- Open a new Visual C# .NET Console Application.
- Replace the default code in the Class1 module with the following code:
static void Main(string args)
OleDbConnection myConnection = new OleDbConnection("File Name = d:\\test.udl");
if (myConnection.State == ConnectionState.Open)
Console.WriteLine("Connection opened successfully!");
Console.WriteLine("Connection could not be established");
- In the statement that sets the ConnectionString property of the OleDbConnection object, modify the path to the .udl file if you created it with a different name or persisted it to a different location.
- Run the application from within the Visual Studio.NET Integrated Development Environment (IDE). A console window should open and display the text, "Connection opened successfully!" to indicate that the OleDbConnection object was able to use connection string information in the .udl file to establish the database connection.
- Press ENTER to dismiss the console window and stop the application.
For additional information, click the article number below to view the article in the Microsoft Knowledge Base:
Article ID: 308426 - Last Review: Mar 23, 2009 - Revision: 1