[Oledb-dev] CoCreate of DSO for PostgreSQL.1 returned 0x80040154

[Arvo]

Hello Merijn,

> I installed PgOleDb 1.0.0.20 on MSSQL 2000 (SP4) on Windows 2003 and am
> trying to access a PostgreSQL database.
> The provider string i used is: 
> Provider="PostgreSQL";Data Source=<fqdn>";location="<dbname>;User
> ID=<username>;password=<pass>;timeout=600;

> And when i try i run a query like:
> Select * from openquery(SERVER, 'select * from table)

> I get the following error:
> Could not create an instance of OLE DB provider 'PostgreSQL.1'.
> OLE DB error trace [Non-interface error:  CoCreate of DSO for
> PostgreSQL.1 returned 0x80040154].

I found similar error on google for MySQL - look here:
http://forums.mysql.com/read.php?60,19295,20586#msg-20586

And another one, for DB2/400:
http://www.webservertalk.com/message150962.html

Both note similar possible cause, quote from second thread:

"Generally the error is caused by the provider not being registered on the machine or from not having the in process option set for the provider. For the provider options, if you go to the linked server in enterprise manager, view the properties and select Provider Options. Then make sure the Allow InProcess option is selected."

HTH

-- 
Best regards,
 Arvo                            mailto:arvox at hot.ee