Wrox Home  
Search P2P Archive for: Go

  Return to Index  

asp_database_setup thread: Microsoft OLE DB Provider for ODBC Drivers error '80004005'


Message #1 by "Tom McVeagh" <tmcveagh@i...> on Wed, 20 Jun 2001 13:14:58
I'm getting the following error when I try to insert data into an Access db



Microsoft OLE DB Provider for ODBC Drivers error '80004005' 



[Microsoft][ODBC Microsoft Access 97 Driver] Can't open database 

'(unknown)'. It may not be a database that your application recognizes, or 

the file may be corrupt.



I'm probably being really dumb, but ... any ideas?

Message #2 by "Ken Schaefer" <ken@a...> on Mon, 25 Jun 2001 11:24:34 +1000
a) is the database an Access 2000 database?

b) is the database corrupt? (did you try compact/repair?)

c) does the anonymous user account have permissions to the database, and the

folder that the database is in?



Cheers

Ken



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

----- Original Message -----

From: "Tom McVeagh" <tmcveagh@i...>

To: "ASP Database Setup" <asp_database_setup@p...>

Sent: Wednesday, June 20, 2001 1:14 PM

Subject: [asp_database_setup] Microsoft OLE DB Provider for ODBC Drivers

error '80004005'





: I'm getting the following error when I try to insert data into an Access

db

:

: Microsoft OLE DB Provider for ODBC Drivers error '80004005'

:

: [Microsoft][ODBC Microsoft Access 97 Driver] Can't open database

: '(unknown)'. It may not be a database that your application recognizes, or

: the file may be corrupt.

:

: I'm probably being really dumb, but ... any ideas?





Message #3 by "Alex Souza" <alexsouza@m...> on Mon, 25 Jun 2001 09:34:44 -0300
I got this error too...



The Microsoft Certificate server uses an Access 97 database and in the debug

code of that ASP file it says when this occurs, try re-starting IIS!!!

awful no?



This error also occurs when you try to connect to an Access database which

is not located in the same place of IIS server...and sometimes by unknown

reasons... What I have to do, here, is re-start IIS then the connection is

reestablished!



I noticed that if you have too much data exchange using Access it halts the

connection sometimes... this do not occur using, for example, Oracle or SQL

Server databases...



Alex

Brazil



----- Original Message -----

From: "Ken Schaefer" <ken@a...>

To: "ASP Database Setup" <asp_database_setup@p...>

Sent: Sunday, June 24, 2001 10:24 PM

Subject: [asp_database_setup] Re: Microsoft OLE DB Provider for ODBC Drivers

error '80004005'





> a) is the database an Access 2000 database?

> b) is the database corrupt? (did you try compact/repair?)

> c) does the anonymous user account have permissions to the database, and

the

> folder that the database is in?

>

> Cheers

> Ken

>

> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

> ----- Original Message -----

> From: "Tom McVeagh" <tmcveagh@i...>

> To: "ASP Database Setup" <asp_database_setup@p...>

> Sent: Wednesday, June 20, 2001 1:14 PM

> Subject: [asp_database_setup] Microsoft OLE DB Provider for ODBC Drivers

> error '80004005'

>

>

> : I'm getting the following error when I try to insert data into an Access

> db

> :

> : Microsoft OLE DB Provider for ODBC Drivers error '80004005'

> :

> : [Microsoft][ODBC Microsoft Access 97 Driver] Can't open database

> : '(unknown)'. It may not be a database that your application recognizes,

or

> : the file may be corrupt.

> :

> : I'm probably being really dumb, but ... any ideas?

>

>

>

>

Message #4 by Tatyana.Mironova@b... on Mon, 25 Jun 2001 09:52:59 -0700
Access only allows to perform the operation involving 255 fields.

If you have more fields - you 'll get this error message.

Solution- you have to have two or more inserts.

Tatyana 



-----Original Message-----

From: Ken Schaefer [mailto:ken@a...]

Sent: Sunday, June 24, 2001 6:25 PM

To: ASP Database Setup

Subject: [asp_database_setup] Re: Microsoft OLE DB Provider for ODBC

Drivers error '80004005'





a) is the database an Access 2000 database?

b) is the database corrupt? (did you try compact/repair?)

c) does the anonymous user account have permissions to the database, and the

folder that the database is in?



Cheers

Ken



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

----- Original Message -----

From: "Tom McVeagh" <tmcveagh@i...>

To: "ASP Database Setup" <asp_database_setup@p...>

Sent: Wednesday, June 20, 2001 1:14 PM

Subject: [asp_database_setup] Microsoft OLE DB Provider for ODBC Drivers

error '80004005'





: I'm getting the following error when I try to insert data into an Access

db

:

: Microsoft OLE DB Provider for ODBC Drivers error '80004005'

:

: [Microsoft][ODBC Microsoft Access 97 Driver] Can't open database

: '(unknown)'. It may not be a database that your application recognizes, or

: the file may be corrupt.

:

: I'm probably being really dumb, but ... any ideas?









Message #5 by "Ken Schaefer" <ken@a...> on Tue, 26 Jun 2001 11:33:36 +1000
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

:

: The Microsoft Certificate server uses an Access 97 database

: and in the debug code of that ASP file it says when this occurs,

: try re-starting IIS!!! awful no?

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~



There is a KB article that addresses this. You're connection to the

certificate server's database gets stuffed up by installing newer MDACs -

there is a reg file you can download from the MS website that fixes these

problems.



http://support.microsoft.com/support/kb/articles/Q217/3/39.ASP



Cheers

Ken






  Return to Index