Open database from network share - Problems -
10-19-2004
, 06:33 PM
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's data is all
stored in a remote network location and I am having problems, I'm no longer
able to open the database, the permissions have been validated the user
account has access?
My connection string "Provider=Microsoft.Jet.OLEDB.4.0; Data
Source=\\server\shared\folder\folder\folder\databa se.mdb;"
where 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. |