integrate Oracle 12c and Progress11 using ODBC - Forum - OpenEdge Development - Progress Community

integrate Oracle 12c and Progress11 using ODBC

 Forum

integrate Oracle 12c and Progress11 using ODBC

This question is answered

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

Verified Answer
  • 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
  • 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+