Solved

oracle 10g and ODBC

Posted on 2007-04-04
7
868 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
How to clone solaris 10 machine 33 114
How to count the number of rows in multiple Oracle Tables 10 63
case statement in where clause 5 42
sql query 9 38
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…
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
This video shows how to recover a database from a user managed backup
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

895 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

15 Experts available now in Live!

Get 1:1 Help Now