Connecting to SQL Server Using User DSN

Question

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

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

MVDBA (Mike Vessey) SSC-Insane Points: 21797 More actions · Answer 1

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

MVDBA

Amy Sommer SSC-Addicted Points: 485 More actions · Answer 2

SSC-Addicted

Points: 485

March 17, 2006 at 10:54 am

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

MVDBA (Mike Vessey) SSC-Insane Points: 21797 More actions · Answer 3

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