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.