Tip: building connection strings from scratch

Here’s a tip posted by someone on the VB-DATA list. It’s already come in handy for me once or twice. Click “read more” for details….—–Original Message—–
From: Discussion for Microsoft Visual Basic Data Access
[mailto:VBDATA-L@PEACH.EASE.LSOFT.COM]
Sent: Monday, August 26, 2002 12:13 PM
To: VBDATA-L@PEACH.EASE.LSOFT.COM

Subject: Re: Web Site for OLEDB connection strings

Just to add to the URL that others have posted….

The method I use to get a connectionstring is to create an empty file with the file extension, “UDL”

Then I open the file, which launches the “Data Link properties” dialog I select the Provider I want to use, and al the criteria (servername, etc), then hit OK

Then I open the file in Notepad to find one conenction string..ready for copying and pasting into the source editor/config file/whatever

See also:

Common connection strings