P
Peter Gruendler
I got an ASP script doing two nested queries in an open ADODB.Connection
into different recordset opbjects. While a loop works on the records in
the first RS, a function does the second query into a different
recordset object.
On my local test server all works fine; on the production server I get
an 'Object already in use' error when the second rs2.Open is called.
The ADODB.Connection, opend without anything like conn.Mode=xxx,...
.... contains (according to response.write(ldconn); ommiting the part up
to the source= line):
*** Testserver ***
Mode=Share Deny None;
Extended Properties="";
Jet OLEDB:System database="";
Jet OLEDB:Registry Path="";
Jet OLEDBatabase Password="";
Jet OLEDB:Engine Type=5;
Jet OLEDBatabase Locking Mode=0;
Jet OLEDB:Global Partial Bulk Ops=2;
Jet OLEDB:Global Bulk Transactions=1;
Jet OLEDB:New Database Password="";
Jet OLEDB:Create System Database=False;
Jet OLEDB:Encrypt Database=False;
Jet OLEDBon't Copy Locale on Compact=False;
Jet OLEDB:Compact Without Replica Repair=False;
Jet OLEDB:SFP=False
*** Produktionsserver ***
Mode=Share Deny Read|Share Deny Write;
[everything else identical]
When I try to do a
ldconn.Mode = 16 (or 19)
on the production server, I get various errors like no write access,
although this should be adModeShareDenyNone
or adModeShareDenyNone|adModeReadWrite.
What am I doing wrong?
What would be the necessary changes on the production server?
Thx,
Peter
into different recordset opbjects. While a loop works on the records in
the first RS, a function does the second query into a different
recordset object.
On my local test server all works fine; on the production server I get
an 'Object already in use' error when the second rs2.Open is called.
The ADODB.Connection, opend without anything like conn.Mode=xxx,...
dbPath = server.mappath(mydb)
Set ldConn = Server.CreateObject("ADODB.Connection")
ldConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & dbPath
.... contains (according to response.write(ldconn); ommiting the part up
to the source= line):
*** Testserver ***
Mode=Share Deny None;
Extended Properties="";
Jet OLEDB:System database="";
Jet OLEDB:Registry Path="";
Jet OLEDBatabase Password="";
Jet OLEDB:Engine Type=5;
Jet OLEDBatabase Locking Mode=0;
Jet OLEDB:Global Partial Bulk Ops=2;
Jet OLEDB:Global Bulk Transactions=1;
Jet OLEDB:New Database Password="";
Jet OLEDB:Create System Database=False;
Jet OLEDB:Encrypt Database=False;
Jet OLEDBon't Copy Locale on Compact=False;
Jet OLEDB:Compact Without Replica Repair=False;
Jet OLEDB:SFP=False
*** Produktionsserver ***
Mode=Share Deny Read|Share Deny Write;
[everything else identical]
When I try to do a
ldconn.Mode = 16 (or 19)
on the production server, I get various errors like no write access,
although this should be adModeShareDenyNone
or adModeShareDenyNone|adModeReadWrite.
What am I doing wrong?
What would be the necessary changes on the production server?
Thx,
Peter