Re: SQLPLUS driver

On Sep 11, 5:17 am, sybra...@xxxxxxxxx wrote:
On Thu, 11 Sep 2008 11:05:15 +0200, "Wilfrid" <grill...@xxxxxxxxx>
wrote:

Hello,

I am trying to find articles/resources about what kind of database driver
sqlplus is using to connect to an oracle server.
From my initial search, I have a feeling it is odbc but i can't find any
real complete information about this.

Thanks in advance

Sql*plus is NOT using odbc. Also odbc is not a driver, odbc is just
glue translating/communicating with native drivers.
To connect to a database using sqlplus you need a full client (all
versions) or an instant client (10g and higher).
Eventually sqlplus uses OCI (Oracle Call Interface), but oci.dll won't
work standalone.
In the past, at a a minimum, you need to install the Required Support
Files and Sqlnet.

--
Sybrand Bakker
Senior Oracle DBA

SQLPlus connects to a local or remote Oracle database using Oranet
better known as sqlnet which was mentioned in the last line of
Sybrand's response.

If you are on a PC or other remote server from the database then you
have to install client software and in the case of SQLPlus it is what
Sybrand called the thick cleint, which is the normal traditional full
Oracle sqlnet cleint. Oracle pro* language support and tools (exp,
imp, and sqlldr) may or may not be installed based on the desired
level of features desired.

Beside the thick client there is a thin client used by java.

HTH -- Mark D Powell --
.

Relevant Pages

  • Re: HELP
    ... Not familiar with specs for Oracle Client, ... ODBC driver). ... >> Connection and Recordset Objects) in order to use ODBC ...
    (microsoft.public.excel.programming)
  • Re: Whats so bad about ODBC
    ... It is far better to connect to Oracle using the native connectivity. ... What exactly might be a problem with ODBC? ... data to be fetched to the client, and have it filtered on the client. ... actual execution paths are often unpredictable, ...
    (comp.databases.oracle.server)
  • Re: How do I access Oracle 8 data via ODBC
    ... 2003 via ODBC. ... I have installed the Oracle version 9 client. ... Client, per se, but in the ODBC Driver associated with it. ... Up-and-running support may be found through OpenLink's online Support ...
    (microsoft.public.word.docmanagement)
  • Re: sql from within c program
    ... > Is there a way to embed sqlplus statements within a c program. ... I'm assuming we're talking about Oracle given the sqlplus reference. ... ODBC is the vendor neutral API. ... Oracle provides these client side ...
    (comp.unix.programmer)
  • Re: ODBC Problems
    ... installation the application found only the Ms ODBC dricver for ORacle. ... because I have Oracle Instant CLient installed. ...
    (comp.databases.oracle.tools)
Loading