ODBC Connection

[Rob]

Hello All,

I know that I have done this in the past. But, I can't remember how. I
would like to create an ODBC file that I can send to each user. This file
would have all of the connection information to SQL. I remember years ago
being able to create and ODBC connection file. If I placed this file on
another machine the User DNS was created automatically without having to have
them go to Control Panel - Administrative Tools - etc, etc.

Thanks,

Rob

 

[RD]

Hi Rob,

Sounds like you're talking about a UDL file. This uses OLE DB
providers. (There is one for ODBC data).

Here's how I create one:
* In any folder of your choosing right click and choose New then Text
File.
* Rename this file with some name that makes sense and with a
extension of .UDL. (MyConnect.UDL or whatever)
* Double click on it and a Data Link Properties dialog box will open
for you. Choose your provider and fill in the connection info.

Hope this helps jog your memory,
RD