Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

OLEDBCONNECTION and Autocommit

2 posts in DataWindow .NET Last posting was on 2004-11-01 07:41:55.0Z
Peter Müller Posted on 2004-10-28 15:08:30.0Z
From: "Peter Müller" <Peter.Mueller@gmx.net>
Newsgroups: sybase.public.datawindow.net
Subject: OLEDBCONNECTION and Autocommit
Lines: 16
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
NNTP-Posting-Host: ex.sms-eumuco.de
X-Original-NNTP-Posting-Host: ex.sms-eumuco.de
Message-ID: <41810b6e$1@forums-1-dub>
Date: 28 Oct 2004 08:08:30 -0700
X-Trace: forums-1-dub 1098976110 195.126.202.3 (28 Oct 2004 08:08:30 -0700)
X-Original-Trace: 28 Oct 2004 08:08:30 -0700, ex.sms-eumuco.de
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.datawindow.net:632
Article PK: 125059

I am using a OLEDBCONNECTION and I bind a AdoTransAction to it.

Question 1:
Is there any possibility to set it to AUTOCOMMIT ??

Question 2:
Is there a possibility to make a commit without BeginTransAction()



Thanks
Peter


Serg Posted on 2004-11-01 07:41:55.0Z
From: "Serg" <sergNOSPAM@alef.ru>
Newsgroups: sybase.public.datawindow.net
References: <41810b6e$1@forums-1-dub>
Subject: Re: OLEDBCONNECTION and Autocommit
Lines: 36
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.3790.181
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.181
X-Original-NNTP-Posting-Host: 62.5.252.66
Message-ID: <4185f6ce@forums-2-dub>
X-Original-Trace: 1 Nov 2004 00:41:50 -0700, 62.5.252.66
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 1 Nov 2004 00:41:52 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 1 Nov 2004 00:41:55 -0700
X-Trace: forums-1-dub 1099298515 10.22.108.75 (1 Nov 2004 00:41:55 -0700)
X-Original-Trace: 1 Nov 2004 00:41:55 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.datawindow.net:647
Article PK: 125074

Hi, Peter.

If you use MSSQL then

SET IMPLICIT_TRANSACTIONS OFF is the same as AutoCommit=TRUE
SET IMPLICIT_TRANSACTIONS ON is the same as AutoCommit=FALSE

if you use SET IMPLICIT_TRANSACTIONS ON then there is no need for
IDbConnection.BeginTransaction()
if you use SET IMPLICIT_TRANSACTIONS OFF then you should each time use
IDbConnection.BeginTransaction()

Regards,
Serg

"Peter Müller" <Peter.Mueller@gmx.net> wrote in message
news:41810b6e$1@forums-1-dub...
> I am using a OLEDBCONNECTION and I bind a AdoTransAction to it.
>
> Question 1:
> Is there any possibility to set it to AUTOCOMMIT ??
>
> Question 2:
> Is there a possibility to make a commit without BeginTransAction()
>
>
>
> Thanks
> Peter
>
>
>
>