Connection String

Connection String

  1. Open Notepad
  2. Save the blank file as myConnection.udl
  3. Close notepad
  4. Double-click the udl file you just saved
  5. Fill it in and test it until successful
  6. Once succesful, close the udl
  7. Right-Click the udl and Open With Notepad

There’s your connection string.
Note: SQL client doesn’t require the
Providor element so you can remove that from the generated connection

The above was taken from this forum post: here.

Leave a Reply

Your email address will not be published. Required fields are marked *