Re: Re: how to turn off ODBC auto-commit?

thanks... didnt realize you could do this with a GUI. the command line answer was helpful too. Thanks Dennis.
>
> From: Chip <ocp-dba_at_earthlink.net>
> Date: 2003/08/12 Tue AM 12:34:29 EDT
> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> Subject: Re: how to turn off ODBC auto-commit?
>
> Oracle ODBC Driver Configuration => Application Tab
> Batch Autocommit Mode (drop down list):
> 1) Commit only if all statements succeed
> 2) Commit up to the first failing statement (Oracle7 ODBC Behavior)
> 3) Commit all successful statements
>
> The 1st option is the default Oracle setting.
>
> Have Fun :)
>
> DENNIS WILLIAMS wrote:
>
> >Ryan
> > Then you're ahead of me. That's why I said "I think", thereby implying a
> >degree of uncertainty. I have worked with ODBC for many years and this
> >wasn't mentioned. I first heard of it when JDBC arose. I did a quick search
> >on Google for "odbc autocommit" and received 9000 hits. It looks like a
> >function odbc_autocommit() may toggle the behavior for you.
> >
> >Dennis Williams
> >DBA, 80%OCP, 100% DBA
> >Lifetouch, Inc.
> >dwilliams_at_lifetouch.com
> >
> >
> >-----Original Message-----
> >Sent: Monday, August 11, 2003 10:00 AM
> >To: Multiple recipients of list ORACLE-L
> >
> >
> >it says it is in tom kytes book. he says its there because ODBC is written
> >by microsoft and sql server needs to commit often because reads blocks
> >writes and you run into concurrency issues.
> >
> >
> >>From: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
> >>Date: 2003/08/11 Mon AM 10:44:29 EDT
> >>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> >>Subject: RE: how to turn off ODBC auto-commit?
> >>
> >>Ryan
> >>I don't think autocommit is a feature of ODBC.
> >>
> >>
> >>
> >>Dennis Williams
> >>DBA, 80%OCP, 100% DBA
> >>Lifetouch, Inc.
> >>dwilliams_at_lifetouch.com
> >>
> >>-----Original Message-----
> >>Sent: Saturday, August 09, 2003 8:54 PM
> >>To: Multiple recipients of list ORACLE-L
> >>
> >>
> >>There is a function to turn off the auto-Commit in the JDBC. Is there one
> >>for the ODBC? Id prefer to commit at the transaction level and not for
> >>
> >>
> >every
> >
> >
> >>statement.
> >>
> >>
> >>
> >>
> >>--
> >>Please see the official ORACLE-L FAQ: http://www.orafaq.net
> >>--
> >>Author: DENNIS WILLIAMS
> >> INET: DWILLIAMS_at_LIFETOUCH.COM
> >>
> >>Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> >>San Diego, California -- Mailing list and web hosting services
> >>---------------------------------------------------------------------
> >>To REMOVE yourself from this mailing list, send an E-Mail message
> >>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> >>the message BODY, include a line containing: UNSUB ORACLE-L
> >>(or the name of mailing list you want to be removed from). You may
> >>also send the HELP command for other information (like subscribing).
> >>
> >>
> >>
> >
> >
> >
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Chip
> INET: ocp-dba_at_earthlink.net
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: <rgaffuri_at_cox.net
  INET: rgaffuri_at_cox.net

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).