Web Wiz Forums - Active Topics bug

Print Page | Close Window

Active Topics bug

Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=58
Printed Date: 29 March 2026 at 3:19pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Active Topics bug

Posted By: frenchy
Subject: Active Topics bug
Date Posted: 11 February 2003 at 10:32am

I get the following error when I visit my Active Topics page:

error '80004005'

Unspecified error

/forums/active_topics.asp, line 260

I know it's not terribly helpful to anyone, but I was wondering if this was a known bug (I checked the old bug list and it's not on it) that is getting fixed with b3 (and I see that the AT on this forum upgrade works), or if it is just my set up that went goofy?

Jeremy

Replies:

Posted By: gr8indianbear
Date Posted: 11 February 2003 at 10:37am

what's in line 260?

Posted By: frenchy
Date Posted: 11 February 2003 at 10:40am

It all refers to the database call:

'Initalise the strSQL variable with an SQL statement to query the database to get the Author and subject from the database for the topic
If strDatabaseType = "Access" Then
strSQL = "SELECT tblForum.Forum_name, tblForum.Password, tblForum.Forum_code, tblForum.Read, tblTopic.* "
strSQL = strSQL & "FROM tblCategory, tblForum, tblTopic "
strSQL = strSQL & "WHERE (tblCategory.Cat_ID = tblForum.Cat_ID AND tblForum.Forum_ID = tblTopic.Forum_ID) AND (tblForum.Read = True) AND (tblTopic.Last_entry_date > Now() - " & dblActiveFrom & ")"
strSQL = strSQL & "ORDER BY tblCategory.Cat_order ASC, tblForum.Forum_Order ASC, tblTopic.Last_entry_date DESC;"

Else
strSQL = "EXECUTE wwfSpActiveToipcs @dblActiveFrom = " & dblActiveFrom
End If

'Query the database
rsCommon.Open strSQL, adoCon

The last line is line 260.

Thanks

Jeremy

Posted By: gr8indianbear
Date Posted: 11 February 2003 at 6:25pm

It's probably your connection to the DB. what connection are you using? make sure you have the right one set for connecting to the database. try using different methods until you get the right one

Posted By: Anilx
Date Posted: 12 February 2003 at 8:18am

Make sure it's valid connection and the database you trying to access does actually exist!!!

Posted By: club_a
Date Posted: 12 February 2003 at 8:50am

You are not alone. The 80004005 seems to this newbie to be very popular. I'm going through it myself ( http://forums.webwiz.net/forum_posts.asp?TID=54&TPN=1 - http://forums.webwiz.net/forum_posts.asp?TID=54&TPN=1 ). Your 'Open' command was my 1st incarnation of the error. To fix it, I changed the path from an indirect reference ('&.....') to the physical path (c:/......). In my case, I was testing the 'Login' asp under IIS on the same system - not on a remote server. That's the good news. The bad news is that you will probably get another 80004005 error with the 'Sderver.CreateObject("ADODB.RecordSet")' command. That's where I am now - so any help from you or anyone will be much appreciated. Good luck to both of us.

Posted By: Ignorance
Date Posted: 25 February 2003 at 7:18pm

Kinda curious, I switched from using "Microsoft.Jet.OLEDB.4.0" as the connection method back to the "Microsoft Access Driver" method and it fixed this error for me.

error '80004005'

Unspecified error

/forums/active_topics.asp, line 260

Anyone ever figure out why it doesn't work when using the "Microsoft.Jet.OLEDB.4.0" method?

Posted By: WebWiz-Bruce
Date Posted: 26 February 2003 at 4:31am

There was a problem with older beta versions that should have been fixed in beta 3, try using the latest beta version.

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting

Posted By: frenchy
Date Posted: 27 February 2003 at 4:34am

Thanks Borg, I picked up beta 3 yesterday.

Jer

Posted By: Dreamy
Date Posted: 02 March 2003 at 2:09pm

Using Beta 3 and still getting this problem

-------------
Edwin Roux
forum.dreamwebcorp.com

Posted By: Ignorance
Date Posted: 02 March 2003 at 3:17pm

Same here, guess I should have told you the version I was running. I too am using beta 3.

Using the connection string from line 189 in common.asp, I get no errors on the active topics page.

Using the connection string from line 193 in common.asp, I get the error mentioned before but only on the active topics page. Everything else works fine that I've seen.

Posted By: Nick-V
Date Posted: 06 March 2003 at 10:04pm

I am using the SQL beta 3 version. I don't get an error message which is great - but I don't see any postings either - not so great!