Cannot open database ''. It may not be a database that your application recognizes, or the file may (Full Version)

All Forums >> [Web Development] >> ASP, PHP, and Database



Message

dzirkelb1 -> Cannot open database ''. It may not be a database that your application recognizes, or the file may (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.



TexasWebDevelopers -> RE: Cannot open database ''. It may not be a database that your application recognizes, or the file may (4/9/2009 18:31:25)

So what version of Access database and what version of iis?
You can't connect to Access 97 with Access 2000 or better drivers.
Here is the link to the MDAC 2.8 (there is already a Service Pack 1 for this)
http://www.microsoft.com/downloads/details.aspx?FamilyID=6c050fe3-c795-4b7d-b037-185d0506396c&DisplayLang=en
I know you are also dealing with SQL servers so don't install MDAC 2.6 or later on SQL server 6.5 or 7.0 or you'll screw up the cluster.



dzirkelb1 -> RE: Cannot open database ''. It may not be a database that your application recognizes, or the file may (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 -> RE: Cannot open database ''. It may not be a database that your application recognizes, or the file may (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.



TexasWebDevelopers -> RE: Cannot open database ''. It may not be a database that your application recognizes, or the file may (4/10/2009 18:10:31)

It's such an old version of Access...have you tried using the Microsoft Access ODBC Driver instead?

Driver={Microsoft Access Driver (*.mdb)};Dbq=D:/Data/DeeIntranet.mdb;Uid=Admin;Pwd=;

Also, older versions of Access corrupt very easily--this may really be your problem....



dzirkelb1 -> RE: Cannot open database ''. It may not be a database that your application recognizes, or the file may (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 -> RE: Cannot open database ''. It may not be a database that your application recognizes, or the file may (4/13/2009 17:25:52)

I get an invalid character when I try your connection pointing to the character {



TexasWebDevelopers -> RE: Cannot open database ''. It may not be a database that your application recognizes, or the file may (4/13/2009 18:22:12)

I'm betting it's a corrupted Access DB--I wonder if it's worth it to you to either upgrade Access or consider switching to SQL Lite.



dzirkelb1 -> RE: Cannot open database ''. It may not be a database that your application recognizes, or the file may (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.



TexasWebDevelopers -> RE: Cannot open database ''. It may not be a database that your application recognizes, or the file may (4/14/2009 12:56:59)

One of my internationl clients has just begun the process of moving their servers into VM environments. It's taken 18 months to prepare and will take 5 weekends to complete all of the moves but I already see incredible benefits on some of the SQL servers and storage servers I use. The allocation of both "disk space" and RAM on the fly is just way too cool!



dzirkelb1 -> RE: Cannot open database ''. It may not be a database that your application recognizes, or the file may (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.



TexasWebDevelopers -> RE: Cannot open database ''. It may not be a database that your application recognizes, or the file may (4/14/2009 14:05:43)

Yep--except we have 7 server farms in two countries--takes a bit more preparation since you don't want to lose the data, phones, email, etc. -- needs some serious fail-over protection.



dzirkelb1 -> RE: Cannot open database ''. It may not be a database that your application recognizes, or the file may (4/14/2009 14:27:45)

hehe, ya, definately want a big fall back plan on that occasion



Page: [1]

Valid CSS!




Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI
0.0625