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 500 when accessing forum
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

Id
Junior Member

USA
129 Posts

Posted - 29 March 2001 :  19:15:38  Show Profile  Visit Id's Homepage
I've recently installed the forum on my server, as far as I can tell I have all the strings set up in config.asp but when i try to open the server I get an error 500. The odd thing is, I tried converting the access97 database to an access2000 database before uploading, and then i don't get the error, it loads up into the forum, but like half the options aren't there, i can't login and the tables for the forum listings are all screwed up. Could the server i'm uploading possibly be running the wrong version of MDAC. I know they use access2000 for the odbc, but as far as I knew access97 databases should be able to be read in access2000. Any thoughts?

Doug G
Support Moderator

USA
6493 Posts

Posted - 29 March 2001 :  19:46:18  Show Profile
Hi, some specifics on the error would be helpful. If you're using Internet Explorer 5, you should be able to get more information by going to the menu Tools - Internet Options - Advanced Options and unchecking the 'show friendly HTTP error messages'

The current version of MDAC is 2.6. In my experience, any 2.1+ version of MDAC works pretty well on either Acc97 or A2K .mdb files



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

Id
Junior Member

USA
129 Posts

Posted - 29 March 2001 :  21:06:40  Show Profile  Visit Id's Homepage
here's what i'm getting

Microsoft JET Database Engine error '80004005'

Cannot open database ''. It may not be a database that your application recognizes, or the file may be corrupt.

/forum/inc_top.asp, line 42


Go to Top of Page

Doug G
Support Moderator

USA
6493 Posts

Posted - 30 March 2001 :  10:00:57  Show Profile
What connection string are you using?

Often this kind of error is related to a permissions problem to the database file.

You can try using the other access driver in your connection string.


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

Id
Junior Member

USA
129 Posts

Posted - 30 March 2001 :  10:40:32  Show Profile  Visit Id's Homepage
I've already tried both the access2000 driver strings, and i get the same problem with both. I've spoken with my web host and the data directory i have the database in is supposed to have read and write access

Go to Top of Page

davemaxwell
Access 2000 Support Moderator

USA
3020 Posts

Posted - 30 March 2001 :  12:48:59  Show Profile  Visit davemaxwell's Homepage  Send davemaxwell an AOL message  Send davemaxwell an ICQ Message  Send davemaxwell a Yahoo! Message
Is the database actually in 2000 format? If you're using the one from the tools zip, it is in 97 format, regardless of what it is called.

I did have a problem with my provider and I had to convert it to 2000 format and it worked fine....

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

Id
Junior Member

USA
129 Posts

Posted - 30 March 2001 :  12:52:11  Show Profile  Visit Id's Homepage
well i did convert it to a 2000 format, but then like half the features weren't on my main page, the login option wasn't there, the forums didn't have the columns dividing them, the snitz forum logo up in the top left wasn't there, it was odd, maybe i just didn't upload something right, i'll give it another go, see if i by chance missed something obvious

Go to Top of Page

Id
Junior Member

USA
129 Posts

Posted - 30 March 2001 :  12:55:59  Show Profile  Visit Id's Homepage
this is what i end up with when i convert it to a 2000 database

http://www.gamers-hub.net/forum/

i've doublechecked and i've got everything uploaded, i'm just not sure why it's doing this, do I need to do something in the setup.asp?

Go to Top of Page

Id
Junior Member

USA
129 Posts

Posted - 30 March 2001 :  12:57:45  Show Profile  Visit Id's Homepage
woh i feel stupid, i just got it up and running, just needed to convert it to a 2000 database, and go to the correct url. thanks for all your help

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.85 seconds. Powered By: Snitz Forums 2000 Version 3.4.07