1. Forum
  3. Main PGNP Forum
  5. SQL Server/DTS/SSIS/Linked servers/Replication
  7. MSSQL linked server

MSSQL linked server

More
6 months 1 week ago #14662 by Volodymyr
MSSQL linked server was created by Volodymyr
Hi, all
When I try to get data via linked server I have an error:

"OLE DB provider 'PGNP' for linked server 'POSTGRES' returned data that does not match expected data length for column '[postgres].[northwind].[public].[orders].customer_id'. The (maximum) expected data length is 8000, while the returned data length is 10."

customer_id field has "bpchar" data type

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

More
6 months 1 week ago #14663 by admin
Replied by admin on topic MSSQL linked server
Hi! What PGNP build are you using? I recollect that this (or similar) issue was fixed a while ago. Could you try with current official release?

Also, is Linked Server configure with "Allow inprocess"?

If latest PGNP release still reproduces the issue, please send table DDL, linked server configuration script, and other details to our Support.

Thx!

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

More
6 months 5 days ago #14664 by admin
Replied by admin on topic MSSQL linked server
Thank you for sending additional info to Support! We have fixed the bug in build 3655
 
Attachments:

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. MSSQL linked server
Time to create page: 0.095 seconds
Powered by Kunena Forum