Here is a Very useful tip I found to create a connection string for any DB quickly without having to go search the web, etc.
to quickly generate a connection string you may use the following trick: fire up a command prompt in whatever writeable folder, enter "copy con test.udl" (w/o quotes) hit enter, F6, enter enter "test.udl" (yes the file you just created), you'll now see a dialog which will allow you to configure a database connection; select and fill the various options/parameters, test the connection and once all is ok, click the Ok button now open the file "test.udl" using notepad (or whatever editor capable of handling unicode) and your connection string will be right there :)
