SAP Knowledge Base Article - Preview

2088239 - When creating connection from Rep server to ECDA to access db2, error occurs: Incorrect syntax with the keyword 'on'.

Symptom

  • Create connection using profile such as:

create connection to ECDA_Service_Accessing_DB2 (in form of ECDA_Servicename.database)
using profile rs_ase_to_db2;standard
set username to "xxxxx"
set password to "xxxx"
set dsi_cmd_separator to ';'
set batch to "off"

  • Error occurs: Line 1, character 29: Incorrect syntax with the keyword 'on'.


Read more...

Environment

  • ECDA 15.7
  • Rep Server 15.7.1
  • DB2 database as backend to ECDA

Product

Sybase Enterprise Connect Data Access 15.0 ; Sybase Replication Server 15.5 ; Sybase Replication Server 15.6

Keywords

EnterpriseConnectDataAccess, EnterpriseConnect Data Access, Replication, Adaptive Server Enterprise , KBA , BC-SYB-ECD , Enterprise Connect (ECDA) , BC-SYB-REP , Sybase Replication Server (standalone) , Problem

About this page

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

Search for additional results

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