Connection problem

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   My site www.srp.me.uk has been happily hosted on an IIS Server for about a year, when I tried to transfer it to another server I cannot get the DB to connect to my ASP pages because I do not know the correct procedure of doing it.  I am using a connect page which all of my pages link to.
Below is the page that I have been using for the last year on the original server.
<%
Dim myConn, myDb, rs, rs2, sql
Set myconn=server.createobject("ADODB.connection")
mydb = "Driver={Microsoft Access Driver (*.mdb)};DBQ=e:\webareas\wn008\srp\database\srp.mdb"
myconn.open mydb
set rs = server.createobject("ADODB.Recordset")
set rs2 = server.createobject("ADODB.Recordset")
%>
The prob is here e:\webareas\wn008\srp\database\srp.mdb"
myconn.open mydb
How can I get the path to point to a folder relative to this point rather than an absolute address?

Many, many thanks in advance.
Jim

Edited by jimidy