[Squirrel-sql-users] Oracle JDBC drivers

[Greg D. <gre...@ho...>]

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