Linked server provider options configuration

More
3 years 7 months ago #14458 by pdset
We have setup that should have the following to be checked on the
:
Provider Options – Intellisoft OLE DB Provider for PostgreSQL


We are trying to ENABLE:

NESTED QUERIES

and

Supports 'LIKE' operator


is not allowing, is there any help please

Thanks

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

More
3 years 7 months ago #14459 by admin
Are the properties disabled in the Linked Servers->PGNP->Properties?

Properties work with the latest Server Edition release. Could you let us know the SQL Server version used, and the PGNP version?
Attachments:

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

More
3 years 7 months ago #14460 by pdset
Thanks for reply.

We want to setup for PostgreSQL accessed through Link Server option through SSIS on SQL Server 2016 version.

We have used " PGNP-Postgres-SE-Trial-1.4.0.3516-x64.msi", which needs to do the following:

Also We have used the TRIAL software which is NOT allowing - NESTED QUERIES and SUPPORTS "LIKE" OPERATOR along with other options on Provider Options Page.

Your "Documentation Support" not mentioning for support for SQL SERVER 2016 Version and its associated SSIS of 2016 version?

Also, it is not returning more than 100 Rows?

Is it the only Software which connects with LINKED SERVER between PostGreSQL to SQL Server?

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

Time to create page: 0.130 seconds
Powered by Kunena Forum