Web Wiz Forums - Active

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=627
Printed Date: 29 March 2026 at 10:03am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Active_topics bug

Posted By: Chris
Subject: Active_topics bug
Date Posted: 01 March 2003 at 8:23am

I have noticed a problem (bug or not) with the file active_topics.asp when the ODBC driver is Access 2000/2002. This feature works fine with this driver (in common.asp):

strCon = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & strDbPathAndName

But not with this:

strCon = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & strDbPathAndName

However, the server itself is running the OLEDB 4.0, and while it accepts the "default" MS Access driver, this one is so much slower and sometimes the entire DB-connection crashes with every page displaying an HTTP 500 error "To many client tasks".

The line in active_topics.asp that won't accept the OLEDB 4.0 drivers is line 268 which reads: rsForum.Open strSQL, adoCon. (The server returns "Unexpected error, line 268 in active_topics.asp)

Does anyone see a way around this?

Regards,
Chris