Classic ASP Discussion - Connection problem

Print Page | Close Window

Connection problem

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Classic ASP Discussion
Forum Description: Discussion on Active Server Pages (Classic ASP).
URL: https://forums.webwiz.net/forum_posts.asp?TID=11842
Printed Date: 31 March 2026 at 1:35am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Connection problem

Posted By: jimidy
Subject: Connection problem
Date Posted: 16 September 2004 at 5:30pm

My site http://www.srp.me.uk - 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

-------------
www.srp.me.uk

Replies:

Posted By: jimidy
Date Posted: 16 September 2004 at 5:43pm

sorted it now, so don't worry..

-------------
www.srp.me.uk