Stored Procedure transactions through ODBC ( CLI 2.8 )

Posted in 2000

Topics: Stored Procedures & SPL, Connectivity: ODBC / JDBC / .NET, Server Administration

o mega — Mon, 21 Feb 2000 06:32:18 -0800 (PST) — source: Informix-list mailing list archive (1991-1998)

Hi, I am having a problem with running a STored procedure through CLI 2.8. This procedure has begin / commit work. The problem is when you run through the CLI driver 2.8 or intersolve 3.5 it comes out saying "Transaction not available". But when you run this on dbaccess , it works perfectly. I am using Progress 9.0B as the front end. Can anyone help me please. Thanx, Teddy. __________________________________________________ Do You Yahoo!? Talk to your friends online with Yahoo! Messenger. http://im.yahoo.com

↪ replying to o mega

Rudy Fernandes — Tue, 22 Feb 2000 08:20:15 -0500 — source: Informix-list mailing list archive (1991-1998)

Recheck that you are trying both (dbaccess & ODBC) against the same database on the same Informix Server. Rudy o mega wrote: > Hi, > > I am having a problem with running a STored > procedure > through CLI 2.8. > > This procedure has begin / commit work. The problem > is when you run through the CLI driver 2.8 or > intersolve 3.5 it comes out saying "Transaction not > available". > > But when you run this on dbaccess , it works > perfectly. > > I am using Progress 9.0B as the front end. > > Can anyone help me please. > > Thanx, > > Teddy. > __________________________________________________ > Do You Yahoo!? > Talk to your friends online with Yahoo! Messenger. > http://im.yahoo.com

Glossary

dbaccess