Linked server provider options configuration

More
4 months 2 weeks ago #14458 by pdset
pdset created the topic: Linked server provider options configuration
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
4 months 2 weeks ago #14459 by admin
admin replied the topic: Linked server provider options configuration
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
4 months 2 weeks ago #14460 by pdset
pdset replied the topic: Linked server provider options configuration
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.200 seconds
Powered by Kunena Forum