Solved

Need drivers for Oracle thin driver and oracle oci driver for Squirrel SQL client

Posted on 2010-09-02
6
2,110 Views
Last Modified: 2013-12-19
Can some one tell me how to acquire and install oracle drivers for Squirrel SQL client...

0
Comment
Question by:damodar4u
  • 3
  • 3
6 Comments
 
LVL 35

Expert Comment

by:johnsone
ID: 33587461
I would think that you can get what you need by putting Instant Client on the system.  You should be able to get that here:

http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html
0
 

Author Comment

by:damodar4u
ID: 33590241
i need how general SQL client where Squirrel SQL client provides
 
0
 
LVL 35

Expert Comment

by:johnsone
ID: 33590514
As far as I know, Squirrel needs JDBC drivers.  These would be included for with the instant client.  The install of instant client is just unzipping the download.
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:damodar4u
ID: 33616956
johnsone
Yeah i tried that but still i see red icons on the drivers after unzipping the squirrel client
0
 
LVL 35

Accepted Solution

by:
johnsone earned 500 total points
ID: 33618396
In addition to unzipping the files, you need to set up and tnsnames.ora file and also set the TNS_ADMIN environment variable.  As I recall, that was in the documentation somewhere.  You also probably have to include the directory in the CLASS_PATH.
0
 

Author Comment

by:damodar4u
ID: 33618936
Let me Try johnsone ...If i fond difficulty i will leave a message
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.

680 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question