password in DSN

Results 1 to 2 of 2

Thread: password in DSN

  1. #1
    Join Date
    Dec 1969

    Default password in DSN

    I have a connection string to connect to a SQL Server Database but I need to add a password. Where does it go??<BR><BR>strconn = "DSN=Test;SERVER=Mail;UID=sa;APP=Microsoft Development Environment;WSID=Test;DATABASE=Test"<BR>strsql = "tblTest"<BR><BR>cheers<BR><BR>paul

  2. #2
    Join Date
    Dec 1969

    Default RE: password in DSN

    PWD=yourpassword;<BR>just stick this in anywhere i guess after the UID would be kind of logical

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts