Database Connectivity Test with UDL File

I bounced around between projects a lot last week.  What each project had in common was the need to validate at least one SQL connection.  Whether you have SQL tools like SSMS installed or not, this is a very easy task if you are aware of the UDL (Universal Data Link) files. 

Create a new file and name it anything as long as it has the .udl extension. Open the file, choose a provider:

image

Click Next >> or navigate to the Connection Tab to provide connection information.  Once you provide server and login credentials, the database list will populate.  At this point, you know the connection is valid. but go ahead and click the Test Connection button anyway.

image

On the final tab, you can provide extra connection information like Application Name which can come in handy

image

The All tab is beneficial if you want to build a valid connection string to include in your own applications.  If you save the file and then open in Notepad, you’ll find that said connection string:

Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=master;Data Source=(local);Application Name=TestApp

I hope this tip helps save you some time.  How do you test if you don’t have SSMS installed?

Comments

  1. My wife and i got quite thankful Emmanuel managed to deal with his homework while using the ideas he acquired out of the site. It’s not at all simplistic just to happen to be giving out tips other folks have been selling. And we all grasp we’ve got the blog owner to give thanks to for that. The type of explanations you have made, the easy site menu, the relationships your site help to create – it’s many superb, and it’s really making our son in addition to us feel that this content is brilliant, which is wonderfully mandatory. Thanks for the whole lot!

closed