A freeware SQL client for Sybase Adaptive Server Enterprise and SQL Anywhere databases
About ASE Client
I developed the first version of ASE Client 2004 at the administration course for Adaptive Server Enterprise at Sybase sweden. Since I was fluent in SQL Anywhere I finished the exercises very fast, and PowerJ was installed at the lab computers. So I just for fun started to develop a client that let you browse around objects in an ASE database. Back at work we used Sybase ASE for a CRM system, and I needed to poke around the tables and procedures to figure out how everything worked. Those times ISQL crashed often and SQL Advantage was very slow retrieving lots of data. I started to use ASE Client as companion to the Sybase tools. I also expanded it to work with SQL Anywhere databases.
Many years has passed by since. Sybase tools and others are immensely much better now. I thought I would ditch ASE Client. It no longer has any edge. It's archaic software, still developed with PowerJ in java 1.2. But I like to use it. It's extremely lightweight and still fast. So I will manitain it and even add features for the Sybase databases I currently use. Sadly I no longer have an ASE so ASE Client currently is tested with SQL Anywhere 12 and 16.
ASE Client shows you sysobjects, and if they are procedures, tables or views it displays the parameter or column info or the data if you de-select "Show cols". DDL can be displayed. You can also write and execute sql, but ASE Client is mostly meant as a companion to a normal SQL client. WHen I work I use Sybase Central, ISQL and ASE Client in parallel. You can load and save SQL queries and history. Search results can be saved as tab-separated spreadsheet compatible files.
ASE Client will discover if it's connected with an ASE or ASA and adapt itself. These databases are pretty different though they are a bit compatible. Important note: When you create an ASA database you need to create the sysobjects and systables views. This is default so if don't uncheck the checkboxes things will be fine. ASE Client won't work without them. And you HAVE to be an administrator. ASE Client is a pure java application. It should run on any platform supporting JDK 1.5 or later. Always use the latest java. Since ASE Client is using awt components (java utilizing the operating systems ui components) it might not look very slick, but it will work pretty fast.
ASE Client is freeware, but not open source since it relies on PowerJ libraries. Read license.txt, ReadMe_jconn3.jar.txt and ReadMe.txt in the zip-archive before using it. For windows users, there's a bat-file starting it. Users on other platforms will easily convert it to a script suitable for them.
2014-11-25 Version 2.94b: The message window was automatically cleared now and then. I decided this is very annoying and removed it. I added a button to manually clear the message window. Previously that function was anly in the edit menu and key combination ctrl-m. To download.
2014-11-24 The archaic client rise again with version 2.94: I have now fixed the problems with SAP-Sybase SQL Anywhere 16. It also works better with version 12.
However I no longer run an Adaptive Server Enterprise, so I have no clue if ASEClient works with ASE.
I recommend Notepad++ as a quick way to open the sql files. However if .sql is associated with a huge development environment, there is a new setting that makes DDL open in the .txt associated editor.
Behind the scenes ASEClient use the sp_helptext and sa_get_table_definition procedures. What comes out of those is what you get. No frills added. ASE Client is still coded in java 1.2 in Sybase PowerJ 3.6.1. I don't have the time to move it to a modern environment. ASEClient is only tested in windows with the latest jre available at the time of writing. To download.
2014-08-26 Trouble: I have now finally installed SAP-Sybase SQL Anywhere 16. (If you wonder where version 13, 14 and 15 of this database went, those numbers are unlucky in important markets lol.) Unfortunately, clicking on a certain sysobject type (TEXT) makes ASE Client crash. Embarrassingly the exception isn't caught anywhere so the program hangs unceremoniously. I also need to investigate how some new datatypes display in the grid. I still intend to keep ASE Client operational just for fun, so I will fix these issues. However, at the moment I am extremely busy, so I can't promise when it will be fixed. If you upgrade a version 12 database to 16 ASE Client will probably still work.
I have to say SQL Anywhere 16 is spectacularly good. Nothing revolutionary, but the worlds best, feature rich and easy to use relational database just got even better. In my opinion, 80% of the cases you need a relational database SQL Anywhere is the best and most cost effective solution.
2013-09-05 Resurrection announcement: ASE Client had it's golden age in the late middle of the last decade when it actually beat other tools in some aspects and thus was a very usable complement. Since then Sybase own tools have improved immensely. This summer I decided to end the development of ASE Client. I hadn't done anything for years and it had stopped working with java 1.7 due to some clever threading that obviously was not particularly clever in the long run. (Note to self: If Herbert Schildt writes "Don't do it" - then don't do it ;-) Having to port the whole project to a modern IDE felt tedious since ASE Client is heavily built on the PowerJ libraries. But I got PowerJ 3.6 to work pretty good under 64 bit Windows 8. It's quite troublesome moving the graphic components but otherwise it crashes much less often than under Windows XP. And I wanted to keep using ASE Client myself. For nostalgic reasons admittedly, but it's nice I can add functionality if I need on a whim. So: I have decided ASE Client will live on. I won't have much time to improve it, but features will be added occasionally.
So here is the first new version in 3 years:Last version 2.92 upploaded 2013-09-09. To download.
Version 2.92 uploaded 2013-09-09:New functions and some rework for ASA.
To do: Same as previous version. Also triggers that have no name are not displayed well.
Version 2.91 uploaded 2013-09-05:Resurrection version with some handy new functions.
To do: Open the entire resultset in external spreadsheet without having to save it first. A better message window if I can think something up.
Version 2.86 uploaded 2010-09-13:Long needed update.
The really annoying bug that you have to restart ASE Client after disconnecting a Anywhere db will be fixed shortly.
What do you want to see in ASE Client? I don't have much time, but good ideas will be implemented! My email is on the contact page.
Version 2.83 uploaded 2009-01-27:Very minor changes.
Note: If you want column names with datatype (alas not exactly specified), click in the drop down list in the SQL box. Then select "Copy text from selected component" or press control-g. This will deliver all rows in the drop down choice to the clipboard. Neat, eh?
Lol.. when looking at the settings menu I realize I still haven't adapted ASE Client for Microsoft SQL server. It might happen some day.. if I get any spare time. Let's see.. maybe for SQL Server 2014 ;-)
Version 2.81 uploaded 2008-12-19:A few minor new things.
I haven't had time to run much Anywhere 11 from ASEClient yet, but there probably are adjustments that needs to be made. I'll migrate things to 11 soon, and will find out.
Send an email and tell me what functions you want in ASE Client!
Version 2.80 uploaded 2007-10-08:Bug correction for Sybase SQL Anywhere.
Version 2.79 uploaded 2007-08-31:Now also working with Sybase SQL Anywhere (popularly called "ASA"), and upgraded to use jConnect 6.05.
Version 2.71 uploaded 2007-04-01:Version for ASE 15.X. Lot's of improvements.
Version 2.67 uploaded 2006-11-08:Attempt for older ASE compatibility.
Version 2.65 uploaded 2006-10-30:Enter the abort button.
Version 2.55 uploaded 2006-04-18:Goodbye memory leak.
Version 2.54 uploaded 2006-04-18:No duplicates in history.
New version 2.53 uploaded 2006-03-23:Bug in history corrected.
New version 2.52 uploaded 2005-12-08:New functions, moved functions and bug corrections.
New version 2.51 uploaded 2005-12-06:New cool functionality.
New version 2.50 uploaded 2005-11-15:Bug corrections.
New version 2.47 uploaded 2005-11-03:New export function.
New version 2.46 uploaded 2005-11-02:The bug corrections from version 2.45c and a new copy function.
New version 2.45 uploaded 2005-10-25:Some additions
New version 2.44 uploaded 2005-10-24:Vastly improved version
New version 2.41 uploaded 2004-11-30: Now the "row limit" parameter works! Another change is that filenames are remembered when you save sql and history files. Scroll down to download the new version!
Beware of displaying columns containing blobs like the data type "image" ASE Client will gladly try to load blobs in the result grid, and since blobs generally contain a lot of data this may require considerable time.
Stored procedures now works, but the output is often in several resultsets. You have to click the yellow button "More resultsets" to step through each result set. Alas, there's no way to step back yet. Other tools like Jsql or SQL Advantage are better suited for stored procedures.
Download ASE ClientDownload latest version of ASE Client (around 1 MB .zip archive)
More information and other tools
Sybase, Adaptive Server Enterprise, SQL Anywhere and some other products mentioned above are registered trademarks for Sybase a SAP company
Make sure you surf this site from the index page!