|
| |
Cannot open database ''. It may not be a database that your application recognizes, or the file may
View related threads:
(in this forum
| in all forums)
|
Logged in as: Guest
|
|
|
dzirkelb1
Posts: 1433
Joined: 10/5/2004
From: Cedar Rapids, Iowa
Status: offline
 |
Cannot open database ''. It may not be a database that ... - 4/9/2009 17:08:48
Periodically throughout the day, I'd say two or three times, all of my pages that use a specific access application will get this error:
quote:
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.
/dbole_noado.inc, line 4
The code for include file is this:
<%
strConn = "PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=D:/Data/DeeIntranet.mdb;Password=;"
Set dbc = Server.CreateObject("ADODB.Connection")
dbc.open strConn
%>
To get rid of the error, I do an iisreset, and it fixes it with 100% success rate. However, it is really annoying.
I have read some about it, they say my database could actually be corrupt. I have done a compact and it still does it. I just did a repair, so we'll see if that works.
I have also read that I need to make sure my jet 4.0 has the most recent version. Also, that I have the most recent mdac installed...however, every link I find to the most recent mdac is an old microsoft link.
Here is the link that I found to get the latest jet / mdac:
http://databases.aspfaq.com/database/how-do-i-get-the-latest-version-of-the-jet-oledb-drivers.html
and the link to mdac is out of date. So, two questions:
1) does anyone know where the most recent MDAC download would be?
2) does anyone have any other ideas of what to try?
I am in the process of updating over 150 pages from access to sql connection, but there will always be some stragglers that just use access...and I'd like to get rid of this once and for all.
|
|
|
|
dzirkelb1
Posts: 1433
Joined: 10/5/2004
From: Cedar Rapids, Iowa
Status: offline
|
RE: Cannot open database ''. It may not be a database t... - 4/10/2009 9:01:57
here are the specs:
access 97
sql 2000
iis 6.0
what do you suggest? It works currently, but like I said, once or twice it will crap out and continue to crap out until i do an iisreset
| |
|
|
|
dzirkelb1
Posts: 1433
Joined: 10/5/2004
From: Cedar Rapids, Iowa
Status: offline
|
RE: Cannot open database ''. It may not be a database t... - 4/10/2009 15:01:54
I was looking at my version of Jet, and I have the following:
4.0.9505.0 Windows Server 2003 SP2
That appears to be the most up to date version of Jet 4.0 for server 2003 sp2.
so, i will install the mdac to make sure that is up to date. If that does not work, then what do I do? Should I upgrade the databases on the web server to a newer version? I would rather not, but can do so if need be.
| |
|
|
|
dzirkelb1
Posts: 1433
Joined: 10/5/2004
From: Cedar Rapids, Iowa
Status: offline
|
RE: Cannot open database ''. It may not be a database t... - 4/13/2009 15:13:47
I did do a repair of the database, and I have not seen the problem since. So, until it happens again, I am going to leave it as is. My next step will be to import all of the data and re-link the tables into a new database to see if that will work. If that doesn't, then i will try the different database connection.
Thanks for your help.
| |
|
|
|
dzirkelb1
Posts: 1433
Joined: 10/5/2004
From: Cedar Rapids, Iowa
Status: offline
|
RE: Cannot open database ''. It may not be a database t... - 4/13/2009 17:25:52
I get an invalid character when I try your connection pointing to the character {
| |
|
|
|
dzirkelb1
Posts: 1433
Joined: 10/5/2004
From: Cedar Rapids, Iowa
Status: offline
|
RE: Cannot open database ''. It may not be a database t... - 4/14/2009 11:58:30
My next step is to import everything into a new database and rename it to the same name to see if that kills the problem. I will not be able to do that for a week or so, however, as I am unable to install access on our server right now (we are down to under 100mg of space on teh C drive, I had to unisntall everything...moving it to virtualization this weekend).
When everything is moved, I will resinstall access and do the change over. If that doestn' work, then I will upgrade it to access 2000 or 2002, can't remember which one we have lying around.
We already have an sql server (2000), but we have sooo many dinky tables to import, it will take forever and I was looking for a patch until I get them all moved over.
| |
|
|
|
dzirkelb1
Posts: 1433
Joined: 10/5/2004
From: Cedar Rapids, Iowa
Status: offline
|
RE: Cannot open database ''. It may not be a database t... - 4/14/2009 13:12:25
And, there is an app that moves the server from a physical environment to the virtual environemtn by a few clicks, and about 5 hours later, bam, exact same server is now virtualized. Turn off one, turn on other, done.
| |
|
|
|
dzirkelb1
Posts: 1433
Joined: 10/5/2004
From: Cedar Rapids, Iowa
Status: offline
|
RE: Cannot open database ''. It may not be a database t... - 4/14/2009 14:27:45
hehe, ya, definately want a big fall back plan on that occasion
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
