Is is possible to store username/password with the ODBC DSN?

[Tommy Hayes]

Hello all,

Is there any way to specify a default username and password in ODBC
DSN settings? Perhaps by a manual registry edit?

Up to now we've been using Windows Authentication to connect to the
database so username and passowrd weren't an issue. However we now
need to change over to native SQL Server authentication, and so either
we find a way to pass the username/password automatically or we have
to change the code in a number of applications to pass it manually.
We'd prefer the automatic way :)

Many thanks,
Tommy.

[Pak-Ming Cheung [MSFT]]

For security purpose, we don't store password in ODBC DSN settings.
Therefore, there is no way to automatically login except "trusted connection".
It is recommended to use "trusted connection", if it is possible.

Thanks,
Ming.
MDAC Team, Microsoft.
====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

[Pak-Ming Cheung [MSFT]]

After more investigation, file DSN can store password information. You can
add a line "PWD=xxxx" in the file DSN. However, for secure purpose, it is not
recommended to store the password in plain text. Or you have to make sure the
file DSN is porperly secured by windows ACL.

Thanks,
Ming.
MDAC Team, Microsoft.

==================================================

This posting is provided "AS IS" with no warranties, and confers no rights.

[pnolan....@gmail.com]

On Wednesday, 23 April 2008 03:21:00 UTC+1, Pak-Ming Cheung [ MSFT ] wrote:
> After more investigation, file DSN can store password information. You can
> add a line "PWD=xxxx" in the file DSN.

Hi, where exactly do I add this line?

[pnolan....@gmail.com]

Got it! :) "File DIN" tab.