Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: Database: MS Access
 error "80040e37" is killing me!
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

Morten
Junior Member

Denmark
251 Posts

Posted - 04 June 2001 :  09:26:32  Show Profile
I´ve got the following error at the "Resources.asp" after installing a clean forum and then installing the portal after that
---------------------------------------------------------------

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 'Site_Cats'. Make sure it exists and that its name is spelled correctly.

/board/Forum/include/displaynavigation.asp, line 22
---------------------------------------------------------------

Is it becaurse of my database (acces) - line 22 goes like this:

"Set objRec2 = my_Conn.Execute (strSQL)"

What would be the right code to fit into this line ?

When I call "Resources.asp" the navigation bar and the left picture
is produced fine, but below that I get the error message printed above.

Please somebody help a newbie before he goes balistic!


e3stone
Average Member

USA
885 Posts

Posted - 04 June 2001 :  09:34:49  Show Profile  Send e3stone an AOL message
Couldn't tell ya. I never could get that portal mod to work.

<-- Eric -->


InsideWaco.com
Go to Top of Page

Morten
Junior Member

Denmark
251 Posts

Posted - 04 June 2001 :  09:59:33  Show Profile
...I think - I´m convinsed that it have something to do with my db setings becaurse I just tryed it out with the linksmaneger and got the same error - an error pointing to the the string:

"rsCategories.Open strSql, my_Conn"

why does Sql inflict the excecution?

Go to Top of Page

Morten
Junior Member

Denmark
251 Posts

Posted - 04 June 2001 :  10:39:38  Show Profile
....or could somebody tell me where to learn more about the different db´s - and give me a hint where to find a addon to view the db in a browser

Go to Top of Page

davemaxwell
Access 2000 Support Moderator

USA
3020 Posts

Posted - 04 June 2001 :  12:36:38  Show Profile  Visit davemaxwell's Homepage  Send davemaxwell an AOL message  Send davemaxwell an ICQ Message  Send davemaxwell a Yahoo! Message
It looks like you need to run the database setup script which came with the mod (or run it again)....

But if you want a script to run on the browser, you can try this one: http://www.2enetworx.com/dev/projects/tableeditor.asp

Dave Maxwell
--------------
Proud to be a "World Class" Knucklehead
Go to Top of Page

Morten
Junior Member

Denmark
251 Posts

Posted - 04 June 2001 :  13:02:29  Show Profile
thanks you for the URL

I have tryded to update my db in all kind of ways but the nessery table´s are not created, and all my error´s are related to:

my_Conn.Execute(strSql)


This is how I have the settings in config.asp
--------------------------------------------
'#################################################################################
'## SELECT YOUR DATABASE TYPE AND CONNECTION TYPE (access, sqlserver or mysql)
'#################################################################################
strDBType = "access"
strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=g:\activewebroot\00258\w00258081\cgi-bin\lovely\snitz_forums_2000.mdb"

strTablePrefix = "FORUM_"
strMemberTablePrefix = "FORUM_"

It look to me that I have done something wrong - but what?


Go to Top of Page

Doug G
Support Moderator

USA
6493 Posts

Posted - 04 June 2001 :  17:15:37  Show Profile
You have tried the whereami program that you can download from the Snitz main page? Unless your path is wrong I don't see a problem. If the mdb file was outside your web I'd suggest a look at permissions.



======
Doug G
======
Go to Top of Page

Morten
Junior Member

Denmark
251 Posts

Posted - 05 June 2001 :  06:45:33  Show Profile
Finally I found the error. I simply had to replace my strConnString to point to acces 2000 and not acces 97.

Everything works fine now!

Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.25 seconds. Powered By: Snitz Forums 2000 Version 3.4.07