Rdb on OpenVMS, IBM zSeries and Oracle on OpenVMS (MOSC)

MOSC Banner

RDBPROD: Oracle RDB ODBC Driver (any version) and Oracle 12c Database

edited Dec 29, 2014 11:13AM in Rdb on OpenVMS, IBM zSeries and Oracle on OpenVMS (MOSC) 2 commentsAnswered

Hi,

Has anyone got the RDB ODBC driver working between RDB and Oracle 12c?

I've tested creating DB links (DG4ODBC) from Oracle 12c to Oracle Rdb V7.1-431 with many of the 64-bit version of drivers including the latest (3.3.2.4), but can only describe objects, any SELECT or DML statements fail. Example below:

SQL> desc test@dev_xxx_db;

Name                            Null?    Type

------------------------------- -------- ---------

STALL_NUM                       NUMBER(5)

STRTGY_NAME                     CHAR(32)



And when I try a count(1):

SQL> select count(1) from test@dev_xxx_db;

select count(1) from test@dev_xxx_db

*

ERROR at line 1:

ORA-28500: connection from ORACLE to a non-Oracle system returned this message:

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center