Category: Workspace


Sybase Workspace

Sybase

Sybase

is an Eclipse distribution that uses highly customized Data Tools Platform (DTP) plugins.  Updating the Sybase version of DTP with the standard DTP release from Eclipse will break Sybase’s Workspace.

Last night I updated Workspace’s DTP with the standard DTP release from Eclipse’s website.  Several oddities started showing up when accessing the DTP releases:

Configuring the db connection

Configuring the db connection

Testing the connection worked fine but when you open the database connection to a Sybase ASE database errors are reported:

Multiple errors have occurred

Multiple errors have occurred

and

Connection errors

Connection errors

If you run into this issue, you will need to uninstall Sybase’s Workspace (delete the %SYBASE%/Workspace directory after the uninstall is complete) to resolve it.

I’ve created feature request CR 565285 with Sybase:

Workspace’s DTP (data tools platform) should be updated with the DTP current release from Eclipse. This will allow developers that work in a mixed environment to use Workspace with non-Sybase DBMS’s (view stored procedures, triggers, etc).

If you believe that this feature request is desired, please let Sybase know.

Sybase

It’s coming…

48 hours from now something big is coming!

The ISUG Technical Journal Sep/Oct 2008 is out.

This issue contains:

  • Sybase IQ and Sybase WorkSpace Part II By Mike Crocker
  • Perl in the shell By Jason Froebe
  • Taming the process nightmare: Consolidating a Horde of Process Diagrams with PowerDesigner By Mike Nicewarner
  • Information overload: Weapons-grade data analysis comes of age By Teresa Foster
  • Maximizing PowerBuilder and SQLAnywhere Part III SQLAnywhere, a PowerBuilder Developer’s perspective
    By Chris Pollach
  • select random (stuff) from SYBASE Command shell by proxy By Bill Grant
  • Mobile Enterprise Everywhere: Taking Sybase on the road By Adrian Bridgwater
  • Sybase TechWave 2008: Time for the technology tsunami

You need to be an ISUG member to receive the ISUG Technical Journal.  Join ISUG today!

International Sybase User Group

International Sybase User Group

What I would love to see is native support for SQLite. http://www.sqlite.org

It is the most installed embedded database on the planet hands down.  Don’t believe me?  You know that Firefox web browser, Thunderbird newsreader, most Adobe products, Miro, etc all have it embedded?  – reference http://www.sqlite.org/mostdeployed.html

We use it extensively at work as:

  1. staging for mass data imports/exports/conversions
  2. local application ‘cache’ for large data sets
  3. projects that don’t require all the features of Sybase ASE (or Oracle for that matter)

One of the best features is that the database itself in platform independent… copy the db on to AIX from your Windows box … then on to your old Amiga … then on to your windows mobile device.  Getting the point?  :)

I really wish Sybase would make it so that the Sybase ASE databases were truly platform and character set/sort order independent… but that is in another dream ;-)

Not a blurb in the PowerDesigner/PowerBuilder manuals or anything

From the Sybase Workspace 2.0 team:

Thursday, February 14, 2008
1:00 pm EDT / 10:00 am PDT

Join us on Valentine’s Day and you will learn how to:

  • Visually debug stored procedures and triggers
  • Visually create and edit tables, stored procedures and events
  • Navigate and manipulate database objects in the enterprise
  • Export and import database objects and services to database server

Don’t forget to sign up for the webcast! :)   Sybase will send the dial in/web address to your email so you can participate.

I’m not sure if this is the same presentation as Sybase WorkSpace for ASE:  Learn to Love SQL Development Webinar that was hosted by Samir Nigam, Director of Engineering at Sybase, last month.