Microsoft JET Database Engine error '80004005'

[thompom]

Hi,

I have a web server at one site and an access database
at another site - they are connected via a vpn and i can map a network drive to the folder on the database server
from my web server.

I am trying to write to a table in the access database.
The asp page uses the following conn string to
connect to an Access database.
[where x: is the mapped drive at the remote site]

"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=x:\database.mdb"

but i get the following error

Microsoft JET Database Engine error '80004005' 

'x:\database.mdb' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides.

The code works fine for a local access DB - on c drive.
I know the mapped drive is working ok because if i type x: into explorer on the web server it opens the access database folder at the remote site.

I was looking at IUSR permissions but the access server doesnt have IIS installed - does this need to be installed on the remote server ?

many thanks MG

 

[Mighty]

Try using the UNC Path:

Data Source=\\yourserver\mappeddrive\database.mdb

where yourserver is the name of your server and mappeddrive is the name of the folder that you have mapped.

Mighty

 

[thompom]

Hi Mighty-thanks for your reply

tried \\ipaddress\sharefolder\database.mdb

but i get error

Microsoft JET Database Engine error '80004005' 

The Microsoft Jet database engine cannot open the file '\\ipaddress\sharefolder\database.mdb'. It is already opened exclusively by another user, or you need permission to view its data.

 

[Mighty]

Well at least that's a step forward.

Make sure that you, or someone else, don't have the database open. Other than that, it looks like it could be a permissions issue. Make sure that the account that your webserver is using has permission to access the database.

Mighty

 

[thompom]

Hi Mighty - the database is open by at least 10 users,
but this isnt a problem if the DB is on a local disk.

Do you know what permissions the shared folder should have - at the moment the user has modify permissions.

I think the only solution to this is going to be to install the asp pages on the same server as the db ??

 

[Mighty]

It is definitely possible to have the database on a different server to the ASP pages as I do that myself. Make sure the IIS user account - typically something like IUSR_WEBSERVER by default - has permissions to update both the shared folder and the database.

What I did was create a domain account with limited permissions and set IIS to use this domain account. I then gave that account access to my databases on remote servers.

Mighty

 

[thompom]

will give it a go, will post back to let you know how i get on

 

[thompom]

Hi - followed the following article

http://databases.aspfaq.com/databas...-database-or-text-file-on-another-server.html

which advises changing the password on the ISR account in
IIS manager but this disabled all my websites until I changed the password to the same in users and accounts !!
- but got it sorted

i added the same ISR_WEBSERVER to my database machine and gave permissions on my access folder as per instructions in link above.

i am now getting error

Microsoft JET Database Engine error '80004005' 

Disk or network error.

thanks again mighty