SAP Knowledge Base Article - Preview

2618652 - Sybase IQ to ASE proxy tables failing

Symptom

  • Customer is getting below error when trying to connect from production IQ server to ASE server. This was working until weekend.

    SQL Anywhere Error -656: Unable to connect to server: [ASE ODBC Driver]Error encountered while setting up security context.

  • Connection details in IQ for ASE are:

 select * from sys.sysserver 

srvid      srvname    srvclass                                                                                                                                                                                                                                                                                                                                                                                                srvinfo                                                                                                                                                                                                                                                                                                                                                                                                                 srvreadonly  ---------- --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------          -----------          

1 DDI_LIVE         aseodbc                                                                                                                                                                                                                                                                                                                                                                                                                 Driver=libsybdrvodb.so;Server=eqdbfdc1p;Port=5500;Database=ddi;PacketSize=2560;EnableServerPacketSize=0;EncryptPassword=1;CharSet=cp850                                                                                                                                                                                                                                                                                 N    

  • Now any remote calls from IQ to ASE fail with the above error.

  • Customer did patch the Sybase ASE from sp138 to sp139 and it has been failing since that time.


Read more...

Environment

  • SAP ASE Adaptive Server Enterprise 15.7
  • SAP IQ 16.0

Product

Sybase Adaptive Server Enterprise 15.0

Keywords

Error -656,security context,-656,656, , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.