Access 2000 connection from ASP.NET (0x80004005)

  • Thread starter Thread starter K0
  • Start date Start date
K

K0

Hi everyone

I have a problem opening a connection to an access 2000 db from ASP.NET

Sometimes (and only sometimes) i get an exception raised (0x80004005
couldn't lock file) when trying to open the connection, this happens only on
the production machine while my development machine behaves well.

I have set full control for ASPNET user on both the mdb file and the folder
that contains it. The problem seems to appear only when another windowsforms
program is working.

I have installed MDAC 2.7 sp1, dotnet framework 1.1 and italian langpack 1.1

The connectionstring is as follows:

Provider=Microsoft.Jet.OLEDB.4.0;
Data Source=d:\work\mrt\db\mrt.mdb;
User ID=Admin;Password='';
Mode=Share Deny None;
Extended Properties='';
Jet OLEDB:System database='';
Jet OLEDB:Database Password='';
Jet OLEDB:Registry Path='';
Jet OLEDB:Engine Type=5;
Jet OLEDB:Database Locking Mode=1;
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

What I would like to know is if its right to set Mode=Share Deny None or
should I use read/write? And also what does DataBase Locking Mode=1?

Thanx to anyone answering

Bye
 
Update: the problem occurs when the two applications try to open the
connection in the SAME moment.

Workaraound: try n times to open the connection. Anyway this behaviour is
weird.

Still looking for answers, thanx to anyone will send any

Bye
 
I would NOT depend on using JET/Access databases on any production web
server--it's simply not designed for the rigors of an ASP system.

--
____________________________________
Bill Vaughn
MVP, hRD
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
 
Back
Top