How to Install SQuirrel SQL Client on windows

                                                  How to install Squirrel SQL Client

STEP 1. Hit the URL:- http://www.squirrelsql.org/#installation

 

Click on the link on the page

Install jars of SQuirreL 3.3.0 for Windows/Linux/others

After clicking the above link , you are able to download “squirrel-sql-3.3.0-install.jar”.

Save “squirrel-sql-3.3.0-install.jar” file in C Drive.

 

STEP 2:- Open Command line (CLI) [start->run->cmd and press ENTER]

C:\Documents and Settings\Kumar>cd ../..

C:\>

Now , type java -jar squirrel-sql-3.3.0-install.jar at CLI and press ENTER

It will open SQuirrel software installation package. Just click on next , next and install the software.

STEP 3:- Open Squirrel software and click on Drivers tab

 

STEP 4:- To enable Oracle Thin Driver , you have to download ojdbc14.jar and add this jar file in “Squirrel\lib” folder.

 

Download link: http://www.findjar.com/jar/mule/dependencies/maven1/oracle-jdbc/jars/ojdbc14.jar.html

 

Restart the Squirrel software, where you can able to see that Oracle Thin Driver is enabled.

 

 

STEP 5:-

Click on Aliases tab , click on +(add) button to add new database.

In ADD Alias , provide NAME for Database ,

Select Oracle Thin Driver  in Driver drop down box.

Provide the URL , Username and password.

URL should be like:-

jdbc:oracle:thin:@101.101.198.134:1621:PRODDB

 

 

Click on TEST button , if all details are correct then it should show below mentioned  message on screen.

About these ads

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

%d bloggers like this: