Solved

oracle 10g and ODBC

Posted on 2007-04-04
7
872 Views
Last Modified: 2013-12-21
Hi, I have installed Oracle 10g on solaris.
My questions are:

How do I check that ODBC is installed on the server. Does it come with the Db CD, or I need to install it separately?
If I have to install is sepeartely, then do I get that from oracle itself or I need to use third party?


Thanks
Deepak
0
Comment
Question by:dgupta70
7 Comments
 
LVL 143

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 84 total points
ID: 18854143
actually, you usually don't need ODBC driver on the server, but only on the client.
only if you have some application on the server itself requiring odbc. I doubt about that for solaris, though
0
 

Author Comment

by:dgupta70
ID: 18854376
Thanks got you, now I have oracle client installed on my local machine, and I can use SQL plus to connect to the databases.

Now where does ODBC fits into this scheme of things?

Please elaborate
Thanks
Deepak
0
 
LVL 7

Assisted Solution

by:gattu007
gattu007 earned 83 total points
ID: 18855248
Below notes from metalink may help u

Subject:  How to Setup and Verify Setup of Oracle ODBC Driver on Linux
  Doc ID:  Note:404041.1

How to Silently Install the Oracle ODBC Driver (SCR 1557)
  Doc ID:  Note:226748.1
0
 
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 18855750
>Now where does ODBC fits into this scheme of things?
ODBC is an "Open DataBase Connectivity".  Is actually being on the way to be replaced by OLEDB, which is newer, and allows more flexibility. but odbc is hard to die :-)

it is a way to have a standard interface to ANY database.
if you use SQL*Plus, you don't need (use) odbc, as sql plus directly communicates over the oracle net libraries.

0
 
LVL 4

Assisted Solution

by:vamsi_uk
vamsi_uk earned 83 total points
ID: 18856555
the developers in my company use a SQL tool called DBvisualizer to connect to the oracle 10g database. To connect to the database they use odbc driver. Basically its just like a driver needed to make oracle realize abt the client in simple terms. The driver type changes depending on the tool you use to connect to oracle. If you use Excel to get data from oracle, you need to use different driver. Like angelll said you done need any driver while using SQL plus though.
0

Featured Post

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Oracle - SQL Parse String 5 45
Not able to drop or recreate an Oracle stored procedure 1 38
Oracle Insert not working 10 32
oracle sqlplus query delimiter 8 19
Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question