Hi,



I have two NT servers.



I get the error message at the bottom when I copied my web project from

the first to the second server.



On the first server the web pages have a DSN statement connecting to an

Access db MyConn.Open "DSN=WebTest", I have created the same DSN on the

second server.



The servers are not used by anyone except myself so there's no one logged

on on any of the servers except myself.  I have administrator rights on

both servers.  I created the DSN on the second server whilst logged on as

administrator and I'm trying to view the web pages with the same username.



Error Message



Microsoft OLE DB Provider for ODBC Drivers error '80004005' 



[Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database

engine cannot open the file '(unknown)'. It is already opened exclusively

by another user, or you need permission to view its data.

Crikey, I had that error myself this morning. Try closing down Access, or

shutting down any processes that might be using the database. You may have

to stop and restart the web server if its gone rogue..



Chris



Chaos! Panic! Disaster! (My work here is done)

Chris Neale. Web/Wap Developer

Chris.neale@s... <mailto:Chris.neale@s...> 

www.sparkresponse.co.uk



	-----Original Message-----

	From:	Shaukat Desai [SMTP:shaukat.desai@g...]

	Sent:	Tuesday, September 12, 2000 8:21 PM

	To:	ASP Databases

	Subject:	[asp_databases] ODBC driver error 80004005



	Hi,



	I have two NT servers.



	I get the error message at the bottom when I copied my web project

from

	the first to the second server.



	On the first server the web pages have a DSN statement connecting to

an

	Access db MyConn.Open "DSN=WebTest", I have created the same DSN on

the

	second server.



	The servers are not used by anyone except myself so there's no one

logged

	on on any of the servers except myself.  I have administrator rights

on

	both servers.  I created the DSN on the second server whilst logged

on as

	administrator and I'm trying to view the web pages with the same

username.



	Error Message



	Microsoft OLE DB Provider for ODBC Drivers error '80004005' 



	[Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database

	engine cannot open the file '(unknown)'. It is already opened

exclusively

	by another user, or you need permission to view its data.

I have tried everything from shutting the db down to restarting the IIS

server.

Make sure the IUSR_Computername account has CHANGE permissions to both the

file, and the folder that the file is in. This is so the anonymous user

account can create and delete the *.ldb lockfile.



Cheers

Ken



----- Original Message -----

From: "Shaukat Desai" <shaukat.desai@g...>

To: "ASP Databases" <asp_databases@p...>

Sent: Wednesday, September 13, 2000 2:15 AM

Subject: [asp_databases] RE: ODBC driver error 80004005





> I have tried everything from shutting the db down to restarting the IIS

> server.

The IUSR_Computername has full control rights on the server.  Is still

comes up with the same error message.

When you setup the 2nd server that you were talking about, you copied the

database across to the second server, and then setup the website again. The

DSN you setup on server2 points to the database on server2. Is that right?



If the anonymous user account has full control to the folder that the Access

database is in, and to the actual Access database, and you don't have a

password on the actual database, and you don't have the database open

somewhere else, then I'm stuck.



You could try these articles though:

http://support.microsoft.com/support/kb/articles/Q253/6/04.ASP

http://support.microsoft.com/support/kb/articles/q166/0/29.asp



Cheers

Ken





----- Original Message -----

From: "Shaukat Desai" <shaukat.desai@g...>

To: "ASP Databases" <asp_databases@p...>

Sent: Wednesday, September 13, 2000 8:34 PM

Subject: [asp_databases] RE: ODBC driver error 80004005





> The IUSR_Computername has full control rights on the server.  Is still

> comes up with the same error message.

>

> ---

> You are currently subscribed to asp_databases


$subst('Email.Unsub')

>

Thanks Ken, but the DSN points to a db on the same server, the

IUSER_computername has rights to the db.  I've looked at the Microsoft

articles and i've tried everything they have suggested.  It looks it might

be a case of reinstalling IIS.



 

My two cents here:  Don't suspect IIS.  I made that mistake when I started

developing asp.  It is usually something so simple that you completely

overlook the answer, no matter how many times you look at it.  When you look

the DSN, do test the connection.  If it works, then it has to be something

in the asp or global.asa.  You may want to manually edit the asa.  BTW, if

you have visual interdev, open it up in there and see if the

connection/command to the database works.  If it doesn't, try setting up a

new connection/command to the same database but with a different name.  If

it connects, then you should be able to browse that database.  If that does

work then it is in the asp page itself. 



Also, the last stupid thing (stupid only because I have forgotten to do this

step on a few occasions) to look at is, did you configure the web site as an

application from the IIS Manager.  It must be an app in order to run asp

pages.  Script execution is all it needs (not exe).



Greg Evans

Director of Networks

Intrex Data Communications Group

3033 Kellway Dr

Carrollton, TX  75006

xxx.xxx.xxxx  x220 (voice and fax)

mailto:  gevans@i...





-----Original Message-----

From: Shaukat Desai [mailto:shaukat.desai@g...]

Sent: Friday, September 15, 2000 11:04 AM

To: ASP Databases

Subject: [asp_databases] RE: ODBC driver error 80004005





Thanks Ken, but the DSN points to a db on the same server, the

IUSER_computername has rights to the db.  I've looked at the Microsoft

articles and i've tried everything they have suggested.  It looks it might

be a case of reinstalling IIS.