RE: 80004005 Unspecified Error

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



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")
>
.



Relevant Pages

  • RE: Question: Buffer Overrun in Microsoft Data Access Components Coul d Lead to Code Execution (Q32
    ... Microsoft web site indicates that a backout isn't recommended... ... re-deploy is needed to undo the upgrade. ... > installations with MDAC 2.7. ... > figure out just what is going on and where the vulnerability lies. ...
    (Focus-Microsoft)
  • Re: MDAC question
    ... it is best to install the earlier version ... treated as more of a o/s upgrade and NOT simply the sole dependancy of any ... > version of MDAC than you plan to use during development. ... provides a newer 2.8 interface. ...
    (microsoft.public.vb.general.discussion)
  • Re: From 2.5 to 2.8
    ... >I have a windows 2000 server with MDAC. ... Will the developers of ASP ... >consideration before upgrading to 2.8 MDAC. ... have never had a problem with an MDAC upgrade, ...
    (microsoft.public.data.ado)
  • RE: Question: Buffer Overrun in Microsoft Data Access Components Coul d Lead to Code Execution (Q32
    ... Subject: Question: Buffer Overrun in Microsoft Data Access Components ... Microsoft also lists upgrading to MDAC 2.7 as another fix. ... figure out just what is going on and where the vulnerability lies. ... upgrade to 2.7, ...
    (Focus-Microsoft)