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

[Merijn Evertse]

Hi Arvo, 

> -----Original Message-----
> From: Arvo [mailto:arvox at hot.ee] 
> Sent: woensdag 26 april 2006 17:47
> To: Merijn Evertse
> Cc: oledb-devel at pgfoundry.org
> Subject: Re: [Oledb-dev] CoCreate of DSO for PostgreSQL.1 
> returned 0x80040154
> 
> 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."

That did the trick. I now get an error about not being able to connect
to the server, but that seems TCP/IP related and not related to the OLE
DB Provider.

Thanks for the help.

Regards,

Merijn Evertse

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