| Author |
 Topic  |
|
|
slant-5
Starting Member
6 Posts |
 Posted - 19 May 2002 : 13:16:59
|
The forum in question:
http://www.slant-5.org/default.asp
Ok I've had my Snitz forums up and running for almost a year now and I have a few mods installed but I haven't made any changes lately. this Friday I go to check out the forums and I get the following error:
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.
/inc_top.asp, line
I haven't changed anything in my script in over a month-- what gives? I've searched these forums and I've tried switching my strConnString to a different way of connecting and I still get an error so I switched it back to the way it was (see below)
I don't have direct access to the server as I'm hosted on www.aspwebserver.com --- Does the database need updated? the server reset? is it on my end? if so- why? since I haven't made any changes at all..
Here's the excerpt from the config.asp:
'#################################################################################
'## SELECT YOUR DATABASE TYPE AND CONNECTION TYPE (access, sqlserver or mysql)
'#################################################################################
'strDBType = "sqlserver"
strDBType = "access"
'strDBType = "mysql"
'## Make sure to uncomment one of the strConnString lines!
'strConnString = "DRIVER={Microsoft Access Driver (*.mdb)};UID=admin;DBQ=" & server.MapPath("../") & "\db\snitz_forums_2000.mdb"
'strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("snitz_forums_2000.mdb") '## MS Access 97 using virtual path
'strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("/USERNAME/db/snitz_forums_2000.mdb") '## MS Access 97 on Brinkster
'strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=c:\inetpub\dbroot\snitz_forums_2000.mdb" '## MS Access 97
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & server.MapPath("../") & "\db\snitz_forums_2000.mdb" '## MS Access 2000 using virtual path
'strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("/USERNAME/db/snitz_forums_2000.mdb") '## MS Access 2000 on Brinkster
'strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\inetpub\dbroot\snitz_forums_2000.mdb" '## MS Access 2000
'strConnString = "driver={SQL Server};server=SERVER_NAME;uid=UID;pwd=PWD;database=DB_NAME" '## MS SQL Server 7
'strConnString = "driver={SQL Server};server=SERVER_NAME;uid=UID;pwd=PWD;database=DB_NAME" '## MS SQL Server 2000
'strConnString = "driver=MySQL;server=SERVER_IP;uid=UID;pwd=PWD;database=DB_NAME" '## MySQL
strTablePrefix = "FORUM_"
strMemberTablePrefix = "FORUM_"
'#################################################################################
'## Do Not Edit Below This Line - It could destroy your forums and lose data
'#################################################################################
|
|
|
HuwR
Forum Admin
United Kingdom
20593 Posts |
Posted - 19 May 2002 : 13:35:08
|
I'm pretty sure this is your problem
server.MapPath("../") & "\db\snitz_forums_2000.mdb"
|
 |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 19 May 2002 : 16:59:04
|
This happens quite frequently when you have the database in an Access 97 file format. If you upgrade the database to Access 2000 or 2002 file format the problem will likely go away.
Sometimes people are not sure whether their databases are in Access 97 format or not. In your case, if you are using the database included with Snitz source code download, you can be sure it's an Access 97 DB.
-------------------------------------------------
Installation Guide | Do's and Dont's | MODs
Edited by - ruirib on 19 May 2002 17:16:08 |
|
|
|
MaD2ko0l
Senior Member
United Kingdom
1053 Posts |
Posted - 19 May 2002 : 17:14:10
|
yes i had that error before all i did was upgrade it to 2000 and then it was all fixed.
© 1999-2002 MaD2ko0l
-=[ Life Is So Easy When You Are Evil ]=- |
|
|
|
slant-5
Starting Member
6 Posts |
Posted - 20 May 2002 : 00:49:02
|
OK well I know that I'm using the DB that came with the Snitz Forum so I guess that means it's in the 97 format if I'm not mistaken.
How do I upgrade it to a 2000 format? can I do it without loosing any of my data?
Thanks for all the help so far!
Slant-5
|
|
|
|
Nathan
Help Moderator
USA
7664 Posts |
Posted - 20 May 2002 : 01:06:10
|
You can. You do need to have Access 2000 or XP installed. If you dont you can send the file to someone who does.
 Nathan Bales
Snitz Exchange | Do's and Dont's |
|
|
|
slant-5
Starting Member
6 Posts |
Posted - 20 May 2002 : 09:36:10
|
OK. So, not trying to seem like a total noob(ehem)..
I have Access 2000.. I assume there's some sort of convert function.. I take the *.mdb file in and convert it and reupload it to the server.
is that it? will I have to change anything in my config.asp?
Thanks
slant-5
|
|
|
|
slant-5
Starting Member
6 Posts |
Posted - 20 May 2002 : 09:39:51
|
Ok I just went to go to try the upgrade onthe *.mdb and I went to go look at my 500 Error again--- and it's gone!!
I haven't touched a thing and it's fixed itself.
What happened here- and why?
Will 97 just Fritz out every now and then? Why?
Oh yeah- I'm still going to try to upgrade to 2000 so the question in the above post still stands.
Thanks again
slant-5
|
|
|
|
Nathan
Help Moderator
USA
7664 Posts |
Posted - 20 May 2002 : 10:10:27
|
quote:
Will 97 just Fritz out every now and then? Why?
Thats a fair accessment of my experience with Access 97. I dont know why, might have somthing to do with the server or somethin.
In Access close any open databases, then go to toos > database utilities > convert database.
Nathan Bales
Snitz Exchange | Do's and Dont's |
|
|
|
alex042
Average Member
USA
631 Posts |
Posted - 20 May 2002 : 10:12:55
|
quote:
I have Access 2000.. I assume there's some sort of convert function.. I take the *.mdb file in and convert it and reupload it to the server.
To convert an Access97 DB to 2000, 1. open Access 2000, 2. click on tools -> database utilities -> convert database -> to current access database version, 3. select your Access97 database, 4. click on convert, 5. name the file and save.
You'll need to make sure its the same name as your 97 database when you upload it to your server or change the name within your config.asp to the correct file name. If you're using the Access97 connection string, you'll need to change that to the 2000 string in your config.asp file. You can then ftp this file up to your sever and replace the 97 version. Also, to make sure your using the most current data, download the online version to convert.
|
|
|
| |
Topic |
|
Topic Locked
