Re: 80004005 Unspecified Error
- From: "Dimitris Pantazopoulos" <DimitrisPantazopoulos@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Thu, 19 May 2005 08:18:02 -0700
"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
.
- Follow-Ups:
- Re: 80004005 Unspecified Error
- From: Mark Schupp
- Re: 80004005 Unspecified Error
- From: Bob Barrows [MVP]
- Re: 80004005 Unspecified Error
- References:
- Re: 80004005 Unspecified Error
- From: Dimitris Pantazopoulos
- Re: 80004005 Unspecified Error
- From: Bob Barrows [MVP]
- Re: 80004005 Unspecified Error
- Prev by Date: Re: System.Data.SqlClient.SqlException: Subquery returned more than 1 value.
- Next by Date: Re: System.Data.SqlClient.SqlException: Subquery returned more than 1 value.
- Previous by thread: Re: 80004005 Unspecified Error
- Next by thread: Re: 80004005 Unspecified Error
- Index(es):
Relevant Pages
|