Matt Glace, a co-worker of mine showed me a cool trick for creating connection strings that I thought I would share.
- Create a blank text file on your desktop. But instead of saving it with a txt extension save it with a udl extension. Name it whatever you want. UDL stands for Universal Data Link.
- The icon should now show a little computer in it. Double-click on it to open it back up.
- Go through the tabs and fill out the information like you would in VS or SMS. Test conneciton and then save.
- Right click on the file but this time open with notepad. Your connection string is right there.