Little known way to find a database connection string

For those who haven't programmed around database much, you may find gettting a database connection string difficult. However, this duanting task doesn't have to be hard.

 

  1. Open up a new word pad document
  2. Save the file with a UDL extention
  3. Open the file (if it still look like a text file, you will need to open with "OLE DB Core Services")
  4. Select your database server
  5. Select the log on server security type
  6. Select the database
  7. Test the connection
  8. Select ok
  9. Open the file with Notepad and see your connection string

(pictures below)

 

IncWorx

Comments for Little known way to find a database connection string


Leave a comment





Captcha