Shortcut to Create & Test Connection Strings

Ever wanted to quickly test out a Database Connection or verify if the driver is installed based on a connecting string without having to bring the site or application up and running.

Create a Text file and call it “Test.udl”. Double click the file and see you can quickly select the driver, provide the credentials and test it out. You also have the option of saving the connection string back to the file along with the password.

Comes in real handy with some legacy apps.

Advertisements

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s

%d bloggers like this: