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(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 ]
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.