newbie - Connection & server.mappath

[Floodster]

Hi,
I'm building a site for someone & at the moment I'm hosting it on my local PC.
My problem is when I upload to the server it can't find the database as I have hard coded the directory. I know that somehow server.mappath can help but I'm unsure of the coding.
I have included my code below that I would like to be able to substitute.

dim objConn, objRS
set objConn=server.createobject("adodb.connection")
objConn.open "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=C:\Inetpub\

http://wwwroot\webfooty2006\footy.mdb"

If someone could help I would really appreciate it as I'm pulling my hair out.

Cheers.

 

[onpnt]

what is the actual location of the database?

Server.Mappath isn't going to make a difference if that path above is correct.

 

[Floodster]

that path is where it is located on my local PC, I have no idea what the path is on the server, I just know it is in \

http://wwwroot\webfooty\2006\footy.mdb.

as this is all i can see in the FTP.

cheers.

 

[onpnt]

got it.

simply use Server.MapPath with the root of the mdb at the parm

e.g.

objConn.open "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.MapPath("\webfooty\2006\footy.mdb")

many things to consider with mappath though. please read up on the parms and how it interps. your parm

http://www.w3schools.com/asp/met_mappath.asp