• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

oracle9i not being connect

 
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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

installed.

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(JdbcOdbc.java:6957)
at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7114)
at sun.jdbc.odbc.JdbcOdbc.SQLDriverConnect(JdbcOdbc.java:3073)
at sun.jdbc.odbc.JdbcOdbcConnection.initialize(JdbcOdbcConnection.java:3
23)
at sun.jdbc.odbc.JdbcOdbcDriver.connect(JdbcOdbcDriver.java:174)
at java.sql.DriverManager.getConnection(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:185)
at CrDemo.main(CrDemo.java:9)
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 ]
 
Ranch Hand
Posts: 119
Hibernate Spring Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Have you tried using the Oracle JDBC driver instead of connecting using jdbc odbc bridge driver?
 
author
Posts: 4335
39
jQuery Eclipse IDE Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator

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.
 
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
oracle.jdbc.driver.OracleDriver
 
roses are red, violets are blue. Some poems rhyme and some are a tiny ad:
a bit of art, as a gift, the permaculture playing cards
https://gardener-gift.com
reply
    Bookmark Topic Watch Topic
  • New Topic