Upgrading from 7.01 to 7.92 Problem
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=16330
Printed Date: 13 April 2026 at 9:54pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Upgrading from 7.01 to 7.92 Problem
Posted By: jglasson
Subject: Upgrading from 7.01 to 7.92 Problem
Date Posted: 25 August 2005 at 1:04pm
|
Hello, I'm attempting to upgrade from 7.01 to 7.92 and when I copy my MDB over to my staging area and modify the common.asp file, I get the following error: Microsoft OLE DB Provider for ODBC Drivers error '80040e37' [Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot find the input table or query 'tblCategory'. Make sure it exists and that its name is spelled correctly.
/forum/default.asp, line 133 Is there a DB conversion that needs to take place or something..? Thanks,
|
Replies:
Posted By: dpyers
Date Posted: 25 August 2005 at 9:20pm
|
Check the change log in the install readme. ISTRC that there was a db change around 7.5
------------- 
Lead me not into temptation... I know the short cut, follow me. |
Posted By: jglasson
Date Posted: 26 August 2005 at 1:57pm
|
Not sure if this will help as well...here is the code... Line 133 is the execution of SELECT - see below -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- 'Read the various categories from the database 'Initalise the strSQL variable with an SQL statement to query the database If strDatabaseType = "SQLServer" Then strSQL = "EXECUTE " & strDbProc & "CategoryAll" Else strSQL = "SELECT " & strDbTable & "Category.Cat_name, " & strDbTable & "Category.Cat_ID FROM " & strDbTable & "Category ORDER BY " & strDbTable & "Category.Cat_order ASC;" End If 'Query the database rsCategory.Open strSQL, adoCon -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- Thanks, Jeff |
Posted By: jglasson
Date Posted: 26 August 2005 at 2:42pm
|
Solved it! - It was completely based on my stupidity..! Now I just need to figured out how to get all my categories and forums back after being hacked... :( Thanks, J. |