• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1468
  • Last Modified:

2147467259 was generated by Microsoft OLEDB Persistence Provider Unspecified Error

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?
0
wsturdev
Asked:
wsturdev
  • 3
1 Solution
 
patriktCommented:
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.
0
 
ziolkoCommented:
-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: http://msdn2.microsoft.com/en-us/library/ms810805.aspx for more details.

ziolko.
0
 
ziolkoCommented:
ooops sorry my mistake 80004005 means unspecified error

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

ziolko.
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now