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 ?