I get an error while saving to a SQL Server Database.

[rarubio1]

I have written a VB6 application that retrieves and saves information to a SQL Server database. Everytime the application tries to save to the database I get the following error:

cannot start more than one transaction on this session.

Can anyone please let me know how to get rid of this error. Is there anyway to stop an active session?

Thank you,
RR

 

[pkailas]

without some of your code to see, hard to help.

 

[chiph]

Somewhere in your you have a begin transaction without a matching rollback or commit.

Most DB providers don't support nested transactions.

Chip H.


____________________________________________________________________
Click here to learn Ways to help with Tsunami Relief
If you want to get the best response to a question, please read FAQ222-2244 first