|
From: Colin B. <Col...@as...> - 2002-09-11 23:16:00
|
Hi Greg, You need to put the jar file containing the Oracle JDBC drivers either into your classpath (the environment variable %CLASSPATH%) or specify them in the "Extra Class path" tab in driver maintenance. The Help file (accessed through the Help option on the Help menu) goes into more detail. For Oracle 8 the JDBC jar file is classes12.zip but I don't know what its called for Oracle9. Col -----Original Message----- From: Greg Dorval [mailto:gre...@ho...] Sent: Thursday, 12 September 2002 6:27 To: squ...@li... Subject: [Squirrel-sql-users] Oracle JDBC drivers I'm very new to Squirrel, and am trying to connect to an oracle database, yet there is a red X icon next to both the Oracle OCI Driver and Oracle Thin Driver in the drivers list, which I presume means that the driver is not available/installed. However, I have both Oracle 8.1.7 and Oracle 9.0.2 clients installed on my machine including the following jdbc drivers: Oracle8i: Oracle JDBC/OCI Driver for JDK 1.1.8.1.6.0.0 Oracle JDBC/OCI Driver for JDK 1.2.8.1.6.0.0 Oracle JDBC Thin Driver for JDK 1.1.8.1.6.0.0 Oracle JDBC Thin Driver for JDK 1.2.8.1.6.0.0 Oracle9i: Oracle JDBC/OCI Driver for JDK 1.1.9.2.0.1.0 Oracle JDBC/OCI Driver for JDK 1.2.9.2.0.1.0 Oracle JDBC/OCI Driver for JDK 1.4.9.2.0.1.0 Oracle JDBC Thin Driver for JDK 1.1.9.2.0.1.0 Oracle JDBC Thin Driver for JDK 1.2.9.2.0.1.0 Oracle JDBC Thin Driver for JDK 1.4.9.2.0.1.0 I am running squirrel-sql-1.1beta6 Java version: Z:\>java -version java version "1.3.1_01" Java(TM) 2 Runtime Environment, Standard Edition (build 1.3.1_01) Java HotSpot(TM) Client VM (build 1.3.1_01, mixed mode) The following appears at the beginning of my PATH: C:\Program Files\Oracle\jre\1.3.1\bin; Also, the following are the error messages in the squirrel log related to the oracle jdbc drivers: 1134 [main] WARN net.sourceforge.squirrel_sql.client.db.DataCache - Could not find JDBC driver class for Oracle Thin Driver: oracle.jdbc.driver.OracleDriver 1134 [main] WARN net.sourceforge.squirrel_sql.client.db.DataCache - Could not find JDBC driver class for Oracle OCI Driver: oracle.jdbc.driver.OracleDriver So, if anyone could help me get connected oracle, I would be very grateful! Thanks. Cheers, Greg _________________________________________________________________ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx ------------------------------------------------------- In remembrance www.osdn.com/911/ _______________________________________________ Squirrel-sql-users mailing list Squ...@li... https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users |
