Friday, October 31, 2008

Creating connection strings for various sources

If you are like me, you are working with lot of different providers (ODBC, OLD DB, Analysis Services Cubes etc.). I can not remember the syntax of these connection strings. Sometimes I need this connection string to use it in my C# applications, sometimes I need them to work on PerformancePoint server etc.

So far this is the best way to create the connection strings. This tool saves the connectiong string in a text file.

1. Create a text with file with extension '.udl' and save the empty file.
2. Double click this file and enjoy....

Followers