MS SQL Server and Linked Server to PostgreSQL 9.0 with non s

More
9 years 10 months ago #4520 by toyman
We are looking for solution of the following problem: We have two applications – one which use MS SQL 2008 R2 to store data, second which use PostgreSQL 9.0 to store data. We need to link those database servers for reporting purposes via Linked Servers in MS SQL.

We have full access for MS SQL database without any limitations or needs for use special libraries, but have restricted access for PostgreSQL database because developer of the second application use libpq library especially developed for this application (we have this library, and have all connection parametres).

Homepage of the PGNP says: “It implements most of the OLEDB interfaces and uses libpq to access a PostgreSQL database.”. We tryed “PGNP OLEDB Provider v1.4 for PostgreSQL, Server Edition.” (Trial version at the moment) and looks like that Linked Servers with PGNP provider should be perfect for this purpose – but copying libpq.dll into installation directory of PGNP doesn’t work. We have following error:
“OLE DB provider “PGNP” for linked server “MYSERVER” returned message “FATAL: password authentication failed for user “myuser””
When we use this libpq.dll with other software connecting to PostgreSQL 9.0 database (eq. pgAdmin III) it just works when we put library into it’s executing folder.
Can You tell me how can We import libpq.dll into PGNP installation ?

Please Log in or Create an account to join the conversation.

More
9 years 9 months ago #4522 by Moderator
If application was written for libpq, the oledb provider cannot be used.

Please Log in or Create an account to join the conversation.

Time to create page: 0.043 seconds
Powered by Kunena Forum