Re: Cannot create a new connection because in manual or distributed transaction
From: Viatcheslav V. Vassiliev (support_at_oledbdirect.com)
Date: 02/05/04
- Next message: hobby16: "how to do automatic refresh"
- Previous message: Viatcheslav V. Vassiliev: "Re: slow ADO refresh, ending in error message"
- In reply to: Deck: "Cannot create a new connection because in manual or distributed transaction"
- Next in thread: Deck: "Re: Cannot create a new connection because in manual or distributed transaction"
- Reply: Deck: "Re: Cannot create a new connection because in manual or distributed transaction"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Date: Thu, 5 Feb 2004 10:15:21 +0300
If you are using MS SQL Server, it is
CAUSE
The Microsoft OLE DB Provider for SQL Server does not allow more than one
active connection within the scope of a transaction.
RESOLUTION
Use a server-side or client-side cursor other than the forward-only and
read-only (often called a firehose) cursor.
Look Q272358 in MSDN for more info.
//------------------------------------------
Regards,
Vassiliev V. V.
http://www.managed-vcl.com - using .Net objects in Delphi for Win32 +
ADO.Net
http://www.oledbdirect.com - The fastest way to access MS SQL Server,
MS Jet (Access) and Interbase (through OLEDB)
"Deck" <d@d.com> сообщил/сообщила в новостях следующее:
news:40217292$1@newsgroups.borland.com...
> Randomly, our users are receiving this exception.
> And we cannot identifiy the scenario causing
> it so its very difficult to trace where the problem
> lies. What's really causing this error?
>
> TIA
>
>
- Next message: hobby16: "how to do automatic refresh"
- Previous message: Viatcheslav V. Vassiliev: "Re: slow ADO refresh, ending in error message"
- In reply to: Deck: "Cannot create a new connection because in manual or distributed transaction"
- Next in thread: Deck: "Re: Cannot create a new connection because in manual or distributed transaction"
- Reply: Deck: "Re: Cannot create a new connection because in manual or distributed transaction"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Relevant Pages
|
