
Using ADO.NET • Chapter 9 419
Exercise 9.1 Creating a Connection String
1. Create a file with the name MyConnection.txt and then rename it to
MyConnection.udl.After opening MyConnection.udl from Explorer,
the Data Link Properties dialog box shown in Figure 9.1 appears.
2. Select the Provider tab and then pick your OLE DB provider. Figure
9.2 is an example of the provider-specific dialog that will prompt you for
information for building a SQL Server connection string.
The resulting text will look something like this:
[oledb]
; Everything after this line is an OLE DB initstring
Provider=SQLOLEDB.1;Password=;Persist Security Info=True; _
User ID=DBUser;Initial ...