I have two PCs running Windows 2k, one with databases (Access) and the other as a web server. I made a mapping of the pc with databases as F: on the webserver, and create a DSN on my web server using a database in F:. My code tries to acces the DSN, but an error occurs. If I move the database to the web server and reconfigure the DSN, everything is ok.... what's happening? Can I use DSN on a mapped drive? Any help would be greatly appreciated.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
DSN on a mapped drive not working
- Thread starter gcastillo
- Start date
By your referring to a "Mapped path" I assume you have assigned a letter to the drive where the Access Database is located.
Try re-creating the DSN using \\NameofPChaving Access\Sharename\foldername\abc.mdb.
That way you tell everyobject trying to get to the database to use the UNC (Universal Naming Convention) path.
Right off hand I don't know why it doesn't work the otherway since ther are only 2 PC's but this should work.
In the end you could just leave the Access Database on the IIS server, no performance hit there..
HTH
AJ
Try re-creating the DSN using \\NameofPChaving Access\Sharename\foldername\abc.mdb.
That way you tell everyobject trying to get to the database to use the UNC (Universal Naming Convention) path.
Right off hand I don't know why it doesn't work the otherway since ther are only 2 PC's but this should work.
In the end you could just leave the Access Database on the IIS server, no performance hit there..
HTH
AJ
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question