Board index » delphi » MDAC 2.6 bug (If you are being troubled by time-outs, pls come in)

XIA Chengbin

Delphi Developer
Sat, 27 Sep 2003 09:52:05 GMT

MDAC 2.6 bug (If you are being troubled by time-outs, pls come in)

Hello, everyone who is using MDAC 2.6 for multi-user development!
For the past week I have been delving into a very IMPORTANT bug with MDAC
2.6 transaction control and made a couple of posts here. Andy Markie also
reported this bug half a year ago. Yes, it's truly an unfixed bug, because I
finally find in Microsoft's Knowledge Base. Pls go to
http://support.microsoft.com/support/kb/articles/Q281/6/33.ASP for a
detailed discussion by MS, and refer to my earlier posts which are still
below here.

XIA Chengbin
China

 
XIA Chengbi

Delphi Developer
Sun, 28 Sep 2003 15:09:01 GMT

Re:MDAC 2.6 bug (If you are being troubled by time-outs, pls come in)


The cleanest work-around for this problem is:
Issue a 'set implicit_transactions off' statement in both
'OnCommitTransComplete' and 'OnRollbackTransComplete' events.

XIA Chengbin
China

Quote
XIA Chengbin <cb...@sina.com> wrote in message news:3ad26751$1_1@dnews...

> Hello, everyone who is using MDAC 2.6 for multi-user development!
> For the past week I have been delving into a very IMPORTANT bug with MDAC
> 2.6 transaction control and made a couple of posts here. Andy Markie also
> reported this bug half a year ago. Yes, it's truly an unfixed bug, because
I
> finally find in Microsoft's Knowledge Base. Pls go to
> http://support.microsoft.com/support/kb/articles/Q281/6/33.ASP for a
> detailed discussion by MS, and refer to my earlier posts which are still
> below here.

> XIA Chengbin
> China

Johnn

Delphi Developer
Mon, 13 Oct 2003 00:40:59 GMT

Re:MDAC 2.6 bug (If you are being troubled by time-outs, pls come in)


I see the 2 events for the connection object, but am unsure of how to
code the set statement within the handlers- can you demo the actual
snippit please?

thanks-

pritch-

On Wed, 11 Apr 2001 15:09:01 +0800, "XIA Chengbin" <cb...@sina.com>
wrote:

Quote
>The cleanest work-around for this problem is:
>Issue a 'set implicit_transactions off' statement in both
>'OnCommitTransComplete' and 'OnRollbackTransComplete' events.

>XIA Chengbin
>China

>XIA Chengbin <cb...@sina.com> wrote in message news:3ad26751$1_1@dnews...

>> Hello, everyone who is using MDAC 2.6 for multi-user development!
>> For the past week I have been delving into a very IMPORTANT bug with MDAC
>> 2.6 transaction control and made a couple of posts here. Andy Markie also
>> reported this bug half a year ago. Yes, it's truly an unfixed bug, because
>I
>> finally find in Microsoft's Knowledge Base. Pls go to
>> http://support.microsoft.com/support/kb/articles/Q281/6/33.ASP for a
>> detailed discussion by MS, and refer to my earlier posts which are still
>> below here.

>> XIA Chengbin
>> China

Other Threads

1. what is the Different of MDAC 2.6 vs MDAC 2.7

2. MDAC 2.6 / 2.7 woes

3. MDAC 2.6 SP2 Refresh Now Available

4. MDAC 2.6 SP1 and Jet OLEDB 4.0 SP6

5. Please Borland (ADOExpress and MDAC 2.6 SP1)

6. Does MDAC 2.6 have threading problems on multiple processor machines

7. MDAC 2.6 and ADO problem?

8. MDAC 2.6

9. Delphi 5 / Mdac 2.6 RTM / Win2000

10. MDAC 2.6 SP1