Re: How to reach CENTURA from SQL*PLUS (or other ORACLE tool)

From: DriftWood <drift_wood_at_my-deja.com>
Date: Tue, 05 Dec 2000 18:36:10 GMT
Message-ID: <90jciq$gg4$1@nnrp1.deja.com>

If you install the Open Client Adapter (OCA -- from Oracle) you can then create an ODBC connection to the foriegn datbase and connect from SQL*Plus (or any other Oracle tool) using the following style of alias:

ODBC:dsn-name

where dsn-name is the name of the ODBC DSN for the connection to the other datasource. How well this will work really depends on how well the ODBC driver for the other database performs and what the other RDBMS is capable of.

OCA is normally installable from the Developer/Forms/Reports CDROMS.

--
-cheers

  DW

---

"It is a kind of good deed to say well; and yet words are not deeds.   -William Shakespeare"

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Dec 05 2000 - 12:36:10 CST