Re: 80004005 Unspecified Error

Tech-Archive recommends: Fix windows errors by optimizing your registry




"Bob Barrows [MVP]" wrote:

> Dimitris Pantazopoulos wrote:
> > It is very very true indeed.
>
> What is? That permissions to the TEMP directory are required when using the
> OLE DB Provider for Jet? Not in my experience. I have never had to grant
> IUSR or any other user account permissions to the TEMP folder when using OLE
> DB.
>
> cn.open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
> "Data source=.c:\path\to\db.mdb"
>

Maybe you are not experienced enough with this problem. Facts are facts and
yes the permissions issue is true.

> >
> > First, I did not expect MVPs to argue over cute variable names ("cn"
>
> Oh please. Get a sense of humor, will you? We're not a help desk here. We're
> a bunch of users trying to help other users. Sometimes that means getting
> help for things you weren't asking about. When that happens: deal with it!
> We're not going to change our personalities - you are not paying us for our
> time, are you?
>

If this humour then it must be really hot in alaska.

> > 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!
>
> We didn't. There is no way I could force him to change his code if he didn't
> want to.
>

I am aware of at least one case where someone was sentenced because he gave
instructions online to a kid on how to commit suicide.

> >
> > Second, I want to verify the occurance of the dreadfull 80004005
> > error when connecting to Access databases from asp code.
>
> Sorry, but I don't understand the question. What do you mean by "verify the
> occurrence"?
>

Replying to dmiller23462 you said: "I've never seen a connection.open
statement generate an uinspecified error."

Well, it seems like everybody else has seen lots of.


> > * 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).
>
> So you say. Why should we take your word for it. I can't count how many
> times a poster has said "the permissions are correct" only to find out later
> that they were not correct when we finally dragged the details out of him.
>

I use password-free access databases. no users, no passwords, no
authentication. full access. for everyone. Honestly!

> > * 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!
>
> So you're still using ODBC? Again, if you use OLE DB for Jet, you do not
> have to worry about the TEMP/TMP folder.
>

Who said anything about odbc ?
does the following looks like odbc to you ? :

"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=webcontent.mdb"

I don't think so.


now, any real solution ?
dp

.



Relevant Pages

  • Re: 80004005 Unspecified Error
    ... That permissions to the TEMP directory are required when using the ... IUSR or any other user account permissions to the TEMP folder when using OLE ... > error when connecting to Access databases from asp code. ...
    (microsoft.public.inetserver.asp.db)
  • Re: error:operation must use an updatable query
    ... Read, Write, eXecute and Delete permissions on the folder where the MDB file ... This is a common problem with ASP code. ... Doug Steele, Microsoft Access MVP ... > I am facing an error Inserting data into the database.I am using cgi-perl ...
    (microsoft.public.access.gettingstarted)
  • Re: aspnet_wp reboot required regularly
    ... > regular .net Windows Form. ... This will be a permissions problem. ... ASP code runs as a specific user ...
    (microsoft.public.dotnet.framework.interop)
  • wshshell.run
    ... I'm trying to start up a command from inside my asp code to modify ... permissions on folders. ... Microsoft VBScript runtime error '800a01a8' ...
    (microsoft.public.dotnet.framework.aspnet)
  • IIS permissions problem
    ... DB using simple asp code, tells that database or object ... I tried to set all permissions to read and ... write through IIS, but it doesn't work. ...
    (microsoft.public.win2000.security)