[thelist] IIS, Novel and Access

[Michele Foster]

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