Problems with ODBC on XP Prof with IIS and ASP over network share

Problems with ODBC on XP Prof with IIS and ASP over network share.

When I originally set up my IIS server yesterday on XP professional and I tried to set up my home directory over a network share it wouldnt let me do it with ISUR_COMPUTERNAME because it said something about dual usage. Whatever it was saying it gave me the impression that I couldnt be logged on as 'user' with mapped network drives or something and still access the share with ISUR_COMPUTERNAME. So I used my username instead to connect to the network share over IIS. Everything seemed to work okay until I tried to set up the ODBC to access my MS Access database with asp. I went into the 'Data Sources (ODBC)' to set it up. I selected the 'System DSN' tab and clicked the add button. I then selected the 'Microsoft Access Driver (*.mdb)' named the driver, selected it on the share and thought everything was fine until I get this error when I try and call up the asp page.

So,.....I do a little googling to find this thread
http://support.microsoft.com/defaul...&NoWebContent=1
Which says that it might be a permissions issue, so I double check everything and my username and ISUR_COMPUTERNAME are both set up as admins on both machines. I then go to the security tab on the access file itself but now what do I do? Has anyone ever come accross this before?

Try the asp forum, it sounds like a problem with your coding.

Like what kind of path is 'unknown'? That should be a clue.

see, the thing is when I copy the access .mdb file onto my c drive and then change the path in odbc manager it works fine. That's why I figured it was an odbc manager vs. network share issue and I don't know where to go with that. LOL

What's the code that opens the connection to your database? (or that tries to open your database anyway)?

The code you listed is using a DSN that must be created on the web server, is there a DSN named "international_hotlines" on the server that is known to work with the IIS user account?

attached is a picture of my odbc. For now I have it running perfectly fine on my local disk C:/ drive. But what if something happens to my c drive, I always used it (in win 200 prof) on a network share and had no problems. Now I'm in xp prof and can't map it to the network share, the second I do, I have problems.

I think your original comments about it being a permissions problem is probably correct. It's possible you need to add the IWAM_ user account to the remote computer as well. There is some MS KB article discussing the useage of IUSR and IWAM user accounts by IIS.