[thelist] Really weird ASP problem

Paul Backhouse paul.backhouse at 2cs.com
Thu Jan 24 10:47:01 CST 2002


nnooooooooooo - the nightmares have return!!!!
I to have suffered from this, once it starts its just dam rude.
It seems to have problems with opening the database connection - for
absolutely no reason.
>From Kevins email - if that works I'll be forever in your debt.

many thanks

Paul

-----Original Message-----
ok... so I'm working on an ASP application with someone; it's using MS
access (I don't have control over the server situation), and in one of our
files, we're getting the strangest ASP error when we open this one recordset
(it works everywhere else):


error '80004005'
Unspecified error

/includes/vbscript_variables.inc, line 110


Now, the strange thing is that it's using the same method (myRS.open query,
connect) as everywhere else on the page. I've done some reasearch into the
bug on msdn, but it hasn't helped much. This is the code that's creating the
bug (and I didn't code it, i just have to find the bug) :


Function GetBoard()
   Dim BoardRS, b
   set BoardRS = Server.CreateObject("ADODB.RecordSet")
	query = "SELECT b.name, b.email, bp.bpname "
	query = query & "FROM board b INNER JOIN board_position bp "
	query = query & "ON b.position=bp.id "
	query = query & "WHERE b.chapter="&chapter_id
	BoardRS.Open query, Connect, 3
	'' 	^^^ this it the line that throws the error

	b = BoardRS.RecordCount

	ReDim b_name(b - 1), b_email(b - 1), b_position(b - 1)
	X = 0
	Do Until X = b
		b_name(X) = BoardRS("name")
		b_email(X) = BoardRS("email")
		b_position(X) = BoardRS("bpname")
		BoardRS.MoveNext
		X = X + 1
	Loop
	BoardRS.Close
	set BoardRS = nothing
End Function



...I've tried almost everything that I know of with ASP (I'm not as much of
an asp person as other languages) to get this to work, but that 80004005
error just won't go away.

Any suggestions?

--Jason





More information about the thelist mailing list