>>Here is the result of the Aerror...
>>Only SQL_DRIVER_NOPROMPT is allowed when connection pooling is enabled
>>
>>I understand what that means, but what am I supposed to do about it?
>>
>>Wayne
>
>I wonder if you're not supplying enough information to ODBC to make the connection, so it's prompting you.
>
>-Mike
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
Wayne Myers, MCSD
Senior Consultant
Forte' Incorporated
"The only things you can take to heaven are those which you give away" Author Unknown