catastrophic failure with transactions

[vin]

Hi, I hava a connection to SQL server - cnn
In a given sublime momement i do the
following

I use VB

cnn.BeginTransaction

//i do some stuff here

cnn1.CommitTransaction

From this moment on, the first try to do something
with some table from the connection i get
the message "Catastrophich failure".

Can anyone tell me how to manage with this transactions?
Thanks!

[vin]

Hi, It's me answering my own question.

I really need to do requiery after
committrans or rollback trans.

Thanks, myself, you were very glad to help myself.

Dear friend,
-------------------
cnn.BeginTransaction

//i do some stuff here

cnn1.CommitTransaction

------------------
You can not use transactions like this in VB.U can use in following way.try it out

cnn.BeginTransaction
// some code here
cnn1.BeginTransaction
// some code here
cnn1.CommitTransaction
// some code here
cnn.CommitTransaction

[Cimperiali]

...And yuor solution is interesting for me too, so thanks for sharing.
Cesare Imperiali

Special thanks to Lothar "the Great" Haensler. Come back soon, you Guru.