Object in a zombie state

[Rocketfuel]

Hi

I have a program that extract data from multiple tables into one table on DB2. Recently I have changed the program to output the extract table to SQL Server 2005. I then got the error ITransaction::Commit or ITransaction::Abort was called, and object is in a zombie state.

Any help on this error would be greatly appreciated.

Thanks very much.

[QVeen72]

Hi,

When you open the recordset, You have to set property :
"Preserve On Commit" =true..
Check This

Regards
Veena

[Rocketfuel]

Hi,

When you open the recordset, You have to set property :
"Preserve On Commit" =true..
Check This

Regards
Veena

Hi

I have tried that, I am still getting the same error message. I am using the BeginTrans and CommitTrans in the code. I suspect that I might be using the wrong provider, would

"Provider=SQLOLEDB;Data Source=ServerName;Initial Catalog="Playground";"Integrated Security=SSPI;"

work with above.

Thanks for your reply.

[Rocketfuel]

Hi

I have tried that, I am still getting the same error message. I am using the BeginTrans and CommitTrans in the code. I suspect that I might be using the wrong provider, would

"Provider=SQLOLEDB;Data Source=ServerName;Initial Catalog="Playground";"Integrated Security=SSPI;"

work with above.

Thanks for your reply.

Hi

Please ignore previous post, Preserve on Commit did work, I had it in the wrong procedure. You can also use

Recordset.Requery()

.

A million thank you`s to Veena, you really did save my life.

Regards
Caleb