I'm adding the configuration for setting Squirrel SQL 3.3.0 to connect to Oracle DB 11gr2. I'm using thin connectivity (No need for client installation in your machine).
Steps:
1- Open Driver list from left menu, scroll down till you find "Oracle Thin Driver", you will notice red x mark next to it denoting the driver is still not configured.
2- After selecting "Oracle Thin Driver" click "Modify the Selected Driver" denoted by pencil.
3- Click "Extra Class Path" tab.
4- Click "Add" and select 1 jar file from %Oracle_DB_CLIENT_INSTALL%\jdbc\lib\ojdbc6_g.jar
5- Click Ok, and we are done defining the driver.
6- Now create an alias for the DB using previous driver and providing URL, username, & password.
Note:
No need to have Oracle client for setup, all you need is just the driver jar files. You can download from this Oracle link.
If you are using JDK 5 while running Squirrel SQL, the jar file will be %Oracle_DB_CLIENT_INSTALL%\jdbc\lib\ojdbc5_g.jar
Steps:
1- Open Driver list from left menu, scroll down till you find "Oracle Thin Driver", you will notice red x mark next to it denoting the driver is still not configured.
2- After selecting "Oracle Thin Driver" click "Modify the Selected Driver" denoted by pencil.
3- Click "Extra Class Path" tab.
4- Click "Add" and select 1 jar file from %Oracle_DB_CLIENT_INSTALL%\jdbc\lib\ojdbc6_g.jar
5- Click Ok, and we are done defining the driver.
6- Now create an alias for the DB using previous driver and providing URL, username, & password.
Note:
No need to have Oracle client for setup, all you need is just the driver jar files. You can download from this Oracle link.
If you are using JDK 5 while running Squirrel SQL, the jar file will be %Oracle_DB_CLIENT_INSTALL%\jdbc\lib\ojdbc5_g.jar
Thanks
ReplyDeletePerfect!
ReplyDeleteThank you so much :) !!! Worked right away!
ReplyDeleteperfect!!! thanks
ReplyDeleteThanks buddy!!
ReplyDeleteThanks a lot Ashraf Ji
DeleteWhen I do this, I get this error ...
ReplyDeleteUnexpected Error occurred attempting to open an SQL connection.
class oracle.net.ns.NetException: Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor