Re: Access database, network access problems
From: Jared (ask_me_for_it_at_nospam.com)
Date: 10/21/04
- Next message: Dennis: "Re: Can't create a new dataset from the toolbox"
- Previous message: Dorte: "Linebreaks in SQLCommand.CommandText (C#)"
- In reply to: Paul Clement: "Re: Access database, network access problems"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 21 Oct 2004 06:31:17 -0500
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
"Paul Clement" <UseAdddressAtEndofMessage@swspectrum.com> wrote in message
news:t5vcn0tsh8l2d38d0i1nsje0uuoho8gntu@4ax.com...
> On Wed, 20 Oct 2004 05:12:35 -0500, "Jared" <ask_me_for_it@nospam.com>
> wrote:
>
> ¤ 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 ~~~ pclement@ameritech.net
> Microsoft MVP (Visual Basic)
- Next message: Dennis: "Re: Can't create a new dataset from the toolbox"
- Previous message: Dorte: "Linebreaks in SQLCommand.CommandText (C#)"
- In reply to: Paul Clement: "Re: Access database, network access problems"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
