Thursday, June 23, 2005

Database Connection String Wizard

Here's a simple trick for generating connection strings to your database. On your windows desktop, create a file with the *.udl extension. You'll notice that the icon for the file changes. Now double-click on the file to open it. This will launch the wizard for creating your connection string. Be careful, the wizard starts on page two. Backup to the first page and pick your target database protocol. Then step through the wizard to complete building your connection string. When you are finished, right click the file and open it with a text editor. You'll see that it contains your connection string!

No comments:

Post a Comment