Posted by: Charles Maitland | Wednesday 22 March, 2006

Neat way to get a connection string

One of the guys on the course came up with this usefull tip.

If you want to quickly get a connection string:

Create a new empty text document.

Rename it to have a .UDL suffix

When you double click it now you will get a standard data connection dialogue.

Once you set your connection and save it with “Ok” open the file in notepad and there is the connection string.

EDIT: Thanks to Christian Wade for the tip


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s


%d bloggers like this: