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

Using PGNP with MS SQL Server, Data Transformation Services (DTS), SQL Server Integration Services (SSIS), Linked Servers, Snapshot and Transactional Replication and more.

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

Postby toyman » Thu Mar 22, 2012 2:48 am

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 ?
toyman
 
Posts: 1
Joined: Thu Mar 22, 2012 2:43 am

Re: MS SQL Server and Linked Server to PostgreSQL 9.0 with n

Postby Moderator » Sat Mar 24, 2012 2:49 pm

If application was written for libpq, the oledb provider cannot be used.
User avatar
Moderator
Site Admin
 
Posts: 297
Joined: Wed Oct 29, 2008 11:27 pm


Return to SQL Server/DTS/SSIS/Linked servers/Replication

Who is online

Users browsing this forum: No registered users and 3 guests

cron