>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
Why you need DSN when you could use SQLSTRINGCONNECT()?
Just put the whole string in SQLSTRINGCONNECT() and connect to server.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.