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 code 8000FFFF - database can't be opened!
 New Topic  Topic Locked
 Printer Friendly
Next Page
Author Previous Topic Topic Next Topic
Page: of 2

luminousnerd
New Member

USA
97 Posts

Posted - 09 August 2006 :  11:21:00  Show Profile  Visit luminousnerd's Homepage  Send luminousnerd an AOL message  Send luminousnerd a Yahoo! Message
This is on setup.asp:

The database could not be opened !!
Check your config.asp file and set the
strConnString so it points to the database.
Also check if strDBType is set to the right databasetype.

Code : 8000FFFF

Error Description :
Catastrophic failure

Any help or comments on this error would be appreciated. I couldn't find anything on that error code in the forums. Thanks!

AnonJr
Moderator

United States
5768 Posts

Posted - 09 August 2006 :  11:53:11  Show Profile  Visit AnonJr's Homepage
Did you edit config.asp as per the readme?
Go to Top of Page

luminousnerd
New Member

USA
97 Posts

Posted - 09 August 2006 :  12:02:26  Show Profile  Visit luminousnerd's Homepage  Send luminousnerd an AOL message  Send luminousnerd a Yahoo! Message
yes, I did. Also I tried all the different possibilities for the path to my MDB file. I guess it's relative to the location of the forum?? Or is it the path from the root? Here's what I currently have (and set to access database):

strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("/mdb/snitz_forums_2000.mdb")
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 09 August 2006 :  12:03:30  Show Profile  Send ruirib a Yahoo! Message
So, can we assume that the .mdb file is located inside a mdb folder, inside the folder where the forum is located?


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

luminousnerd
New Member

USA
97 Posts

Posted - 09 August 2006 :  12:06:30  Show Profile  Visit luminousnerd's Homepage  Send luminousnerd an AOL message  Send luminousnerd a Yahoo! Message
I should mention that the location of the MDB is .com/forum/mdb/snitz_forums_2000.mdb
Go to Top of Page

luminousnerd
New Member

USA
97 Posts

Posted - 09 August 2006 :  12:21:44  Show Profile  Visit luminousnerd's Homepage  Send luminousnerd an AOL message  Send luminousnerd a Yahoo! Message
Ruirib, yea that's right, sorry, my last post was before I saw yours
Go to Top of Page

AnonJr
Moderator

United States
5768 Posts

Posted - 09 August 2006 :  13:45:16  Show Profile  Visit AnonJr's Homepage
Personally, I'd recommend using the OLEDB provider... yours would probably look something like:

strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("./mdb/snitz_forums_2000.mdb")

This is assuming that your database is named "snitz_forums_2000.mdb" (Which I'd recommend changing)

Its also assuming that Access was the only strDBType you uncommented. It should look like:

'strDBType = "sqlserver"
strDBType = "access"
'strDBType = "mysql"

Edited by - AnonJr on 09 August 2006 13:45:39
Go to Top of Page

luminousnerd
New Member

USA
97 Posts

Posted - 09 August 2006 :  14:25:16  Show Profile  Visit luminousnerd's Homepage  Send luminousnerd an AOL message  Send luminousnerd a Yahoo! Message
Anon, thanks for the suggestions. I changed the name, commented what I had before, and put what's below, but I'm still getting the same error. Acess is the only one I have uncommented. Now I have this:

strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("./mdb/supersecretninjadatabase.mdb")

Thanks for the help.
Go to Top of Page

AnonJr
Moderator

United States
5768 Posts

Posted - 09 August 2006 :  15:52:07  Show Profile  Visit AnonJr's Homepage
Just for the sake of thoroughness, does the IUSER account has read/write access for the mdb folder and the database itself?
Go to Top of Page

luminousnerd
New Member

USA
97 Posts

Posted - 09 August 2006 :  16:34:02  Show Profile  Visit luminousnerd's Homepage  Send luminousnerd an AOL message  Send luminousnerd a Yahoo! Message
Not sure I understand your question, but the mdb folder is indeed read/write. What's IUSER?

Also, if the folder has it, do I still need to have them give the file itself read/write?
Go to Top of Page

AnonJr
Moderator

United States
5768 Posts

Posted - 09 August 2006 :  16:41:03  Show Profile  Visit AnonJr's Homepage
IUSER is the anonymous access account on an IIS web server. Usually you'll see it as IUSER_MACHINENAME where MACHINENAME is the name of your server (though you may just see it as IUSER).

This account needs to have read/write access to both the directory and the database itself. Some servers are set up so that the database will inherit the permissions of the folder, but its always worth double-checking.
Go to Top of Page

luminousnerd
New Member

USA
97 Posts

Posted - 09 August 2006 :  17:07:34  Show Profile  Visit luminousnerd's Homepage  Send luminousnerd an AOL message  Send luminousnerd a Yahoo! Message
Hmm, I shall call my host about this and let you know. Thanks for the help :)
Go to Top of Page

AnonJr
Moderator

United States
5768 Posts

Posted - 09 August 2006 :  18:42:06  Show Profile  Visit AnonJr's Homepage
Ok. Let us know how it turns out.
Go to Top of Page

luminousnerd
New Member

USA
97 Posts

Posted - 10 August 2006 :  11:17:26  Show Profile  Visit luminousnerd's Homepage  Send luminousnerd an AOL message  Send luminousnerd a Yahoo! Message
The host says that it is already correct, but our host has been known to lie before, so is there any way to check from our end?

Thanks a lot

Also, is there anyone we could pay to install and configure this for us?
Go to Top of Page

AnonJr
Moderator

United States
5768 Posts

Posted - 10 August 2006 :  12:39:55  Show Profile  Visit AnonJr's Homepage
Do your host allow you to set/check file and folder permissions from either an FTP client or a web-based control panel? If they do, that would be the easiest way to double-check.
Go to Top of Page

luminousnerd
New Member

USA
97 Posts

Posted - 10 August 2006 :  13:08:19  Show Profile  Visit luminousnerd's Homepage  Send luminousnerd an AOL message  Send luminousnerd a Yahoo! Message
AnonJr, don't think so :( It's a Windows host, I thought only Linux ones could do that? Support at least told me that I could not do it myself.

Marshall, I don't know much about MDBs and I really don't understand them (honestly I think they are a bit runaround...but that's Microsoft for you). I'm trying the browser.zip but I'm not sure what to do with it or how it will help. Would you mind explaining a bit for a n00b like myself?

Thanks
Go to Top of Page
Page: of 2 Previous Topic Topic Next Topic  
Next Page
 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.63 seconds. Powered By: Snitz Forums 2000 Version 3.4.07