Toad World® Forums

Heterogenous Query Failure


#1

Trying to run/create hetero queries using the native Oracle 10.2 Driver

[Microsoft][ODBC Microsoft Access Driver] ODBC–connection to '{Microsoft ODBC
for

Oracle}(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=enterprise)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=DWTST.WORLD)))’
failed.

I tried different databases, 9i 10g, and even tried them individually, but they
all give me the same error. Do you have to configure MS Oracle ODBC connections
again like it used to be in release 1?