integrate Oracle 12c and Progress11 using ODBC

Posted by saterp on 14-Sep-2018 02:47

Hi All,

I need to integrate the oracle 12c (using Oracle database gateway) and Progress using the Datadirect through ODBC.

Please share your experience, if you have done this before. 

Test: Installed Oracle and Progress in Windows 7 and trying to connect them but getting the below error.

ERROR at line 1:
ORA-00942: table or view does not exist
[DataDirect][ODBC Progress OpenEdge Wire Protocol
driver][OPENEDGE]Table/view/synonynm "SYSPROGRES.EMPLOYEE" cannot be found.
(15814) {42S02,NativeErr = -210083}
ORA-02063: preceding 2 lines from SPORTS_LINK

Production scenario:Oracle is in Windows 2012 and Progress is in Redhot linux.

Please share your experience.

Regards,

Sathish

Posted by Brian K. Maher on 14-Sep-2018 06:52

I believe its PUB.EMPLOYEE not SYSPROGRES.EMPLOYEE.
 
 
Brian Maher
Principal Engineer, Technical Support
Progress
Progress
14 Oak Park | Bedford, MA 01730 | USA
phone
+1 781 280 3075
 
 
Twitter
Facebook
LinkedIn
Google+
 
 

All Replies

Posted by Brian K. Maher on 14-Sep-2018 06:52

I believe its PUB.EMPLOYEE not SYSPROGRES.EMPLOYEE.
 
 
Brian Maher
Principal Engineer, Technical Support
Progress
Progress
14 Oak Park | Bedford, MA 01730 | USA
phone
+1 781 280 3075
 
 
Twitter
Facebook
LinkedIn
Google+
 
 

This thread is closed