database connection string

[Ouch]

can anyone see anything wrong with this connection string.

i works ok sometimes but then sometimes if you refresh the page in comes up with a connection error and you have to wait about 15 secs.

i have done 'set rs = nothing' at the end of my page


<%
' Connection begin
Set dbconn = Server.CreateObject(&quot;ADODB.Connection&quot
' Database connection string
strConn = &quot;DRIVER=Microsoft Access Driver (*.mdb);DBQ=&quot;& Server.MapPath(&quot;weblearn.mdb&quot
dbconn.open strConn
' Connection end
%>

 

[fillup07]

What's the connection error? -Phil
fillup07@hotmail.com

 

[onpnt]

try this
strConn = &quot;DRIVER=Microsoft Access Driver (*.mdb);DBQ=&quot;& Server.MapPath(&quot;weblearn.mdb&quot & &quot;;&quot;

I may not get it the 1st or 2nd time,
but how sweet that 15th time can be.
admin@onpntwebdesigns.com

 

[fillup07]

You said that you close the Recordset at the end of your page. But do you also close that database connection by doing a dbconn.close? -Phil
fillup07@hotmail.com