adodb transactions with sql server7.0 
Author Message
 adodb transactions with sql server7.0

hi guys
Im using an asp page for writing data to the db. The site calls several
select and insert statemants which depends on another. To make sure that I
cant get inconsistent data I use the Transaction method of the adodb
connection method (connection.begintrans). When I call the second insert
statement Ive got the sql error message:
"
Microsoft OLE DB-Provider fr SQL Server- Fehler '80004005'

Da der manuelle oder verteilte Transaktionsmodus aktiviert ist, kann keine
neue Verbindung erstellt werden.

Since the manual or distributed transaction mode is activated, no new
connection can be created.
"
any idea why this happen?
Regards
Bj?rn



Sat, 28 Feb 2004 19:14:13 GMT
 adodb transactions with sql server7.0

Running multiple commands in the same session, meeting the criteria
mentioned in the "Symptoms" section of the following article, causes
SQLOLEDB to open a new connection. This causes the error message you
received. The article recommends using a server-side or client-side cursor
other than a forward-only or read-only cursor.

Q272358 PRB: SQLOLEDB Allows Only One Connection in Scope of Transaction
http://support.microsoft.com/support/kb/articles/q272/3/58.asp

Please do not send email directly to this alias.  This is our online
account name for newsgroup participation only. This posting is provided "AS
IS" with no warranties, and confers no rights. You assume all risk for your
use. ? 2001 Microsoft Corporation. All rights reserved.



Sun, 29 Feb 2004 23:37:53 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. SQL Server7 linking to another SQL Server7 database.

2. SQL Server7 linking to another SQL Server7 database.

3. How to view transaction log in SQL Server7

4. How to set transaction boundary for sql server7 in Java

5. ADODB TRANSACTION ADO ERROR No Transaction is Active

6. How to control transaction using ADODB and Xorasession

7. ADODC versus ADODB; using transactions

8. ADODB Connection Object using transactions

9. Load SQL Server6.5 database in SQL Server7.0

10. Registering a sql server2000 box in Enterprise Manager v4(sql server7)

11. Visual C++6 / SQL Server7/ Connexion SQL DMO

12. Can I have a sql server7.0 db in SQL Server2000 with no changes


 
Powered by phpBB® Forum Software