Hi Jon.

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

The password isn't stored with the DSN: The one you enter when you create the DSN is used to verify the connection, but isn't stored for security reasons. You either need to prompt the user for the password every time or prompt them the first time and store it somewhere (encrypted, of course).

Doug