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
Topic Options
Post Options
Thanks(0)
