Hello,
I have succesfully connected a 1c Postgre SQL database with MSSQL 2012 via ODBC driver, yet when am executing a specific query, I get an error, not sure about the reasons why it shows up.
ODBC driver - Postgre SQL Unicode version 11.00.00.00 PSQLODBC35W.DLL 2018-11-17
1C platform version 8.3.5 1517.
PostgrePro 9.4, 1C version of course.
The query attempted:
sel ect * from openquery([TEST2], 'select * fr om baze_testine.public._Document260')
Results:
Msg 7347, Level 16, State 1, Line 1
OLE DB provider 'MSDASQL' for linked server 'TEST2' returned data that does not match expected data length for column '[MSDASQL]._number'. The (maximum) expected data length is 14, while the returned data length is 22.
The document number is actually 11 symbols long in the documents. Visibly there are no longer numbers. 22 seems like a doubled value. Same error message shows up when trying to query other documents.
Would welcome some advice-insight on how to approach this situation/to solve it. Thank you in advance.