Re: Can sqlplus access an ODBC datasource

From: Art Clarke <fool_at_ofb.net>
Date: 1997/08/11
Message-ID: <5snc4h$83q_at_gap.cco.caltech.edu>#1/1


Yes, it can. You need to install the Oracle Open Client Adapter than is shipped with Developer/2000. Once installed, you can access ANY ODBC data source by using "odbc:data_source_name" as your SQL Plus connect string.

E.G. sqlplus user/password_at_odbc:data_source

Note, the Oracle Open Client Adapter only works on Windows 3.1, Windows 95 and Windows NT.

  • Art Clarke

Manu Kodiyan (mkod_at_best.com) wrote:
> Can sqlplus scripts be used to access odbc data sources? If so how does
> one go about setting SQL*Net and ODBC up?
 

> Any help will be highly appreciated.
 

> Manu Kodiyan
[Quoted] > mkod_at_best.com

--
Received on Mon Aug 11 1997 - 00:00:00 CEST

Original text of this message