1 / 4

Creating a Connection String

Creating a Connection String. Using Microsoft’s UDL Wizard (UDL = Universal Data Link). Creating a Connection String Making the my.udl file. On the Windows desktop, right-click an empty spot. When the Quick menu appears, choose New Text Document.

bunme
Download Presentation

Creating a Connection String

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Creating a Connection String Using Microsoft’s 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.

More Related