thanks... didnt realize you could do this with a GUI. the command line answer was helpful too. Thanks Dennis. > > From: Chip <[EMAIL PROTECTED]> > Date: 2003/08/12 Tue AM 12:34:29 EDT > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > 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. > >[EMAIL PROTECTED] > > > > > >-----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 <[EMAIL PROTECTED]> > >>Date: 2003/08/11 Mon AM 10:44:29 EDT > >>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > >>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. > >>[EMAIL PROTECTED] > >> > >>-----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: [EMAIL PROTECTED] > >> > >>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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: <[EMAIL PROTECTED] INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
