odbc - start transaction - open query - new process

I try to do:
- open transaction
- open cursor nr 1
- open cursor nr 2
- insert
- commit

for cursor nr 2 and for insert new connection establishes

When next time I try to do the same I gen dead lock

What for is this new connection (what should I do - it makes probles)
Any suggestions?I'm not sure, just guessing (not too great with cursors)
are you closing your cursors?|||I close them but after insert

When I close cursor befour open next curosr or insert there is no problem. It happens only during transaction

Thx for replay