>Hello Alex, thanks for the reply.
>
>>Not sure why it works in one mode and not the other but it could be you created a User DSN and the COM version does not run under your username but the system account.
>
>I deleted the user dsn and recreated it as a system dsn. No change.
>
>>Why not get rid of the DSN altogether and go DSNLess with SQLSTRINGCONNECT() instead?
>
>Tried
>SQLSTRINGCONNECT('Driver={SQL Server};Server=(local);Database=MyDatabase;')
>SQLSTRINGCONNECT('Driver={SQL Server};Server=(local);Database=MyDatabase;Trusted_Connection=yes')
>
>both of which returned a successful handle when called directly from VFP, but returned -1 when called via. a COM object from the ASP page.
>
>I'm stumped! Any further ideas would be appreciated.
>
>Regards,
>Alan


I see my next suggestion, after learning you use ASP is what Sergey already told, as ASP does not run under your name but an IUSR_ account.
Not sure what to try next after his suggestion.