Or you can go to 'C:\Program Files\Common Files\System\Ole DB' directory and double click on 'newudl.reg' file to turn it on or 'nonewudl.reg' to turn it off again.
>Pull up your registry editor and find the
.UDL key under
HKEY_CLASSES_ROOT.
>
>Add a key called
ShellNew. Then, add a new String Value called
NullFile. Do not modify anything else.
>
>From then on, when you right click and hit New, you'll be able to create a new Microsoft Data Link.
>
>Alan
>
>>If you use the jumpstart document mentioned in one of the other replies you should note that the right click method for createing a new data link file mentioned may not work -depending on your operating system. To create one in this situation you create an empty file with a .udl extension and once it is created then double click on it in explorer to create the real file. The article was done in 1999 and never updated to reflect this. That little detail caused me a good bit of grief.
--sb--