Create Connection Strings easily

The connection string may include attributes such as the name of the driver, server and database, as well as security information such as user name and password.

UDL file can be used to generate connection strings easily.

To create UDL file first create new text file and rename it from "filename.txt" to "filename.udl" that's it.

Now run filename.udl by double clicking it.

Data Link Properties window will open, select Provider Tab and select the provider you need and click next.

Now provide the details as required and click on test connection.

If you get success message, you are done.

Now open udl file as text file, connection string will be there in the last line.

Reference: Muthukumar (, CodeProject


Twitter Delicious Facebook Digg Stumbleupon Favorites More