python (65.1k questions)

javascript (44.2k questions)

reactjs (22.7k questions)

java (20.8k questions)

c# (17.4k questions)

html (16.3k questions)

r (13.7k questions)

android (12.9k questions)

Questions - heterogeneous-services

How can I force an Oracle Heterogeneous query to send the where clause to the ODBC driver?

I am using Oracle 21c XE for testing. I have installed a Progress Openedge ODBC driver, and created everything including a DB link needed for Heterogeneous Services. When I execute a simple "sele...
test-img

Paul Stearns

oracle

odbc

openedge

heterogeneous-services

oracle21c

Votes: 0

Answers: 1

Latest Answer

The driver is going to try "its best" to send predicates through, but if there is an incompatibility, which is typically due to some sort of data type mismatch then we will omit the predicat...
test-img

Connor McDonald

What are the best practices for troubleshooting Heterogeneous ODBC connections?

I am trying to establish a heterogeneous ODBC connection from an Oracle 21c XE database to a Progress OpenEdge 11.7 database. I have installed a 32 bit ODBC driver on the Windows 2019 server where the...
test-img

Paul Stearns

oracle

openedge

heterogeneous-services

oracle21c

Votes: 0

Answers: 1

Latest Answer

I had two problems. The TNSNAMES.ORA file needed to point to the Oracle DB server, running on localhost in my case. Once I changed this, the error changed to Error; ORA-28500: connection from ORACLE...
test-img

Paul Stearns

Posts

Questions

Blogs

Jobs