|
 |
asp_databases thread: The infamous 80004005 error
Message #1 by =?iso-8859-1?Q?H=E5kan_Frennesson?= <hakan@c...> on Tue, 24 Oct 2000 20:34:34 +0200
|
|
Hi!
I have a few ASP pages, some of them simply displays data from an Access
database and some pages are more complex containing combo boxes retrieving
data from an Access database on an NT Server. They have been working fine
but suddenly this has happened: I get error messages like this (when loading
and reloading):
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access 97 Driver] Couldn't use '(unknown)';
file already in use
OR
error '80004005'
Unspecified error
/xxx.asp, line x
OR
Sometimes they work fine.
The code is "by the book" and itīs an application that is addressing very
few users so the performance is not an issue. What can be wrong here?
Hope you guys can help me out.
Regards,
Hakan Frennesson
Message #2 by "peter" <ph@t...> on Wed, 25 Oct 2000 00:04:57 +0100
|
|
The problem with access is that when its in use it creates an ldb file,
which is temporary but can cause problems with multi user
systems...Sometimes, in fact quite likely, that file has been corrupted
and is causing the faults...in which case try resetting the DB from backup
<drag> or maybe someone else has another solution...
Best of all would be to use SQL..
HTH
peter
Message #3 by "Ken Schaefer" <ken@a...> on Wed, 25 Oct 2000 18:12:45 +1000
|
|
Don't use ODBC - use OLEDB instead:
http://www.adopenstatic.com/faq/whyOLEDB.asp
also make sure you are:
.close
Set = nothing
for all your Recordset and Connection objects
Cheers
Ken
----- Original Message -----
From: "Håkan Frennesson" <hakan@c...>
To: "ASP Databases" <asp_databases@p...>
Sent: Wednesday, October 25, 2000 4:34 AM
Subject: [asp_databases] The infamous 80004005 error
> Hi!
>
> I have a few ASP pages, some of them simply displays data from an Access
> database and some pages are more complex containing combo boxes retrieving
> data from an Access database on an NT Server. They have been working fine
> but suddenly this has happened: I get error messages like this (when
loading
> and reloading):
>
> Microsoft OLE DB Provider for ODBC Drivers error '80004005'
>
> [Microsoft][ODBC Microsoft Access 97 Driver] Couldn't use '(unknown)';
>
> file already in use
>
> OR
>
> error '80004005'
> Unspecified error
> /xxx.asp, line x
>
> OR
>
> Sometimes they work fine.
>
> The code is "by the book" and itīs an application that is addressing very
> few users so the performance is not an issue. What can be wrong here?
>
> Hope you guys can help me out.
>
> Regards,
>
> Hakan Frennesson
|
|
|
View Cart
