Solved

oracle 10g and ODBC

Posted on 2007-04-04
7
876 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

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

Attention: This article will no longer be maintained. If you have any questions, please feel free to mail me. jgh@FreeBSD.org Please see http://www.freebsd.org/doc/en_US.ISO8859-1/articles/freebsd-update-server/ for the updated article. It is avail…
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 set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…

738 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