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.