MSSQL linked server
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
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.
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!
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.
6 months 5 days ago #14664
by admin
Replied by admin on topic MSSQL linked server
Attachments:
Please Log in or Create an account to join the conversation.
Time to create page: 0.095 seconds
- You are here:
-
Home
-
Forum
-
Main PGNP Forum
-
SQL Server/DTS/SSIS/Linked servers/Replication
- MSSQL linked server