I need help. I am trying to use server.mappath for my connections: "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath("/Site/DB/school.mdb" & ";"

All the site is in a folder called "Site".
On my computer, everything works fine. Even if I change the location my "Site" folder on the server, the site still works. But when I try to upload it on a distant server, the connections to the databases are not working. Any advice would be appreciated.
Thank you
Arezz

the best thing to do in this situation, is to see what path is on your remote server... just do this on a page in the same directory as the calling page:

response.write(Server.MapPath("/Site/DB/school.mdb")

and see if that path is correct... trial and error baby!!

Joel Martinez [ ]
----------
E-Commerce Concepts with Ultradev...pre-order yours at
www.basic-ultradev.com/ecomm_concepts/

Yo,
Try this one:

"DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath("Site/DB/school.mdb" & ";"

Sukses,

Masor