Symptom
Running a command with a subquery that involves an ASE proxy to the ECDA for MSSQL server containing numeric data, parameterizes the numeric value and error is thrown:
Msg 30291, Level 19, State 0:
Server 'mssqls', Line 3:
[[Message Iteration=1|Data Source Name=MSSQLS|SQLState=22018|Native Error=0|Message=[DataDirect][ODBC SQL Server Driver]Invalid character value for cast specification]
Command has been aborted.
Read more...
Environment
- ECDA 15.X
- SAP Adaptive Server Enterprise (ASE) 15.7
- MSSQL Server 2008/2008 R2
- Windows 2008 R2
- Solaris 10
Product
Sybase EnterpriseConnect Data Access 15.7
Keywords
DataDirect, ODBC SQL Server Driver , KBA , BC-SYB-ECD , Enterprise Connect (ECDA) , 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.