ObjectContext.SetComplete - runtime error

[ashaig]

This is a "works on my PC, but not on ISP's server" problem.
I have an ASP script which is running under MSDTC. The error message is "Object doesn't support this property or method " Error no. is 800A01B6. Current debugging indicates that there are no errors from the SQL execs, script runs through as far as ObjectContext.SetComplete statement and then falls over.
My ISP thinks its a backward compatibility problem. They are running IIS5/MS 2000/SQL 2000, I'm running IIS4/NT 4.0/SQL 7. As I said works perfectly on my PC!
The code is too long for me to post here, but will e-mail to any kind person who thinks they might be able to help.

 

[shaddow]

Do you create any ASP class objects? ________
George, M

 

[ashaig]

Just ADO Command objects for building up parameters etc., and ADO Connection object of course.

 

[shaddow]

Post just the connection to the database... ________
George, M

 

[ashaig]

Hi,
I have starred out the password, if that's OK by you.

var sdbConnString = "Provider=SQLOLEDB;Password=********;User ID=highlandwedding;Initial Catalog=highlandwedding;Data Source=thecount";

The error can be seen at

http://www.highlandwedding.com/test

Click on
"weddings/isle-of-skye/entertainment" Then add an item to plan and follow options for "Save Plan" The error is in UpdateInsert.inc called from
ProcessPlan.asp.