Quickly Build SQL Connection Strings

Today I run on a post that explained how to obtain a connection string to a data source using only the explorer and an editor.

The steps are three and trully simple

  1. Create anywhere a blank file with a .udl extension
  2. Double Click the file, and create the connection from within the usual UI. You can even test the connection
  3. View/Edit the file and you will acquire the connection string
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