I can create an ODBC DSN and supply a user-id / password in the configuration to successfully connect to a SQL Server.

When I pass this DSN to SQLSTRINGCONNECT() or SQLCONNECT(), the user id gets defaulted in the logon prompt that pops up, but the password is not supplied by the DSN and the user has to manually enter the password.

How can I flow the password through? Do I have to use APIs to retrieve the user id and password from the DSN to supply as parameters?

Laterness,
Jon