Author |
Topic  |
luminousnerd
New Member

USA
97 Posts |
Posted - 09 August 2006 : 11:21:00
|
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
|
Did you edit config.asp as per the readme? |
 |
|
luminousnerd
New Member

USA
97 Posts |
Posted - 09 August 2006 : 12:02:26
|
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") |
 |
|
ruirib
Snitz Forums Admin
    
Portugal
26364 Posts |
|
luminousnerd
New Member

USA
97 Posts |
Posted - 09 August 2006 : 12:06:30
|
I should mention that the location of the MDB is .com/forum/mdb/snitz_forums_2000.mdb |
 |
|
luminousnerd
New Member

USA
97 Posts |
Posted - 09 August 2006 : 12:21:44
|
Ruirib, yea that's right, sorry, my last post was before I saw yours |
 |
|
AnonJr
Moderator
    
United States
5768 Posts |
Posted - 09 August 2006 : 13:45:16
|
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 |
 |
|
luminousnerd
New Member

USA
97 Posts |
Posted - 09 August 2006 : 14:25:16
|
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. |
 |
|
AnonJr
Moderator
    
United States
5768 Posts |
Posted - 09 August 2006 : 15:52:07
|
Just for the sake of thoroughness, does the IUSER account has read/write access for the mdb folder and the database itself? |
 |
|
luminousnerd
New Member

USA
97 Posts |
Posted - 09 August 2006 : 16:34:02
|
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? |
 |
|
AnonJr
Moderator
    
United States
5768 Posts |
Posted - 09 August 2006 : 16:41:03
|
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.  |
 |
|
luminousnerd
New Member

USA
97 Posts |
Posted - 09 August 2006 : 17:07:34
|
Hmm, I shall call my host about this and let you know. Thanks for the help :) |
 |
|
AnonJr
Moderator
    
United States
5768 Posts |
Posted - 09 August 2006 : 18:42:06
|
Ok. Let us know how it turns out. |
 |
|
luminousnerd
New Member

USA
97 Posts |
Posted - 10 August 2006 : 11:17:26
|
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? |
 |
|
AnonJr
Moderator
    
United States
5768 Posts |
Posted - 10 August 2006 : 12:39:55
|
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. |
 |
|
luminousnerd
New Member

USA
97 Posts |
Posted - 10 August 2006 : 13:08:19
|
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 |
 |
|
Topic  |
|