Skip to Content
0
Dec 09, 2018 at 02:57 PM

Connecting to ASE 15.7 from SQL SERVER 2016 using ODBC

1184 Views

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,

Ofer