[thelist] Really weird ASP problem

Kevin D. White nonzero at well.com
Thu Jan 24 10:43:31 CST 2002


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Try this.  I picked it up from a Google search on the error code:
http://www.aspfaqs.com/aspfaqs/ShowFAQ.asp?FAQID=115
- ----- Original Message ----- 
From: "Jason Lustig" <lustig at acsu.buffalo.edu>
To: "Thelist at Lists. Evolt. Org" <thelist at lists.evolt.org>
Sent: Thursday 2002 January 24 09:30
Subject: [thelist] Really weird ASP problem


> 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
> 
> 
> -- 
> For unsubscribe and other options, including
> the Tip Harvester and archive of TheList go to:
> http://lists.evolt.org Workers of the Web, evolt ! 

-----BEGIN PGP SIGNATURE-----
Version: PGPfreeware 7.0.3 for non-commercial use <http://www.pgp.com>

iQA/AwUBPFA5w6kcrjXY5do7EQIbXACfXUlpZC+nt5x4o46wVChFxz9RhfkAoO21
ZLgVyRXbMEUAw8SSRvomPjc1
=7ldG
-----END PGP SIGNATURE-----






More information about the thelist mailing list