[Oledb-dev] pgoledb.dll won't register

[Shachar Shemesh]

David J N Begley wrote:

>My apologies for what will seem like a really dumb question - I'm coming from
>a Unix/Linux background so this "numerical error" nonsense that Windows is
>using to report problems is being incredibly difficult for me to troubleshoot.
>  
>
The numerical errors have nothing to do with it. The error you quote is
a made up number. I'm just wondering who made it up, as I doubt very
much it was PgOleDb.

>Module C:\Program Files\PostgreSQL\8.1\bin\pgoledb.dll failed to register.
>HRESULT -2147024770.  Contact your support personnel.
>
>After a few futile "Retry" attempts, "Ignore" gets past the error and the rest
>of the upgrade/install works just fine (and PostgreSQL runs quite happily).
>
>I then tried to manually unregister then re-register the DLL - the unregister
>process claimed it "succeeded" but re-registering with "regsvr32" followed by
>the full path to the DLL resulted in:
>
>DllRegisterServer in C:\Program Files\PostgreSQL\8.1\bin\pgoledb.dll failed.
>Return code was: 0x8007007e
>
>The DLLs in the 8.1.2 and 8.1.3 kits appear to be identical and 8.1.2
>originally installed (via "upgrade") on this machine perfectly fine.
>
>Anyone have any clues as to what has broken and how I can manually fix it?
>  
>
Quite frankly, this does not appear to be a PgOleDb bug at all. I
suspect that your OLEDB infrastructure got screwed somehow.

Try downloading and upgrading your MDAC kit (Microsoft Data Access - try
searching for it on the microsoft.com site). I cannot tell you for sure
that it will work, but it is worth a try.

Also, search the registery under
HKEY_LOCAL_MACHINE\System\CurrentControlSet\Classes\ for the keys
specified in
http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/oledb/oledb/ErrorLookupService.rgs?rev=1.1&content-type=text/x-cvsweb-markup
and in
http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/oledb/oledb/Pg.rgs?rev=1.5&content-type=text/x-cvsweb-markup.
Do so after unregistering the DLL. If they still exist, manually delete
them and try again.

If all of the above doesn't work, I'm afraid I'm out of ideas. Believe
me, Linux is my platform of choice too.

>Many thanks for your patience and assistance...
>  
>
       Shachar