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