SQuirreL SQL is an open-source Java SQL Client program for any JDBC. DMOZ Java and. Download and Installation. The SQuirreL SQL Client is installed.
I downloaded SQuirreL SQL and I want to use it as an Oracle client, but when I go to Drivers tab, the following jars are missing:
- Oracle OCI Driver
Oracle Thin Driver
How can I fix this problem?
ROMANIA_engineerROMANIA_engineer2 Answers
Download ojdbc7.jar
- you need an Oracle account, but the e-mail is the only important detail that you need to provide (you can add any characters for Work Phone, Company Name, etc.)
Go to the SQuirreL SQL installation folder (E.g.: C:Program Filessquirrel-sql-3.7.1) >lib and put ojdbc7.jar there.
Restart SQuirreL SQL.
The file ojdbc7.jar has to be downloaded from the following page, as you must accept the license agreement: https://www.oracle.com/technetwork/database/features/jdbc/jdbc-drivers-12c-download-1958347.html
Note that you are not requested to log in nor to provide your email address.
Not the answer you're looking for? Browse other questions tagged ociojdbcsquirrel-sql or ask your own question.
How to configure SQuirreL for DB2 access.
In SQuirreL I do see two DB2 drivers. But they are both marked with an red X.
I checked with Start Page but did not find an easy solution :/
Squirrel Sql Tutorial
Thorsten NiehuesThorsten Niehues1 Answer
- Download the DB2 Driver from the IBM Website and extract the ZIP archive.
Optionally you may want to copy it from the DB2 Server installation path:/opt/ibm/db2/V11.1/java/db2jcc4.jar - Use
db2jcc4.jarand copy it into the squirrel folder e.g.plugins/db2 - In der Driver in the tab 'Extra Class Path' add the db2jcc4.jar file
- Change the class name to
com.ibm.db2.jcc.DB2Driver
How To Use Squirrel Sql
jpierson
Thorsten Niehues