| | |
| |
vbscript active server pages ASP vbscript SQL database informix oracle SQL Server Perl CGI Delphi PHP source code code sample samples program 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
|
|
|
|
|
|
