ADODB: Mode=Share Deny None problem

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,...
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 OLEDB:Database Password="";
Jet OLEDB:Engine Type=5;
Jet OLEDB:Database 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 OLEDB:Don'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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top