Orcale11g DG4ODBC-Connection to Oracle RDB Database
Hallo,
with Orcale 11g I want to select data from Oracle RDB Database with the Oracle DG4ODBC.
I have configured the following items:
0) ODBC SYSTEM DSN
1) listener
2) tnsnames
3) init<SID>.ora of the hs subsystem
4) environment
5) Oracle database
But, if I run the select statement, I have the following error:
ORA-28500: connection from ORACLE to a non-Oracle system returned this message: [Oracle][ODBC]RDB%SQL-F-SYNTAX_ERR, Syntax error
ORA-02063: preceding 2 lines from ...
With the older product (HSODBC) on Oracle 10g it works fine.
Are there differences between DG4ODBC and HSODBC?
Wo can I do for Oracle 11g that it runs fine?