newbe at asp looking for connection 1

rry2k · Jul 17, 2001

I'm taking my first stab at asp with a database. When I try to run the code I get a general error on line 15 which is the connection string. I think the way I'm trying to define my path is the problem. thanks in advance for the help. here is the code:

<html>
<head>
</head>
<body>
<p>
<%
dim path
dim dbq
path = server.mappath("critters.mdb&quot

dbq = path
%>
<%
openstr = "driver={Microsoft Access Driver (*.mdb)};" & "dbq"
Set cn = Server.CreateObject("ADODB.Connection&quot

cn.Open openstr

vasah20 · Jul 17, 2001

hi -

this should read
openstr = "driver={Microsoft Access Driver (*.mdb)};" & "dbq=C:\myfolder\path\tomydb.mdb"

hope this helps
leo

rry2k · Jul 17, 2001

Leo,

That did it thanks for the help.

Russ

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!

newbe at asp looking for connection 1

rry2k

Programmer

vasah20

Programmer

rry2k

Programmer

Similar threads

Part and Inventory Search

Sponsor