1. Forum
  3. Main PGNP Forum
  5. SQL Server/DTS/SSIS/Linked servers/Replication
  7. pg linked server call function with parameter

pg linked server call function with parameter

More
1 year 8 months ago #14558 by amsoliman
pg linked server call function with parameter was created by amsoliman
error when run
SELECT * FROM OPENQUERY(PG, 'SELECT * FROM torod.fintech.clientsearch( ''111'')')

OLE DB provider "PGNP" for linked server "PG" returned message "** ERROR: Failed to parse statement: SELECT * FROM torod.fintech.clientsearch( '111')".

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

More
1 year 8 months ago #14559 by admin
Replied by admin on topic pg linked server call function with parameter
Hello! Thank you for letting us know! It is a bug in handling 3-part function reference. Please email request to our Support in order to obtain build with the fix (1.4.0.3600+).

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

  1. Forum
  3. Main PGNP Forum
  5. SQL Server/DTS/SSIS/Linked servers/Replication
  7. pg linked server call function with parameter
Time to create page: 0.052 seconds
Powered by Kunena Forum