>I think that is what the overall effect is... the connection pool manager in MTS wants this to be a PROMPTless connection and there is no way that I can see to set this up. If you look on MSDN, there is a reference to the NOPROMPT as being passed as a parameter to ODBC, but we don't have the option in VFP.
>????
>Wayne

I can think of a couple things to try. You must not be passing something when you're making the connection, like the password if you're hitting SQL Server using the sa login.

You can setup the connection to not prompt for missing information in the connection designer, if you're using VFP connections. You could also use SQLSETPROP() and reference connection 0 which will change you're default.

-Mike