Re: Using commit/rollback with Oracle and RDO

In article <343ae38d.0_at_news.pacifier.com>,   tkupp_at_pacifier.com (RastM) wrote:
>
> We have:
> VB 4 applications running on NT 4.0 machine
> VB 5 ODBC driver V2.? (because it works)
> RDO V1.?
> SQL*Net V2.3
> Oracle V7.3.2 database on SCO UNIX server
>
> We are trying to figure out how to use stored procedures and
> commit/rollback with RDO. We try doing things like
>
> rdoConn.BeginTrans
> ret_cd = rdoConn.CreateQuery ('{call stored_proc (?, ?) }')
> if ret_cd = good_Query then
> rdoConn.EndTrans ' or whatever a "commit" equivalent may be
> else
> rdoConn.Rollback ' or whatever the syntax is for a rollback
> end if
>
> and also substituting "rdoConn.Execute ('commit')" for EndTrans, etc.
>
> With any method, committing or rolling back do not seem to work.
> Everything always ends up being committed. Any suggestions? Code
> examples would be nice. Would going to RDO V2 help? We will also be
> trying to call multiple stored procedures in a row, trying to ipmlement
> the ability to rollback all the way before the calling of the first stored
> procedure. Any special things to watch out for there? If anyone knows of
> a relevant Microsoft knowledge base article, please let me know.
>
> --
> tkupp at pacifier dot com

Hi ,

I also tried out the same thing with oracle odbc driver and asked worldwide technical support for this. They accepted it as bug and couldn't give any solution. According to my knowledge you can either acquire odbc driver from open link software which has got option to set this flag(auto commit )off or use ODBC API'S to solve this problem.If you use ODBC API then you have to do lot of coding. The API to set this flag off is

rc = sqlsetconnectoption(hdbc, SQL_AUTOCOMMIT, sQL_AUTOCOMMIT_OFF)

Regards
Arvind

-------------------==== Posted via Deja News ====-----------------------
      http://www.dejanews.com/     Search, Read, Post to Usenet