DSN problem

[aspfun]

I used dsn file as below to link a SQL server.
Everytime need to input password, why? How to void it?

[ODBC]
DRIVER=SQL Server
UID=sa
PWD=holiday
DATABASE=Order
WSID=ASPFUN
APP=Microsoft Data Access Components
SERVER=111.222.333.444

 

[HiTechCoach]

I used dsn file as below to link a SQL server.
Everytime need to input password, why? How to void it?

[ODBC]
DRIVER=SQL Server
UID=sa
PWD=holiday
DATABASE=Order
WSID=ASPFUN
APP=Microsoft Data Access Components
SERVER=111.222.333.444

Are you using linked tables in Access? Did you store the password when you created the link?

 

[aspfun]

yes, I use linked table.
I want to store PWD in dsn file so that I do not need enter PWD every time.
Can I do it?

 

[HiTechCoach]

yes, I use linked table.
I want to store PWD in dsn file so that I do not need enter PWD every time.
Can I do it?

AFAIK, you do not store the password in the DSN, but in the linked table in Access.

When you create the linked table, you can have it store the password. You might have to delete the liked tables and create them again sot hat you can store the password. Be sure to select the option to save the password.