Load Page-Open Conn-Slow Respose-Closed Browser-Site Broke-Now What?

Forum Moderators: open

Message Too Old, No Replies

Load Page-Open Conn-Slow Respose-Closed Browser-Site Broke-Now What?

ado connection database recordset open not closed site disabled

rogart

5:50 pm on May 15, 2008 (gmt 0)

New to this.

ASP page was open on host server, page was hung up so I closed the browser. Probably didn't get to the conn and rs close statements at bottom. Now site won't open, everything says to reset server, how its not mine.

ASP:
open Access db connection
create three record sets
do a lot of stuff (loops...if/then...etc)
(I am guessing I closed the browser somewhere in here)
close rs
close db conn

HELP! and thanks.

rogart

7:34 pm on May 15, 2008 (gmt 0)

I tried changing the database name and the connection name and reloading the asp and mdb files to the host server, but same result.
On firefox I get:
Microsoft JET Database Engine error '80004005'
Unspecified error
/dayslist.asp, line 24

Line21-24
21) 'Open Database
22) Set adoCon = Server.CreateObject("ADODB.Connection")
23) strCon = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.MapPath("database\master_oak.mdb")
24) adoCon.Open strCon

plumsauce

8:30 pm on May 15, 2008 (gmt 0)

The error number is 'access denied'. The problem may be ntfs permissions, or that you have constructed the path improperly. If you echo the connection string back, you can at least get an idea of what you have actually constructed.

rogart

2:42 am on May 16, 2008 (gmt 0)

How do you do that or where can I look it up? And what is NTFS?
Sorry for asking what is probably common knowledge.