Web Wiz - Green Windows Web Hosting - Celebrating 25 Years!

  New Posts New Posts RSS Feed - Upgrading from 7.01 to 7.92 Problem
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Upgrading from 7.01 to 7.92 Problem

 Post Reply Post Reply
Author
jglasson View Drop Down
Newbie
Newbie


Joined: 25 August 2005
Status: Offline
Points: 5
Post Options Post Options   Thanks (0) Thanks(0)   Quote jglasson Quote  Post ReplyReply Direct Link To This Post Topic: Upgrading from 7.01 to 7.92 Problem
    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,
Jeffrey



Back to Top
dpyers View Drop Down
Senior Member
Senior Member


Joined: 12 May 2003
Status: Offline
Points: 3937
Post Options Post Options   Thanks (0) Thanks(0)   Quote dpyers Quote  Post ReplyReply Direct Link To This Post 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.
Back to Top
jglasson View Drop Down
Newbie
Newbie


Joined: 25 August 2005
Status: Offline
Points: 5
Post Options Post Options   Thanks (0) Thanks(0)   Quote jglasson Quote  Post ReplyReply Direct Link To This Post 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
Back to Top
jglasson View Drop Down
Newbie
Newbie


Joined: 25 August 2005
Status: Offline
Points: 5
Post Options Post Options   Thanks (0) Thanks(0)   Quote jglasson Quote  Post ReplyReply Direct Link To This Post 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.
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.


Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.