To read the article online, visit

Creating Connection Strings in Windows 2000

By Björn Nilsson

In a former article, A Nifty Way to Create Connection Strings, Volker S. pointed out a simple and fool-proof way of creating connection strings with a wizard built into Win98 and WinNT. The way that is described in the original article doesn't work in Win2000 though. Here's a revised description of how to do it, with some screen-shots and an example of how to create a DSN-less connection to an Access DB:

1.) Open up a (File)Explorer window in which you right-click and choose "New" -> "Text Document"

2.) Change the name of the newly created text document to some filename with the file ending ".udl". This will make it a "Universal Data Link" document.

3.) Now double-click the file, and a wizard will appear. This is where you tell which database etc. that you want to connect to.
Click to view a larger image

Steps 4 through 6 are available in Part 2!

  • Read Part 2

  • Article Information
    Article Title: Creating Connection Strings in Windows 2000
    Article Author: Björn Nilsson
    Published Date: Tuesday, July 04, 2000
    Article URL:

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