| | |
| |
Active Server Pages what is asp programming how to sample asp example code scripts software asp forum mail sessions applications global.asa CJWSoft ASPProtect ASPBanner ASPClassifieds
(Advanced)
(Components)
(Database)
(General)
(Vbscript)
|
|
|
|
Subject: |
80004005-Unkown Error (with ASP,SQL, MTS) |
|
From: |
Thomas Gugler |
|
Date: |
5/19/2000 4:48:48 AM |
|
IP: |
195.230.40.3 |
The main Problem:
i use 1 connection,
call the first Select without error,
then the second in the same connection with the error.
(Microsoft OLE DB Provider for ODBC Drivers-Fehler 80004005
Unknown Error)
the connection-string (in the session-variable) is 100%ok, also
the SQL-Statements are 100% coorect, because i also can change the 2 selects, and i always get on the second this error.
here is the ASP-code:
================================================
<%@ Transaction = Required %>
Set Conn1 = Server.CreateObject("ADODB.Connection")
Conn1.Open Session("StoreDSN")
SET DB = Conn1.Execute("select name1 from kanzleien")
SET DB2 = Conn1.Execute("select PLZ from kanzleien")
.....
================================================
the "transaction =required" is necercerry, bercause i use MTS and
want to use transactions.
i also have some activex-dll, with mts-support, and they always support transactions,...i also get the same error
I can solve the Problem, when i make for every select its own connection, but the speed gets horrible !
When i remove the "transaction=required" then the error is solved, but thats not the way i will solve...
plz..can anybody help ?
For me its seems, that with transaction-suppert i can only use one recordset in one Connection once.
but this cant be true, or can it ??
thx for help in andvance,
Thomas Gugler.(tg@immobilien.net) |
Follow Up - Re: 80004005-Unkown Error (with ASP,SQL, MTS) - Raju 6/4/2000 10:46:40 AM
|
|
|
|
|
|
