To read the article online, visit http://www.4GuysFromRolla.com/webtech/070400-1.2.shtml

Creating Connection Strings in Windows 2000, Part 2

By Björn Nilsson


  • Read Part 1

  • In Part 1 we looked at the first three steps to creating a connection string in Windows 2000. In this part we'll look at the remaining three.

    4.) In this example I want to make a DSN-less connection to an Access-DB. I do this by clicking the "Provider" tab and choose a Jet-type connection. (If you want to make a DSN-less connection to SQL-server or Oracle, click that one instead.)
     

     
    5.) Now click the "Next >> " button and you can type in or browse for the Access database that you want to connect to. Add or change the login part to whatever suits your needs. Testing the connection at this stage is recommended. :-) If the test connection succeeds, which it should unless you use ridiculously long and difficult to type usernames and passwords like I've done in this example, click OK.
     

     
    6.) All rignt, you're almost there. Now drag the icon of the UDL file from your (File)Explorer window onto a Notepad window and there you will see something like this:
     
    Click to view a larger image
     

    Now it's just a matter of cutting and pasting the line into your connection parts of your ASP pages.

    If you long for the Windows NT way of creating connection strings in Windows 2000, simply follow the tip provided by alert 4Guys reader Dennis Mulder:

    On Windows 2000 you certainly don't have the option to select new Microsoft Data link, we used to on Windows NT 4.0. However, you can add this option! In the following directory (on win2k) is a .reg file that just adds this option for you: C:\Program Files\Common Files\System\Ole DB\newudl.reg
    [Download these Registry File Enhancements (for Windows 2000)]

    Happy Programming!

  • Björn Nilsson


  • Article Information
    Article Title: Creating Connection Strings in Windows 2000, Part 2
    Article Author: Björn Nilsson
    Published Date: Tuesday, July 04, 2000
    Article URL: http://www.4GuysFromRolla.com/webtech/070400-1.2.shtml


    Copyright 2017 QuinStreet Inc. All Rights Reserved.
    Legal Notices, Licensing, Permissions, Privacy Policy.
    Advertise | Newsletters | E-mail Offers