2147467259 was generated by Microsoft OLEDB Persistence Provider Unspecified Error

Posted on 2007-08-01
Last Modified: 2012-06-22
I have an Access front end working with data in a SQL Server 2005 back end.  Everything works well, but for some users who have slower connections, through a VPN, they get errors like Error#-2147467259 was generated by Microsoft OLEDB Persistence Provider Unspecified Error.  I cannot find any specific information on this one, but it seems to me it has to do with the volume of data and the slowness of the connection, like the SQL being executed has timed out.  I can run an mdb on this users machine and trap the offending SQL statement, put it into my SQL Server Management Studio and with my very fast connection, it runs with no error.

Does this make sense?  Can anyone shed any light on the situation?  Is there a SQL Server 2005 setting I can change to allow for a longer timeout, if that is what it is?
Question by:wsturdev
    LVL 12

    Expert Comment

    The "Microsoft OLEDB Persistence Provider" can be a problem. How do you connect to SQL server?
    Check if your Access uses Native SQL client which is the best choice.
    LVL 21

    Expert Comment

    -2147467259 is decimal number in hex it's: 80004005
    and it means "Class not registered".

    This error is standard COM error telling that app is trying to access/launch COM interface that is not registered (with regsvr32) or you dont have permissions (dcomcnfg) to access it.

    The big question now is which COM component is not registered, if you knew exact dll/ocx that would be easier. In your situation i would try to reinstall MDAC (because error comes from Microsoft OLEDB) see here: for more details.

    LVL 21

    Expert Comment

    ooops sorry my mistake 80004005 means unspecified error

    LVL 21

    Accepted Solution

    ... I did qiuck search but there's a lot references, all I can suggest: browse msdn and technet for 80004005 (or 0x80004005)


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    I recently came across an interesting Question In EE ( and was puzzled about how to achieve that using SSIS out of the box tasks, which was i…
    In this article—a derivative of my blog post (—I will explore a few different perspectives on which week today's date falls within using Microsoft SQL Server. First, to frame this stu…
    Viewers will learn how the fundamental information of how to create a table.
    Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now