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

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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.
.