Re: [Squirrel-sql-users] Connecting to oracle DB using Squirrel 3.3.0

[Drav S. <hol...@re...>]

hechesspee wrote:
> I want to connect to Oracle DB using Squirrel. I'm using oracle 9i as the
> client.
> Can someone guide me or send me a link to any post where it is explained?

Download the JDBC client (if you haven't already got it installed), I use
ojdbc6.jar personally (connects to 10g and 11g just fine). And install it.

http://www.oracle.com/technetwork/database/enterprise-edition/jdbc-112010-090769.html

Click on drivers, scroll down and double click Oracle Thin Driver. Click 
Extra Class Path, and click Add. Navigate to the ojdbc file you just
installed.

oracle.jdbc.OracleDriver should appear in the class name. Click Ok.

The log window should say:

Driver class oracle.jdbc.OracleDriver successfully registered for driver definition: Oracle Thin Driver


Add a new Alias, Set the Driver to the Oracle Thin driver and
fill in the details.

Regards

D.