Skip to Content
Author's profile photo Emanuel Affatati

How to configure Squirrel to use it with SAP ASE

Hi ASE community,

This time, I am going to write about how to configure the Squirrel database manager for using it with an SAP ASE database.

First of all, let’s see what is squirrel for the ones that doesn’t know.

Acccording to wikipedia,

The SQuirreL SQL Client is a database administration tool. It uses JDBC to allow users to explore and interact with databases via a JDBC driver. It provides an editor that offers code completion and syntax highlighting for standard SQL. It also provides a plugin architecture that allows plugin writers to modify much of the application’s behavior to provide database-specific functionality or features that are database-independent. As this desktop application is written entirely in Java with Swing UI components, it should run on any platform that has a JVM.[1]

SQuirreL SQL Client is free as open source software that is distributed under the GNU Lesser General Public License.

In a few words, Squirrel is a single, simple front end application that you can use to interact with a big variety of databases.

Now, let’s go to the configuration.

First, start Squirrel:


Now, once started, let’s select the drivers tab.

There, we have to navigate to the Sybase Adaptive Server Enterprise, and press the copy button.


We have to configure the proper parameters for this driver to work.



Once finished with the driver configuration, we have to move to the ALIAS tab.

There, you have to press the “+” button.


We have to configure the following parameters:


You should configure the following parameters:


Once done, you have to select the new Alias created and double click on it:


Finally, if everything is ok, you should see the following table with your database information:


Hopes this is useful.



Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Dan Man
      Dan Man

      Thank you for this helpful Post. My only problem was the Class Name: com.sybase.jdbc2.jdbc.SybDriver). After I have changed the Class Name to " com.sybase.jdbc4.jdbc.SybDriver". It worked like a charm !

      Author's profile photo nick humphrey
      nick humphrey

      i had to use jconnect16.jar (i got it by installing a trial version of aqua data studio 23.0, then copied it to my squirrel sql install dir) and the class name had to be com.sybase.jdbc42.jdbc.SybDriver (which i discovered by opening the jar file in 7-zip).

      thanks for the tutorial