Category: ASE


Get it here! Perl DBD::Sybase 1.09 for Active State Perl 5.10 on Windows XP/Vista/7 32bit

Filed Under: APIs, ASE, Databases, DBI, OS, Perl, Sybase, Windows by Jason L Froebe — 3 Comments
February 17, 2010

Assuming that you installed Sybase OpenClient 15.5 from the 15.5 PC Client:

Install ActiveState Perl from http://www.activestate.com (free) and install DBI if it isn’t already installed.  It should be but you never know…

  1. Start -> ActiveState Perl -> Perl Package Manager
  2. install DBI
  3. exit

Now, the easy part.  Install the DBD::Sybase 1.09 PPM:

  1. download DBD::Sybase 1.09 PPM
  2. extract zip file to temporary directory (e.g. c:\test)
  3. Start -> Run -> cmd.exe (as Administrator if Vista or Windows 7)
  4. cd \test
  5. ppm install DBD-Sybase.ppd
  6. exit

That’s it :)

Sybase

Tags: , , , , , , , , , , , ,
Comment

Andrew E. Bruno: Database Design with Dia

Filed Under: ASE, Databases, How To, IBM DB2, Microsoft, My Databases, MySQL, Oracle, PostgreSQL, SQL Server, SQLite, Sybase by Jason L Froebe — 3 Comments
November 5, 2009

Back in December Diaof 2007, Andrew E. Bruno wrote an excellent article on how to use the open source program Dia to design databases.  He used the resultant design to create a MySQL database but the same principles could be used to create just about any relational database from the design.  Dia is available for Linux, *nix, and Windows.

Database Design with Dia

In this post I’m going to give a quick how-to on creating database schemas with a wonderful tool called Dia. I’ve often found having a nice visual representation of a database to be quite helpful but can’t stand keeping it up to date. As soon as you add a new column or change the design around you end up having to sync your visual diagram with your SQL files. It’s tedious having to manage the various SQL for building the database and this can be a larger pain when trying to support different database platforms each with their own SQL syntax. So before you create your next database read on and see how Dia can make your life a bit easier.

Dia is a program for creating diagrams and for this exercise we’ll be creating UML diagrams from within Dia. We’re also going to use a perl script called tedia2sql which will transform our Dia files directly to SQL for our target database. What’s also nice about creating database schemas this way is that you can generate SQL for multiple target databases without the maintenance overhead.

read more….

Tags: , , , , , , ,
Comment

So you want to tweet to Twitter from *WITHIN* Oracle 11g? Here’s how!

Filed Under: APIs, ASE, Databases, Oracle, Sybase by Jason L Froebe — Leave a comment
April 12, 2009

Lewis Cunningham Twitterhas once again given us a gem from the world of Oracle’s relational DBMS!  This time, he has written ORA_Tweet, an API to send/receive Tweets (microblog posts) from within Oracle 11g.  Major kudos to Lewis Cunningham for writing and releasing ORA Tweet to Sourceforge.net :)

Call the Twitter API from within an Oracle database. ORA_Tweet uses the UTL_HTTP API within Oracle to call the update_status API. It is written completely in PL/SQL.

So, my question is…  Will someone write a Flickr API for Sybase ASE?

Tags: , , , , , , , ,
Comment

Sybase Workspace 2.1: Do NOT update Data Tools Platform (DTP) from Eclipse’s website!

Filed Under: ASE, OS, Sybase, Windows, Workspace by Jason L Froebe — 2 Comments
March 19, 2009

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.

Tags: , , , , , , , ,
Comment

Introducing QweryBuilder, a Developer GUI for Sybase ASE, SQL Anywhere, Microsoft SQL Server and Oracle 10g/11g

Filed Under: ASE, Databases, Microsoft, Oracle, OS, SQL Server, Sybase, Windows by Jason L Froebe — 1 Comment
March 10, 2009

qwerybuilder_reflectedimageQweryBuilder uses innovative ideas to provide developers with the ability to easily insert, extract and modify data from a variety of databases.

The goal of QweryBuilder is to increase a database developer’s productivity. It contains many time saving features.

SQL Editor

QweryBuilder - SQL Editor

QweryBuilder - SQL Editor

  • Script auto complete
  • Custom auto complete lists
  • Code Templates
  • Display column list for tables and views in editor
  • Display procedure parameters in editor
  • Keyboard shortcut to open procedures
  • Generate and insert new GUIDs
  • Syntax folding
  • Auto indenting

Criteria Query

QweryBuilder - Criteria Query

QweryBuilder - Criteria Query

  • Form view criteria screen for easy data retrieval
  • Updateable result set
    • Insert nulls, GUID’s, and computed values into results
    • Insert, delete and update data rows
    • Generate insert statements from results
    • Create graphs from result data

Graphic Query

QweryBuilder - Graphic Query

QweryBuilder - Graphic Query

  • Create queries graphically
  • Cross table querying without writing SQL

Other Features

  • Support for Microsoft SQL Server, Sybase ASE, SQL Anywhere and Oracle
  • DDL Browser
  • Database Search
  • Visual Difference
  • Code Formatter
  • Getting Started Window
    • Displays last used connections, files and database objects
    • Easily navigate to the last thing you were working on
  • Clipboard Saver
  • File Browser
  • Object Browser
Tags: , , , , , , , , , ,
Comment