URGENT!!! COM+ IIS WONT WORK

[NevG]

Hi people

This is a very urgent problem so any help will be amazingly appreciated

I have a cOM+ component with several methods in it for doing things like creating xml strings for parsing into a stored proc on a sql 2000 box.

My problem is that these work fine through VB but not IIS. I have sufficient transaction settings and have checked the outputs of my methods and all is fine.

I have 1 methid that as a pram takes a type (either New or Update) to determine whether it is calling a Insert or Update SP. The save New works fine in ASP but not the UPDATE where both work fantastically well in VB 6.

Please help me

Nev G

 

[espar]

I have had similar problems.

'I have sufficient transaction settings '

If this is a transaction problem....

There appears to be a problem with transactions in a web environment.

We just turned off transactions - but this may not be acceptable for you.

If you need transactions - try running the transaction for particular sql statements and creating and then destroying the connection for each - i believe the problem occurs with multiple sql statements (nested sort of) where a transaction is started within another transaction.

Hope this helps.