ODBC Passwords

[Goofy]

Hi

I have set up and ODBC DSN For SQL Server which works fine. The problem is
that I dont want microsoft applications to ask for the password each time.
Can someone tell me what I need to do to sort this out.

Many Thanks.

 

[Vincent Xu [MSFT]]

Hi,

If you are using File DSN, you can find it at :

C:\Program Files\Common Files\ODBC\Data Sources

use notepad to open it, you will find UID which specified the login user
name. You can use PWD to specify the password.

Check following article for more parameters.

<http://msdn.microsoft.com/library/en-us/vdbref/html/dvhowspecifyingdsnparam
eters.asp>

Thanks.

Best regards,

Vincent Xu
Microsoft Online Partner Support

======================================================
Get Secure! - www.microsoft.com/security
======================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others
may learn and benefit from this issue.
======================================================
This posting is provided "AS IS" with no warranties,and confers no rights.
======================================================



--------------------