This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
The moose likes JDBC and the fly likes oracle9i not being connect Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "oracle9i not being connect" Watch "oracle9i not being connect" New topic

oracle9i not being connect

Vinita singh

Joined: Aug 26, 2008
Posts: 1
my program is compiling,after running my program one prompt is opening prompt title is Microsoft odbc for oracle. its saying
The Oracle(tm) client and networking components were not found.These

components are supplied by Oracle Corporation and are part of the

Oracle version 7.3(or greater) client software installation

You will be unable to use this driver until these components have been


apart from this prompt in command prompt following error is written
Exception in thread "main" java.sql.SQLException: [Microsoft][ODBC Driver Manage
r] Driver's SQLAllocHandle on SQL_HANDLE_ENV failed
at sun.jdbc.odbc.JdbcOdbc.createSQLException(
at sun.jdbc.odbc.JdbcOdbc.standardError(
at sun.jdbc.odbc.JdbcOdbc.SQLDriverConnect(
at sun.jdbc.odbc.JdbcOdbcConnection.initialize(
at sun.jdbc.odbc.JdbcOdbcDriver.connect(
at java.sql.DriverManager.getConnection(
at java.sql.DriverManager.getConnection(
at CrDemo.main(
please help as soon as possible.
i have set my classpath variables still suggest your idea of setting classpath, i m using jdk1.6.0_06 , oracle 9i release 2
[ August 27, 2008: Message edited by: Vinita singh ]

Wayan Saryada
Ranch Hand

Joined: Feb 05, 2004
Posts: 104

Have you tried using the Oracle JDBC driver instead of connecting using jdbc odbc bridge driver?

Website: Learn Java by Examples
Scott Selikoff
Saloon Keeper

Joined: Oct 23, 2005
Posts: 3703

Originally posted by I Wayan Saryada:
Have you tried using the Oracle JDBC driver instead of connecting using jdbc odbc bridge driver?

That'd be my question to. Usually you only use ODBC+JDBC with Access since there's a more native library available from Oracle. Also, speaking from experience, Oracle 7.3 may not be compatible with later clients. I can recall one installation where I tried to use a 10.0 client to connect to an older Oracle server (might have been 7), and the client software refused with a very descriptive (but not that helpful) error message that I needed to upgrade my server to use their client.

My Blog: Down Home Country Coding with Scott Selikoff
Jiali Yang

Joined: Mar 20, 2006
Posts: 3

<a href="" target="_blank" rel="nofollow"></a>
I agree. Here's the link:
subject: oracle9i not being connect
Similar Threads
Connecting To Database
too many client tasks ?
Database connection
Connecting to DB Error
Data source name not found and no default driver specified