Solved

oracle 10g and ODBC

Posted on 2007-04-04
7
871 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 142

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 142

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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Error executing command from server 6 49
Schema creation in Oracle12c 6 45
Problems using Provider=OraOLEDB.Oracle via VBScript/Classic ASP 5 65
Can't Access My Database 57 63
Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
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…

815 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

Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!

Get 1:1 Help Now