"unspecified error"

benbacardi · #1 (**permalink**) Apr 17th, 2005, 21:05

hi guys

i have a few pages that connect to the same database

if i click on one, and then another, on the second page i get an "unspecified error" - im guessing this might be because i havent closed connections or something?

but i use this code at the end:

Code: Select all

set rs = nothing
set conn = nothing

help would be much appreciated

thanks

JohnMitch · #2 (**permalink**) Apr 17th, 2005, 23:46

you have to close the connection to the database...

Code: Select all

conn.close
set conn = nothing
%>

benbacardi · #3 (**permalink**) Apr 18th, 2005, 06:18

Thanks john i'll try it as soon as i get off my mobile and onto a pc!

Smokie · #4 (**permalink**) Apr 18th, 2005, 08:05

Ben, you read this forum on your mobile? How?!?

Rob · #5 (**permalink**) Apr 18th, 2005, 10:12

Actually, connections to the database, and objects are cleared up automatically when the page loses it's scope..... however, manual clearing up of objects and closing connections is always good practice because you release the resources when they are done with.... which could be well before the page finishes proccesing.

Many pages can access the database at the same time unless your connection string specifies an EXCLUSIVE connection, which aint gonna be the case.

Seems as though you have an error prolly caused by your SQL statement or some object being used wrongly.

Smokie..... I reckon he prolly has an HTML capable phone.

benbacardi · #6 (**permalink**) Apr 18th, 2005, 16:11

i have a nokia 6260 - its fully html compatible

thanks guys

benbacardi · #7 (**permalink**) Apr 18th, 2005, 17:48

ok guys...

still getting the unspecified error!

JohnMitch · #8 (**permalink**) Apr 18th, 2005, 17:57

Post the code. Only way we can tell. Ohh, and Rob's right... you dont really have to close the connection, just good practice. It shouldn't error if you dont though.

benbacardi · #9 (**permalink**) Apr 18th, 2005, 18:01

Code: Select all

<%

Dim oConn
Set oConn = Server.CreateObject("ADODB.Connection")

>>> oConn.Open "Driver={Microsoft Access Driver (*.mdb)};" & _
"Dbq=" & Server.MapPath(".") & "\news.mdb;" & _
"Uid=admin;" & _
"Pwd="

Dim rs

set rs = Server.CreateObject("ADODB.RecordSet")

rs.Open "SELECT * FROM messages ORDER BY ddate DESC",oConn

if rs.eof = true then
response.write "No messages have been left."
response.write "

"
end if

while not rs.EOF

response.write "<table cellspacing='0' cellpadding='0' style='width:400px'>"
response.write "<tr>"
response.write "<td style='height:21px;width:400px;background-image:url(images/bar.jpg);border:1px solid #000000;'>"
response.write ""
response.write rs("ddate")
response.write "</td></tr><tr>"
response.write "<td style='width:400px;border:1px solid #000000;border-top:none;padding:5px;'>"
response.write rs("news")
response.write "<p align='right'>"
response.write "Added by: "
response.write rs("author")
response.write "</td></tr></table>"
response.write "
"

rs.moveNext

Wend

set rs = nothing
oConn.close
set oConn = nothing

%>

its the line with the arrow pointing to it - however, it sometimes works....[/i]

benbacardi · #10 (**permalink**) Apr 19th, 2005, 15:35

hey guys... anyone got any ideas? it worked for a bit, but now its gone back to not working...?

Rob · #11 (**permalink**) Apr 19th, 2005, 19:14

Yeah.... lol

Make sure you dont have the DB open in access!!!

LMAO!

I bet that's it!

benbacardi · #12 (**permalink**) Apr 20th, 2005, 16:49

you get a different error if you do that rob - a temporary volatile thingy error

and i'm not that stupid! :P

Rob · #13 (**permalink**) Apr 20th, 2005, 16:52

Quote:

you get a different error if you do that rob - a temporary volatile thingy error

and i'm not that stupid!

I was not implying that Ben..... it's just that we've all done it, and all of us wondered why (sometimes for hours) until we knew better.

Have you recently updated MDAC?

If so, roll back and see if you still have an issue.

If you have not recently upgraded, then maybe see if you have an updates. look on microsoft for MDAC updates.

benbacardi · #14 (**permalink**) Apr 20th, 2005, 16:54

whats MDAC?

Rob · #15 (**permalink**) Apr 20th, 2005, 17:04

Microsoft Data Access Components.

They are the objects used when connecting to a database.... they include ODBC drivers and all the other gubbins needed.

spinal007 · #16 (**permalink**) Apr 22nd, 2005, 10:08

I know that error...
I used to get it all the time.

it happens when you try to output the contents of an empty recordset.

the error in your logic is that you're forgetting to check whether rs.bof is true...

just change it to:

Code: Select all

if rs.eof or rs.bof then 
 ' whatever
end if

rs.movefirst
while not rs.EOF 
 ' whatever
loop

personally, I use this function:

Code: Select all

Function EmptyRS(ByRef rs)
 On Error Resume Next
 EmptyRS = CBool(rs.EOF Or rs.BOF)
End Function

usage:

Code: Select all

rs.Open sql, con
If Not EmptyRS(rs) Then
 ' loop through and do whatever...
End If

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Creating a "tag" system to find relevant "related" pages	MrQuestions	PHP Forum	3	Mar 20th, 2008 23:06
[SOLVED] Getting the "Microsoft JET Database Engine error '80040e14'" error.	VegaLA	Classic ASP	3	Jan 26th, 2008 00:12
[SOLVED] Show "Image" Depends On User "Status"?	Monie	Classic ASP	6	Oct 16th, 2007 01:22
? IS "meta name="robots" content="?" necessary in pages ?	Love2Java	Starting Out	6	Aug 8th, 2007 13:48
window.opener.document["nameForm"].getElementById("someid").value; doesnt work	drpompeii	JavaScript Forum	0	Feb 17th, 2007 23:09

		Webforumz.com > Main Forums > Program Your Website > Classic ASP
"unspecified error"