[thelist] IIS, Novel and Access

[Ken Schaefer]

a) Drive letters are mapped for the currently logged on user only

b) Your ASP pages are (most likely) running as the IUSR_<machinename>
account, so when you logon on map z: to \\server\share that doesn't mean
it's mapped for the IUSR_<machinename> account

c) The IUSR_<machinename> account is local to the webserver (unless you're
running the webserver on your domain controller, in which case all accounts
are domain accounts). Local accounts can not be assigned permissions to
remote resources.


Options:
a) If changes to the data only happen "internally", then develop something
to "push" a copy of the .mdb file across to the webserver (every hour, or
day or whatever)

b) If you really need to get this working (I don't recommend it - .mdb files
are file based - you'll be pulling almost the entire database across the
wire everytime you want to run a query - it'll be a performance nightmare),
then:
    i) change your connection string to be UNC based:
\\server\share\database.mdb
    ii) change the anonymous user account to a domain account
    iii) assign appropriate permissions (Read/Write) to the share and file
to that domain account.

Cheers
Ken


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "Michele Foster" <michele at wordpro.on.ca>
Subject: [thelist] IIS, Novel and Access


: Hi folks ..
:
: First off .. let me say I am definitely NOT a server person .. and am
trying
: to relate the problem the best I can  ;)
:
: We have an Access DB that's to be used both inhouse and on the web site ..
: yes, I know how horrible this is .. but that's the way it is.
:
: We bought some software from MS that allows the Win2k web server machine
to
: see the shared drive under Novel. This part is working, when I go to my
: computer on the Win2K machine, I can see the drive and all its files on
U:.
:
: What we haven't been able to get to work .. is my ASP code to find the
: Access file that lives on the U: drive. I get different errors depending
on
: if I use an ODBC or an OLE Jet 4 connection string.  The ODBC returns a
: registry failure error, whereas the OLE returns a disk or network error.
:
: All works fine if the database exists on the web server, so it's not my
ASP
: code per se nor my connection string. My ASP code can't find the U: drive
..
: at least I think that's the problem.  As an aside,  I can't seem to get
: include file either to find the U: drive .. tho I gave up on Friday trying
: this as it was home time ;)
:
: We've done some googling and found a few references specifically on the
: issfaq web site .. but so far we've been unable to get this to work.
:
: Does anyone have any suggestions?
:
: There's one way I can "fake" it and get it to work .. that being to create
a
: DB on the web server machine and use linked tables to the version on the
U:
: drive.  However, I really worry about this creating a huge performance
: problem, and since we're already in a performance nightmare situation,
: adding another layer can only make it even worse.
:
: TIA,
:
: Mich
:
:
: --
: * * Please support the community that supports you.  * *
: http://evolt.org/help_support_evolt/
:
: For unsubscribe and other options, including the Tip Harvester
: and archives of thelist go to: http://lists.evolt.org
: Workers of the Web, evolt !