Symptom
SAP IQ crashes when selecting from Oracle ODBC64 Proxy Table mapped to a View
If iAnywhere Oracle odbc driver (DBORAODBC16.DLL) is used, IQ does not crash, but create proxy table fails with error
Could not execute statement.
The remote table 'Ora_Srv_iA ..VIEW1' could not be found
SQLCODE=-666, ODBC 3 State="HY000"
The remote table 'Ora_Srv_iA ..VIEW1' could not be found
SQLCODE=-666, ODBC 3 State="HY000"
Read more...
Environment
- SAP IQ 16 SP11 PL01
- Oracle 11g or 12
- Oracle ODBC64: 11.02.00.01
- iAnywhere ODBC for Oracle: 16.00.00.2195 (DBORAODBC16.DLL)
- Microsoft Windows (2012, 2008)
Product
SAP IQ 16.0 ; SAP SQL Anywhere 16.0
Keywords
Sybase, CR 803033, CR#803033, 803033, proxy table, -666 , KBA , BC-SYB-IQ , Sybase IQ , 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.
SAP Knowledge Base Article - Preview