Skip to Content

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:


/wp-content/uploads/2016/06/img01_984840.png


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.

/wp-content/uploads/2016/06/img02_984869.png

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


/wp-content/uploads/2016/06/img03_984870.png

/wp-content/uploads/2016/06/img09_984889.png


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

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

/wp-content/uploads/2016/06/img04_984871.png

We have to configure the following parameters:

/wp-content/uploads/2016/06/img05_984884.png


You should configure the following parameters:

/wp-content/uploads/2016/06/img06_984885.png

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


/wp-content/uploads/2016/06/img07_984886.png


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

/wp-content/uploads/2016/06/img08_984888.png

Hopes this is useful.

Regards,

Emanuel

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply