>>I am trying to connect to an ODBC data source with a VFP COM object in MTS. I
>>can instantiate the object locally with the same ODBC settings and I get a
>>connection, but when I try to activate the object through an ASP, it returns -1
>>(no connection). What am I missing.
>
>Log the results of AERROR(): that will help you track it down.
>
>Is the web server your development machine? If not, is ODBC properly set up on the web server?
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
Wayne Myers, MCSD
Senior Consultant
Forte' Incorporated
"The only things you can take to heaven are those which you give away" Author Unknown