I need to access a database via ASP that doesn't reside on the server
where IIS is running.

Using IIS 5.1 I'm not able to map a directory that is not on the server running IIS.
Example: I can't map the dir. \\someserver\databases\data.mdb
I'm not able to map the database even if i connect a new drive unit.

So i tried to use DSN for the remote db but when I connect to the DSN I get an error,
while if the DSN points to a local database it works fine.
Why?
Can IIS map a database through the LAN?

thanks in advance

It's all to do with permissions. Take a look at this article which addresses how to connect to a remote Access database from ASP
http://support.microsoft.com/?kbid=161333

If any of it doesn't make sense, just ask :)

rgds
Phil

I read the article and now I know it's a problem of permissions.
As it's said on the article, I created an user with the name IUSR_P253 (P253 it's the IIS machine's name) on the other machine running 98 where the database resides.
I set the same password for the user IUSR_P253 on the win98 pc (database machine)
and the user IUSR_P253 on the machine running IIS (Win XP)
I added a virtual directory in IIS with the path \\p600\mydb\database.mdb and when I was asked for the username e password I set the IUSR_P253 with the correct password: but the new directory has been created with an error icon and I'm not able to use it.
What's is wrong???

thanks

You don't need to map a virtual directory in IIS. Just use the UNC path
"\\p600\mydb\database.mdb" in your connection string.