SAP Knowledge Base Article - Preview

2033667 - Error "Syntax error near 'Company=<string>' on line 1" if connection property "CONNECTION_AUTHENTICATION" is set using ODBC connection parameters "InitString" - SQL Anywhere

Symptom

  • The connection string is composed in the source code.
  • The connection is established using the "OdbcConnection" class.
  • The connection property "CONNECTION_AUTHENTICATION" is set using ODBC connection parameters "InitString".
  • With the verbose logging enabled, we can see
    • that the SET OPTION statement from the "InitString" parameters got truncated after the first semicolon (;) and
    • in result SQL Anywhere reported the error "Syntax error near 'Company=<string>'".
  • The execution of an MDL statements results in the error  -98 "Authentication violation".


' on line 1" if connection property "CONNECTION_AUTHENTICATION" is set using ODBC connection parameters "InitString" - SQL Anywhere"> Read more...

Environment

  • SAP SQL Anywhere 16
    SAP SQL Anywhere 12
    Sybase SQL Anywhere 11
    Sybase SQL Anywhere 10
  • SQL Anywhere OEM Edition

Product

SAP SQL Anywhere 16.0 ; SAP SQL Anywhere 17.0 ; SAP Sybase SQL Anywhere 12.0 ; SQL Anywhere 9.0 ; Sybase SQL Anywhere 10.0 ; Sybase SQL Anywhere 11.0

Keywords

KBA , BC-SYB-SQA , SQL Anywhere (on premise, on demand) , 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.