Posting a subfunction I'm using right now.....I keep getting the
following error;
_______________________________________________
Microsoft JET Database Engine error '80004005' |
|
Unspecified error |
|
line 277 |
_______________________________________________|
I've searched thru previous entries but can't find anything that seems
pertinent to my problem....Any ideas looking at my code? I've used this
EXACT syntax before with no issues....
The DB is MS Access 2000 and there is no security on the db so I don't
think it should be an authentication issue....I dunno though, still
scratching my head....
BTW, Line 277 is my line where I'm opening the connection...I've
annotated it in the code...
'*********************************************************** ******************
Sub Database()
'create db connection
Set authremove = Server.CreateObject("ADODB.Connection")
'open db in a DSN-less method
LINE 277 --> authremove.Open "PROVIDER=MICROSOFT.JET.OLEDB.4.0;DATA
SOURCE="& Server.MapPath("/Secured_Archives/eucs.mdb")
'display results of statement on screen for testing purposes
'Response.Write(stateSQL)
'remind the SQL statement who it works for
authremove.Execute(stateSQL)
'smack around the db connection until it lets go
authremove.Close
'kill the connection with extreme prejudice
set authremove = nothing
End Sub
'*********************************************************** ******************
Re: 80004005 Unspecified Error
am 12.04.2005 14:42:11 von reb01501
dmiller23462 wrote:
> Posting a subfunction I'm using right now.....I keep getting the
> following error;
> _______________________________________________
> Microsoft JET Database Engine error '80004005' |
> |
> Unspecified error |
> |
> line 277 |
> _______________________________________________|
>
> I've searched thru previous entries but can't find anything that seems
> pertinent to my problem....Any ideas looking at my code? I've used
> this EXACT syntax before with no issues....
>
> The DB is MS Access 2000 and there is no security on the db so I don't
> think it should be an authentication issue....I dunno though, still
> scratching my head....
>
> BTW, Line 277 is my line where I'm opening the connection...I've
> annotated it in the code...
>
>
'*********************************************************** ****************
**
> Sub Database()
> 'create db connection
> Set authremove = Server.CreateObject("ADODB.Connection")
>
> 'open db in a DSN-less method
> LINE 277 --> authremove.Open "PROVIDER=MICROSOFT.JET.OLEDB.4.0;DATA
> SOURCE="& Server.MapPath("/Secured_Archives/eucs.mdb")
I've never seen a connection.open statement generate an uinspecified error.
I suspect line 277 is not the line you think it is. To verify, create a new
test page and insert only the lines:
<%
Set authremove = Server.CreateObject("ADODB.Connection")
'authremove ? why not use cn along with the rest of the world?
Run the page. Do you get the error? If not, start adding lines from the
problem page, repeating the test until you find the actual line that's
raising the error.
Bob Barrows
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.
Re: 80004005 Unspecified Error
am 12.04.2005 17:53:00 von ten.xoc
> Set authremove = Server.CreateObject("ADODB.Connection")
> 'authremove ? why not use cn along with the rest of the world?
You mean conn, right? :-)
Re: 80004005 Unspecified Error
am 12.04.2005 18:17:44 von dmiller23462
I only use that particular variable to sort of "distinguish" between
the different tables in the same Access DB (one table of data for each
of my 17 online forms)....Just a personal quirk, I guess....
Is there anything OBVIOUSLY wrong with the SQL statement? All the
fields match up....It's the next line down from 277 so maybe, like you
said, line 277 isn't what I think it is....
Hmmmm....
Re: 80004005 Unspecified Error
am 12.04.2005 18:36:03 von ten.xoc
Well, you have a Response.Write line in there. Care to show us the results
(the concatenated SQL statement you are sending to the database, not the
code used to build it)?
--
This is my signature. It is a general reminder.
Please post DDL, sample data and desired results.
See http://www.aspfaq.com/5006 for info.
"dmiller23462" wrote in message
news:1113322664.089635.8240@z14g2000cwz.googlegroups.com...
>I only use that particular variable to sort of "distinguish" between
> the different tables in the same Access DB (one table of data for each
> of my 17 online forms)....Just a personal quirk, I guess....
>
> Is there anything OBVIOUSLY wrong with the SQL statement? All the
> fields match up....It's the next line down from 277 so maybe, like you
> said, line 277 isn't what I think it is....
>
> Hmmmm....
>
Re: 80004005 Unspecified Error
am 12.04.2005 19:19:04 von dmiller23462
Aaron,
Thanks for the quick response!
It doesn't even let me get to the results....The Response.Write I had
in there I put in for debugging purposes but it won't even let me get
that far....
Tried one thing just a minute ago, to appease Bob. I changed the
"authremove" variable to "dbconn" but it still didn't take....
Hmmmm....
Like I mentioned, I've used the exact syntax for the connection on all
the rest of my 17 online submission forms...
I'm still digging thru and trying to see if I did anything stupid that
may be glaring out at me....
Here's the code for the form it's drawing data from to append to the
DB....My apologies for the "clunkiness" of it, I'm still learning
gradually among all the other trouble calls I get through-out the
day...
'*********************************************************** ******************
'* FORM FOR DATA INPUT
*
'*********************************************************** ******************
Sub Form()
Response.Write "
Authorization removal forms are to
be used when an issuing bank requests to receive "
Response.Write "authorization removal via fax. Fill in information
below and submit the form."
Response.Write "
name='authorizationremoval' onSubmit='validate()'>"
Response.Write "
"
Response.Write "
"
Response.Write "
"
Response.Write ""
Response.Write "Please remove the following authorizations from
your client's credit/debit card.
Just commented out the "connection" line just to see.....The data it's
pulling is accurate...This is the output of the
Response.Write(stateSQL) line...
dmiller23462 wrote:
> Just commented out the "connection" line just to see.....The data it's
> pulling is accurate...This is the output of the
> Response.Write(stateSQL) line...
>
> INSERT INTO auth_removal([to], [to_fax], [from], [from_fax],
> [authname], [cc_number], [expmonth], [expyear], [auth_codes],
> [amount], [supervisor], [comments]) VALUES
>
('werawer','65986556','wearef','68985665','','sdafasdf','555 555555555555','0
4','08','665546546','55555','afawdef','etstsavaweee')
Which line did you mean by "'connection' line"? The Execute statement?
This statement looks strange. You've delimited ALL the values, but you seem
to have some fields that are numeric: amount for one. Are these really all
Text fields?
Bob Barrows
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.
Re: 80004005 Unspecified Error
am 12.04.2005 20:40:15 von dmiller23462
No sir....
The fields properties are as follows
[to] - text
[to_fax] - text
[from] - text
[from_fax] - text
[authname] - text
[cc_number] - text
[expmonth] - text
[expyear] - text
[auth_codes] - text
[amount] - currency
[supervisor] - text
[comments] - memo
Re: 80004005 Unspecified Error
am 12.04.2005 20:42:18 von dmiller23462
My apologies, Bob, for not answering your first question...
By "connection line", I was referring to my creation of the db
connection;
The data value for this portion of the VALUES() list should not be
surrounded by '' ... this is a numeric value, not a string, so should not be
enclosed in string delimiters.
Re: 80004005 Unspecified Error
am 12.04.2005 21:00:53 von reb01501
dmiller23462 wrote:
> No sir....
>
> The fields properties are as follows
>
> [to] - text
> [to_fax] - text
> [from] - text
> [from_fax] - text
> [authname] - text
> [cc_number] - text
> [expmonth] - text
> [expyear] - text
> [auth_codes] - text
> [amount] - currency
> [supervisor] - text
> [comments] - memo
> VALUES
('werawer','65986556','wearef','68985665','','sdafasdf','555 555555555555','0
4','08','665546546','55555','afawdef','etstsavaweee')
OK. Amount is a currency field, which is numeric. Why have you put quotes
around the value '55555' in your VALUES clause? Only values going into text
and memo fields should be quoted.
> My apologies, Bob, for not answering your first question...
>
> By "connection line", I was referring to my creation of the db
> connection;
>
> authremove.Open "PROVIDER=MICROSOFT.JET.OLEDB.4.0;DATA SOURCE="&
> Server.MapPath("/Secured_Archives/eucs.mdb")
This is not computing. This line by itself causes an error to occur?? When
you comment it out (and leave the "authremove.execute ..." line uncommented)
you don't get any errors?
Look, your biggest mistake is using dynamic SQL. You should be using saved
parameter queries (read the last few paragraphs here:
http://groups-beta.google.com/group/microsoft.public.inetser ver.asp.db/msg/c966c9c8eb98f331?hl=en&lr=&ie=UTF-8&c2coff=1)
But if you can't do that for some reason, you can still do this:
http://groups-beta.google.com/group/microsoft.public.vi.gene ral/msg/0c76ae56f800dd59
HTH,
Bob Barrows
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.
Re: 80004005 Unspecified Error
am 13.04.2005 17:24:06 von dmiller23462
Hey guys....
Finally getting to sit back down and look at this again (busy day in
the warehouse!)
On the advice of Bob yesterday, I made up a whole new page with the
snippet of the connection code....Still got the same error...
**********
<%
Set authremove = Server.CreateObject("ADODB.Connection")
'authremove ? why not use cn along with the rest of the world?
That code still gave me the error....It says it is now on line
5...(authremove.open line)
The db is exactly where I've set the Server.MapPath to....I can't think
of anything else in the line of code that would set up red flags....I
was perusing a site a bit ago that suggested putting in uid and pw with
no values even if the DB used no authentication....Tried that to no
avail....
Any other ideas? I've verified that the Access db has sufficient r/w
rights given to the I_USR account....There is no password on the
account and all of my previous online forms that currently write to the
database have no problems to speak of...
I'm about to start tearing what little hair I have left out....
Re: 80004005 Unspecified Error
am 13.04.2005 17:32:54 von reb01501
dmiller23462 wrote:
> Hey guys....
>
> Finally getting to sit back down and look at this again (busy day in
> the warehouse!)
>
> On the advice of Bob yesterday, I made up a whole new page with the
> snippet of the connection code....Still got the same error...
>
> **********
> <%
> Set authremove = Server.CreateObject("ADODB.Connection")
> 'authremove ? why not use cn along with the rest of the world?
>
> authremove.Open "PROVIDER=MICROSOFT.JET.OLEDB.4.0;" & _
> "DATA SOURCE="& Server.MapPath("/Secured_Archives/eucs.mdb")
> authremove.close: set authremove = nothing
>
> %>
> ************
>
> That code still gave me the error....It says it is now on line
> 5...(authremove.open line)
>
> The db is exactly where I've set the Server.MapPath to....I can't
> think of anything else in the line of code that would set up red
> flags....I was perusing a site a bit ago that suggested putting in
> uid and pw with no values even if the DB used no
> authentication....Tried that to no avail....
>
> Any other ideas? I've verified that the Access db has sufficient r/w
> rights given to the I_USR account....There is no password on the
> account and all of my previous online forms that currently write to
> the database have no problems to speak of...
>
> I'm about to start tearing what little hair I have left out....
Can the database be opened in Access? Try doing a Compact/Repair.
--
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"
Re: 80004005 Unspecified Error
am 13.04.2005 18:29:46 von dmiller23462
Yes Sir....
I've opened it up with Access, several times....The last time I went in
just to verify that each field was the correct datatype....
I'll try to create a new db table from scratch and see if that has any
effect...
Re: 80004005 Unspecified Error
am 16.04.2005 02:26:49 von que
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-vo latile-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
Hope this helps!
"dmiller23462" wrote in message
news:1113331338.193873.48440@g14g2000cwa.googlegroups.com...
> My apologies, Bob, for not answering your first question...
>
> By "connection line", I was referring to my creation of the db
> connection;
>
> authremove.Open "PROVIDER=MICROSOFT.JET.OLEDB.4.0;DATA SOURCE="&
> Server.MapPath("/Secured_Archives/eucs.mdb")
>
Re: 80004005 Unspecified Error
am 16.04.2005 02:41:07 von reb01501
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-vo latile-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"
Re: 80004005 Unspecified Error
am 19.05.2005 14:41:06 von DimitrisPantazopoulos
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-vo latile-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"
>
>
>
Re: 80004005 Unspecified Error
am 19.05.2005 16:18:58 von reb01501
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.
>
> 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?
> 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.
>
> 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"?
> * 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.
> * Prior to some windows and/or mdac update, OUR code worked just
> fine. Now it just produces this error.
Well, that's helpful ...
> * 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.
Bob Barrows
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.
Re: 80004005 Unspecified Error
am 19.05.2005 17:18:02 von DimitrisPantazopoulos
"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 ? :
Dimitris Pantazopoulos wrote:
> "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.
LOL I have hundreds of asp pages in production, many of which connect to
Access databases. I don't run into this problem. You do. Who has more
credibility here ...?
> Facts are
> facts and yes the permissions issue is true.
Again - how do we know this? You haven't shown us a single line of code.
>
>>>
>>> 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.
Again. Don't ask for free help and then complain when the help you receive
is not what you expected. You can always cough up the funds and call MS
Product Support ...
>
>>> 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.
plonk
--
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"
Re: 80004005 Unspecified Error
am 19.05.2005 19:12:42 von Chris Hohmann
"dmiller23462" wrote in message
news:1113308434.734520.24080@l41g2000cwc.googlegroups.com...
> Posting a subfunction I'm using right now.....I keep getting the
> following error;
> _______________________________________________
> Microsoft JET Database Engine error '80004005' |
> |
> Unspecified error |
> |
> line 277 |
> _______________________________________________|
>
> I've searched thru previous entries but can't find anything that seems
> pertinent to my problem....Any ideas looking at my code? I've used this
> EXACT syntax before with no issues....
>
> The DB is MS Access 2000 and there is no security on the db so I don't
> think it should be an authentication issue....I dunno though, still
> scratching my head....
>
> BTW, Line 277 is my line where I'm opening the connection...I've
> annotated it in the code...
>
> '*********************************************************** ******************
> Sub Database()
> 'create db connection
> Set authremove = Server.CreateObject("ADODB.Connection")
>
> 'open db in a DSN-less method
> LINE 277 --> authremove.Open "PROVIDER=MICROSOFT.JET.OLEDB.4.0;DATA
> SOURCE="& Server.MapPath("/Secured_Archives/eucs.mdb")
>
> stateSQL = "INSERT INTO auth_removal([to], [to_fax], [from],
> [from_fax], [phone], [name], " &_
> " [cc_number], [expmonth], [expyear], [auth_codes], [amount],
> [supervisor], [comments]) " &_
> "VALUES ('" & Replace(FaxTo,"'","''") & "','" & ToFax & "','" &
> Replace(FaxFrom,"'","''") & "','" & FromFax & "','" &_
> Phone & "','" & Replace(AuthName,"'","''") & "','" & CCNumber &
> "','" &_
> ExpMonth & "','" & ExpYear & "','" & Replace(AuthCodes,"'","''") &
> "','" &_
> Amount & "','" & Replace(Supervisor,"'","''") & "','" &
> Replace(Comments,"'","''") & "')"
>
> 'display results of statement on screen for testing purposes
> 'Response.Write(stateSQL)
>
> 'remind the SQL statement who it works for
> authremove.Execute(stateSQL)
>
> 'smack around the db connection until it lets go
> authremove.Close
>
> 'kill the connection with extreme prejudice
> set authremove = nothing
>
> End Sub
> '*********************************************************** ******************
>
Does it in fact point to the database in question? Also, the folder name
seems to indicate it's a secured resource of some sort. Could you describe
the security?
Re: 80004005 Unspecified Error
am 19.05.2005 19:59:48 von DFS
"Dimitris Pantazopoulos"
wrote in message news:79E22B2C-4433-4387-91EF-EC122FBFC48B@microsoft.com...
>>
>>
>> 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.
That's a problem with the judicial system, not with Bob's comment.
Re: 80004005 Unspecified Error
am 20.05.2005 03:33:28 von mmcginty
"Dimitris Pantazopoulos"
wrote in message news:A556904C-ED16-4915-9BD3-D3B7A18A6960@microsoft.com...
> It is very very true indeed.
>
> First, I did not expect MVPs to argue over cute variable names
You got the bonus plan, then. Thing you have to consider is, when you post
your petty complaints about our free advice like that, you cut our incentive
to spend further time on your issue, to the bone.
> * The error message usually is "unspecified error" (but not always).
If the error message is inconsistent, then it's likely you're either dealing
with multiple problems, or you have a resource leak/hardware
problem/corrupted o/s.
> * The error has nothing to do either with db authentication or badly
> written
> code (mispelled connection strings etc).
a.) It often happens that questionable coding practices get broken by o/s
patches and updates. In today's climate of opportunistic vandalism and with
critical short-falls on ethics becomming distressingly common, virtually
every update that comes down the pike restricts access and hardens security.
Code will get broken by updates just a sure as script kiddies and hackers
will violate vulnerable systems. You have no choice but to get real with
it.
b.) Just because your Jet database has none of Jet's [lame] security
applied, does not make you free from security concerns. Access is a COM+
server, it has associated launch and activation permissions. NTFS
permissions also apply. The first connection to a Jet db causes the
creation of an .LDB file in the same dir as the .MDB, maybe this page is
accessed via multiple different security contexts, maybe it works when an
admin logs in -- the possibilities are almost endless. You need to take a
more wholistic view of the entire scenario.
> * Prior to some windows and/or mdac update, OUR code worked just fine. Now
> it just produces this error.
Wah! [See item a. above.]
> * It so happens that the same asp code may work today but not tomorrow or
> the day after!!!
In that case, forgive me for being so flip, but it sucks to be you, don't
it? [See item b.) above.] There is clearly something going on that's
deeper than you're looking. While it's working try dumping all of the
connection object's dynamic [and static] properties, then do the same while
it's failing, maybe you'll notice something significant.
Have you tried enumerating the connection.errors collection? VBS typically
only dumps the first error, though there may be more.
> 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!
Again, sounds like a deeper permissions issue -- not a Jet permissions
issue, but Jet is far from the last line of defense.
> * 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).
XP ships with IIS 5.1; 2K server ships with IIS 5.0. They are very similar,
but most definitely not the same. Also, of course your code runs perfectly,
all objects on the same box, logged in as an admin, with all kinds of cached
credentials... All that means is it *might* run without problems on any
given server. It does NOT mean that your code is flawless, nor does it mean
it is coded to function well in a server environment.
> 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.
No kidding! "Unspecified" errors are catch-alls for problems they don't
expect to impact the main stream of users, and therefore decline to invest
in what it would take to render a meaningful error in all cases.
> My opinion is, it must be side-effect of some windows update.
If your opinion was highly valuable in this instance, you wouldn't be asking
for help on the usenet, would you?
> There is really nothing we can do to solve this problem once and for all,
> right ?
About all the scenarios that can cause an unspecified error to occur? Nope,
there's no solution. About the problem, or cocktail of problems you have on
tap, hard to say -- but the more combative and closed-minded you are, the
less likely it is your issue will be resolved here.
Sorry if my "tough love" approach has offended you... but if you want
further consideration, I'd suggest you get over it. :-)
-Mark
> 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-vo latile-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"
>>
>>
>>
Re: 80004005 Unspecified Error
am 20.05.2005 04:59:44 von jeff.nospam
>* Prior to some windows and/or mdac update, OUR code worked just fine. Now
>it just produces this error.
Then start removing upates until you get it working.
>* It so happens that the same asp code may work today but not tomorrow or
>the day after!!!
Same code, run at the same time, with the same inputs and outputs?
>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!
Then it didn't work. When you restart IIS it does not reset file
permissions.
>* 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).
Different system, different setup, different security, etc. Just
because it runs on one system is no indication that it will run on
asimilar system.
>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.
What have you done to prove or disprove that opinion? Test and see.
>There is really nothing we can do to solve this problem once and for all,
>right ?
Nothing "we" can do, but there is likely something "you" can do.
Though you still don't provide enough details to tell you what that
is.
Work through it logically. If it worked fine, then something got
updated and it no longer works as expected, undo that update or change
to see if it fixes your issue.
Jeff
Re: 80004005 Unspecified Error
am 20.05.2005 12:11:05 von DimitrisPantazopoulos
Jeff, one logical man at last! :)
Well you guys (Bob, Mark) can you please understand that I did not ask for
*your* free, unquestionable, ingenious, sophisticated and
highly-appreciated-worldwide help. You cannot be of any help because you
don't really know why this specific problem ever showed up. Let's stop
playing seek and hide, please.
Regardless of hardware/software setups, deployment environments etc etc,
please let me put things the way *I* see them.
The company I work for, has one server which is also a web server among
other things. The server runs windows 2000 server edition and a whole lot of
other software including IIS etc etc. The administrators try to keep the
server as up-to-date and secure as possible. This means we apply the ms
updates on a regular basis.
I build web applications for the company I work for and since the company
exists for some 15 years now I can sure say there are some very old projects
as well as new ones. Whatever the project age is, they are all pure ASP.
As you can understand, there is no need to tweak 3, 4 or 5-years old
projects as long as they work fine. New projects may still have problems but
I expect web sites built on 1999 to keep working as they always did.
Now, the thing is that some of those projects try to connect to MS Access
databases through ASP. The databases are all in 2000 format and located in
the same, one server we have :) Some of the projects were built back in 1999
and truth is they worked just fine till recently.
Then, one day and totally out of the blue, all of those apps, whether old or
new, started complaining about connecting to Ms Access. The 80004005 error
was the result. I was eager to suspect new projects about mispelled
connection strings, non-existing database files, late-night bugs etc etc BUT
I could not imagine why the 1998, 1999, 2000 apps had stopped working too!
Please rest assure that *noone* has ever touched them all these years!
This is a bad and unfortunate situation, isn't it ? Confronted with a
not-that-helpfull error message with mystic-and-profound reasons. I
understand you cannot fix my lines of code and I really do not want you to. I
know what to do with my code, thank you. Honestly, I found the TEMP/TMP
solution weird too! Never before had this been a problem to consider.
My question is theoritically why ? Why now ? Why in such a large scale ?
I think it must be one of the server updates. Can anyone state otherwise ?
Re: 80004005 Unspecified Error
am 20.05.2005 13:01:02 von EisteGeloioi
Part II:
In my previous post above I forgot to mention that I am talking about OLEDB,
DNS-less connections exclusively.
Please, also visit this *official* link:
http://support.microsoft.com/kb/q251254/
Are you convinced now Bob ?
:))
Re: 80004005 Unspecified Error
am 20.05.2005 15:16:21 von reb01501
Eiste Geloioi wrote:
> Part II:
> In my previous post above I forgot to mention that I am talking about
> OLEDB, DNS-less connections exclusively.
>
> Please, also visit this *official* link:
> http://support.microsoft.com/kb/q251254/
>
> Are you convinced now Bob ?
> :))
Mmm, I'm starting to develop a taste for this crow ... I've been eating
quite a bit of it the last couple weeks.
I could have sworn I read somewhere that the Jet OLE DB provider no longer
needed to create a temp file. That raises two possibilities:
1. This kb article is outdated
2. My memory is faulty
I'm leaning towards option 2 because I can no longer find the article where
this was mentioned.
All I can say is in the several years my apps using Access backends have
been running, I have never had to deal with TEMP/TMP folder permissions or
environment variables.
Let us know if you find any resolution.
Bob Barrows
--
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"
Re: 80004005 Unspecified Error
am 21.05.2005 04:02:14 von jeff.nospam
On Fri, 20 May 2005 03:11:05 -0700, "Dimitris Pantazopoulos" wrote:
>Jeff, one logical man at last! :)
[ Long bit of nonsense snipped because it has no relevance... ]
>My question is theoritically why ? Why now ? Why in such a large scale ?
>I think it must be one of the server updates. Can anyone state otherwise ?
No one can state otherwise. Nor can anyone agree with you. Depsite a
lot of characters typed in your response, there is absolutely nothing
to diagnose your problem with.
Your entire explanation boils down to "It was working. Something
changed. Now it doesn't work." If you want to blame a server update,
go ahead. It's as good an explanation as any with the details you
provide. If you want to fix it, figure out what changed and stop
moaning about the situation and the suggestions you've received so
far.
Jeff
RE: 80004005 Unspecified Error
am 28.06.2005 21:22:04 von gwmtl
A very similar thing happened to us after an upgrade of WSUS, which
apparently changed something in IIS or MDAC. ASP web pages running off an
Access -based content generator which were working fine before, began to give
the "Unspecified Error" you describe. We narrowed down the location of the
error to the .open but were bewildered as to why. We changed all the
permissions suggested by the various support threads, but to no avail.
Finally, we upgraded MDAC to version 2.8 and now our asp scripts are again
running just fine, thank you.
"dmiller23462" wrote:
> Posting a subfunction I'm using right now.....I keep getting the
> following error;
> _______________________________________________
> Microsoft JET Database Engine error '80004005' |
> |
> Unspecified error |
> |
> line 277 |
> _______________________________________________|
>
> I've searched thru previous entries but can't find anything that seems
> pertinent to my problem....Any ideas looking at my code? I've used this
> EXACT syntax before with no issues....
>
> The DB is MS Access 2000 and there is no security on the db so I don't
> think it should be an authentication issue....I dunno though, still
> scratching my head....
>
> BTW, Line 277 is my line where I'm opening the connection...I've
> annotated it in the code...
>
> '*********************************************************** ******************
> Sub Database()
> 'create db connection
> Set authremove = Server.CreateObject("ADODB.Connection")
>
> 'open db in a DSN-less method
> LINE 277 --> authremove.Open "PROVIDER=MICROSOFT.JET.OLEDB.4.0;DATA
> SOURCE="& Server.MapPath("/Secured_Archives/eucs.mdb")
>