Re: 80004005 Unspecified Error

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

It is very very true indeed.

First, I did not expect MVPs to argue over cute variable names ("cn" vs.
whatever) instead of trying to solve the problem. I can't believe you guys
made the man change his variable name just in case!

Second, I want to verify the occurance of the dreadfull 80004005 error when
connecting to Access databases from asp code.
* The error message usually is "unspecified error" (but not always).
* The error has nothing to do either with db authentication or badly written
code (mispelled connection strings etc).
* Prior to some windows and/or mdac update, OUR code worked just fine. Now
it just produces this error.
* It so happens that the same asp code may work today but not tomorrow or
the day after!!!

Third, I've tried the TEMP/TMP solution also suggested by QUE in this
thread. It worked just fine (I had to restart my win2000 server) TILL I
restarted the IIS. Then the problem appeared again!
* My configuration is: IIS 5 on Windows 2000. My database is Access 2000.
* Exactly the same asp code runs perfectly locally on my XP machine (with
IIS 5 again).

Last but NOT LEAST, obviously Microsoft does not really know how this
problem occured nor how to solve it. None of the msdn articles really
presents a final and deterministic solution.

My opinion is, it must be side-effect of some windows update.

There is really nothing we can do to solve this problem once and for all,
right ?

dp


"Bob Barrows [MVP]" wrote:

> que wrote:
> > I feel like I am in good company this week.
> > I was moving an application from one server to another when it broke.
> > Exactly same error message: Microsoft JET Database Engine error
> > '80004005'
> > Unspecified error
> > from the database connection line
> >
> > It had to be either a permissions problem or a driver issue since it
> > was
> > fine on the old server.
> > I double checked the permissions between servers - ok
> > I tried using a different connection string hoping it was the driver:
> > Conn.open "Driver={Microsoft Access Driver (*.mdb)};DBQ=" & dbpath
> > Got a different error: "[Microsoft][ODBC Microsoft Access
> > Driver]General
> > error Unable to open
> > registry key 'Temporary (volatile) Jet DSN for process"
> >
> > Found this website:
> > http://www.attention-to-details.com/newslog/38n-temporary-volatile-jet-dsn-for-process.asp
> >
> > The solution was the user who has modify rights on the .mdb must also
> > have
> > modify right to the system TEMP directory
> > Tried it - fixed
> > Switched back to original connection string - fixed
> >
>
> That's not true if you use the OLE DB provider for Jet, instead of the ODBC
> driver.
>
> --
> Microsoft MVP - ASP/ASP.NET
> Please reply to the newsgroup. This email account is my spam trap so I
> don't check it very often. If you must reply off-line, then remove the
> "NO SPAM"
>
>
>
.

Relevant Pages

  • Re: OLE DB connection string in SharePoint for Sybase ASA
    ... I wen to the Sybase site and found a reference to Connection String ... > where I WANT it to say Database Connections. ... > and up pops a Data Source Properties Window. ... > Server Error: An error occurred while retrieving the list of Databases ...
    (microsoft.public.frontpage.client)
  • Re: DBIx::DBH - Perl extension for simplifying database connectio ns
    ... Only one of the Informix notations has a host name in it, ... that's technically not a host name but a server name - the distinction ... under the illusion that people who use Perl to access a database know ... The connection string is system-specific -- end of sob story. ...
    (perl.dbi.users)
  • Re: help with changing some code from mdb to adp
    ... At the end of this post is an example of an ADO connection string to a SQL ... Server database, and '' to the UNC path/name of your instance of SQL ... Windows, you can't create a new UDL file directly, but you can create a new, ...
    (microsoft.public.access.adp.sqlserver)
  • ASP: Get user login ID
    ... But when we register the dll on our web ... server, and call it from our ASP code, it generates an error. ... Dim lngCharsReturned As Long ...
    (microsoft.public.inetserver.iis.security)
  • RE: vb6 app no longer connects to Access DB on Term Server 2003
    ... we recently upgraded the Terminal Server from the 2000 version to ... we have tried simplifying the connection string by removing the ... Microsoft ActiveX Data Objects 2.8 Library ... We even tried it on Windows Server 2003 ...
    (microsoft.public.data.oledb)