I'm trying to connect from SQL SERVER 2016 to a ASE 15.7 on a remote server.
For that I'm using a linked server which connects through an ODBC.
When I try to run a query i get this error:
OLE DB provider "MSDASQL" for linked server "ASE_PROD" returned message "[SAP][ASE ODBC Driver]Could not load code page for requested charset".
The ASE's charset is cp1255, and the SQL SERVER's collation is Hebrew_CI_AS.
I configured the ODBC's language configuration like so:
And the linked server's language configueation is:
Thanks for all the help,