| Author |
 Topic Search  Topic Options
|
frenchy 
Newbie
Joined: 11 February 2003
Status: Offline
Points: 3
|
 Post Options
 Thanks(0)
 Quote  Reply
 Topic: Active Topics bug
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
Edited by frenchy
|
 |
gr8indianbear
Groupie
Joined: 07 November 2002
Location: United States
Status: Offline
Points: 64
|
Post Options
Thanks(0)
Quote Reply
Posted: 11 February 2003 at 10:37am |
|
what's in line 260?
|
|
frenchy
Newbie
Joined: 11 February 2003
Status: Offline
Points: 3
|
Post Options
Thanks(0)
Quote Reply
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
|
|
gr8indianbear
Groupie
Joined: 07 November 2002
Location: United States
Status: Offline
Points: 64
|
Post Options
Thanks(0)
Quote Reply
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
|
|
Anilx
Newbie
Joined: 28 January 2003
Location: United States
Status: Offline
Points: 24
|
Post Options
Thanks(0)
Quote Reply
Posted: 12 February 2003 at 8:18am |
|
Make sure it's valid connection and the database you trying to access does actually exist!!!
|
|
club_a
Newbie
Joined: 09 February 2003
Location: United States
Status: Offline
Points: 6
|
Post Options
Thanks(0)
Quote Reply
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). 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.
Edited by club_a
|
|
Ignorance
Newbie
Joined: 23 February 2003
Status: Offline
Points: 28
|
Post Options
Thanks(0)
Quote Reply
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?
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
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.
|
|
|
|
