Creating a Connection String

1
Creating a Connection String

• Using Microsofts UDL Wizard(UDL Universal
  Data Link)

2
Creating a Connection StringMaking the my.udl
file

• On the Windows desktop, right-click an empty
  spot.
• When the Quick menu appears, choose New?Text
  Document.
• When the Text Document icon appears, make its
  name be my.udl. Note UDL stands for Universal
  Data Link.
• Double-click the my.udl icon to launch the UDL
  wizard.

3
Creating a Connection StringRunning the UDL
wizard

• On the Provider tab of the UDL wizard, select
  Microsoft Jet 4.0 OLE DB Provider and click Next.
• On the connection tab, use the browse button to
  locate your database file.
• If your database has a password, set the
  credentials.
• Click the Test Connection button to make sure the
  settings work.
• Click OK to close the wizard.

4
Creating a Connection StringOpening the UDL file
as text

• Right-click the my.udl icon and choose Open
  With?Notepad. If the Choose Program dialog
  appears, choose Notepad.
• When the Notepad appears, you will see the
  connection string.