Access database, network access problems

  • Thread starter Thread starter Jared
  • Start date Start date
J

Jared

I've recently run into a problem when creating a web service. I have a
webserivce that returns data from a small access database; I created and
tested the service on my local machine with the database local in a
sub-directory. I verified the results on a test server remotely with the
database stored on the local disk. The production server is a web farm, a
SAN provides all data storage for this farm; This is where I am having
problems, I'm no longer
able to open the database, the permissions have been validated on the remote
share and the user
account has access?

My connection string "Provider=Microsoft.Jet.OLEDB.4.0; Data
Source=\\server\share\folder\folder\folder\database.mdb;"
I have also tried using the extended property Mode="Share Deny None"

The mappath function is used to get the actual file path. It points to
the correct location, but, I get errors that the database cannot be opened
because you don't have permissions or the database is being opened
exclusively, or something to that nature. I don't have recordlocking enabled
and a .ldb file is never created.

Any suggestions? If you need more information please let me know.
 
Sounds like the ASP.NET process doesn't have permissions for that file. Try
granting them to it.
 
¤ I've recently run into a problem when creating a web service. I have a
¤ webserivce that returns data from a small access database; I created and
¤ tested the service on my local machine with the database local in a
¤ sub-directory. I verified the results on a test server remotely with the
¤ database stored on the local disk. The production server is a web farm, a
¤ SAN provides all data storage for this farm; This is where I am having
¤ problems, I'm no longer
¤ able to open the database, the permissions have been validated on the remote
¤ share and the user
¤ account has access?
¤
¤ My connection string "Provider=Microsoft.Jet.OLEDB.4.0; Data
¤ Source=\\server\share\folder\folder\folder\database.mdb;"
¤ I have also tried using the extended property Mode="Share Deny None"
¤
¤ The mappath function is used to get the actual file path. It points to
¤ the correct location, but, I get errors that the database cannot be opened
¤ because you don't have permissions or the database is being opened
¤ exclusively, or something to that nature. I don't have recordlocking enabled
¤ and a .ldb file is never created.
¤
¤ Any suggestions? If you need more information please let me know.
¤

Unless you're opening the database for read only access (Mode=Share Deny Write) the Jet database
engine will attempt to create an .LDB file. The likely scenario is that the user account does not
have sufficient permissions, for the folder where the database is located, to create the .LDB file.


Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)
 
It turns out it is a permissions problem, but, the cause is still unknown.
The website (IIS 5.0) properties use the "a share located on another
computer" option, and the"connect as" dialogs' credentials use a domain
account with sufficient privileges to make the connection and read the data.
If I was to replace this account with my own, the connection works, and I
have less rights than the account in question. I have used the XP Effective
permissions to verify rights on the domain account and everything checks
out - RWX. Also, when using the redirection to a network share,
impersonation does not work, is this by design? Can a developer get around
this?
TIA,
Jared
 
Back
Top