If the SQL database type that you want to use (i.e. MySQL, PostgreSQL, IBM DB2, etc.) has a red X next to it, you'll need to get the appropriate driver from the database vendor. Download the driver to your local machine and use the Drivers window within SQuirreL SQL to point to that file. Download SQuirreL SQL Client for Mac 3.9.0 for Mac. Fast downloads of the latest free software!

Attachments:Jim, Stefan I've managed to add the driver, so far so good, many thanks topointing out the additional resources.Now I'm getting general security error when testing a connection, I'll talkto admin first.Thanks again.2012/7/31 Jim It Hi Bart, Welcome to SquirrelSql. Attachments:SQuirreL SQL comes without any JDBC-Driver. Attachments:Hi Bart,Welcome to SquirrelSql. Attachments:Jim, Stefan I've managed to add the driver, so far so good, many thanks topointing out the additional resources.Now I'm getting general security error when testing a connection, I'll talkto admin first.Thanks again.2012/7/31 Jim It Hi Bart, Welcome to SquirrelSql.

Part I, setting up Squirrel SQL

Introduction

I've been doing contract work for several years. Differentclients use different relational database systems (RDBMS). Some clientsuse Oracle, others use Sybase, while others use SQL server or DB2. Ihave also used MySQL and Postgresql for some personal projects. MostRDBMSs include an SQL client that makes it easy to work with them,however each of these SQL clients has their own idiosynchrasies. Whenyou switch RDBMS systems as often as I do, it is hard to get used tousing a different SQL client for each project.

Squirrel SQL is a very powerful universal database client. It iswritten in Java therefore it requires a Java Runtime Environment (JRE)or Java Development Kit (JDK). As long as the RDBMS system you are usinghas a JDBC driver, Squirrel SQL can connect to it. In this day an age,virtually all RDBMS systems have a JDBC driver, therefore Squirrel SQLcan connect to virtually all RDBMS systems.

Microsoft office 2007. In this article we will illustrate how to set up and work withSquirrel SQL.

Downloading and Installing Squirrel SQL

Squirrel SQL can be downloaded from their downloadpage. The downloaded file should be named something like squirrel-sql-2.2final-install.jar (the exact filename depends on the version downloaded).

To install Squirrel SQL, change from a command line and type'java -jar squirrel-sql-2.2final-install.jar' (again, exact file namedepends on the version). This will launch a user friendly graphicalinstaller. Just follow the prompts to get Squirrel SQL installed.

Running Squirrel SQL

To run Squirrel SQL, change directories to the directory whereSquirrel SQL was installed and execute squirrel-sql.bat for Windowssystems, or squirrel-sql.sh for Linux, Mac OS X or other unix-likesystems.

Squirrel SQL should look something like this when it is executedfor the first time.

The 'Drivers' window shows all JDBC drivers Squirrel SQL comespreconfigured to use. As can be seen in the screenshot, most of thedrivers have a red 'X' next to them. This means that there is a problemwith the driver. Boeing 747 flight manual. Since Squirrel SQL does not include JDBC drivers formost RDBMS, the reason we see a red 'X' next to almost every driver isbecause the JDBC driver for these RDBMS systems is not in Squirrel SQLsCLASSPATH. In the next section we will explain how to add a JDBC driverto Squirrel SQL's classpath.

The 'Aliases' window contains connection information for one ormore databases. Since the screenshot is displaying Squirrel SQL after afresh install, there are no aliases defined. Again, adding an alias willbe discussed in the next section.