Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

MTS and DB2: Only one transaction can be active on this session

Status
Not open for further replies.

marksg

Programmer
Jun 12, 2000
15
0
0
US
I am using odbc to connect to DB2 on the mainframe.  My ODBC configuration states that MTS is the TP Monitor.  However when I run two simple queries in one transaction and end successfully (run setcomplete) and then try to do an insert I get the error message: only one transactoin can be active on this session. Does any have any suggestions?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top