Connecting to SQL Server Using User DSN

  • Does anyone know how to hardcode a password into a user dsn connection string?

  • it's easy using a file dsn - but as i remember (unless anyone can contradict me) impossible with a userdsn

    MVDBA

  • Thanks Mike. I'll try using the file dsn.

  • you can find the contents of your file dsn's at c:\program files\common files\odbc

    you can then edit one of them and add the PWD=mypassword or PASSWORD=mypassword line to the file

    MVDBA

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply