Re: Access an MS SQL Database with SQL Plus

From: DriftWood <drift_wood_at_my-deja.com>
Date: 2000/03/07
Message-ID: <8a3j8f$2i2$1@nnrp1.deja.com>#1/1

You need to have a product called the Open CLient Adapter (or OCA) installed and a valid ODBC DSN for the foreign database configured. Then you use the following style connect string in SQL*Plus:

       ODBC:myDsn

OCA used to install with the FOrms/Developer series of products, I am unsure what it may be bundled with anymore -- it must be bundled with Oracle Lite since that is an ODBC RDBMS and SQL*Plus can get to it when installed together...

--
-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 Mar 07 2000 - 00:00:00 CST