Tag Archive: Microsoft


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

While the CakePHP framework is very good, the dbo “driver” (wrapper) between CakePHP and the PHP Sybase/Microsoft drivers ar not implemented to be actually usable.  Most of the issues are differences of SQL dialect between MySQL and the commercial DBMSs.

The issues tend to be simple ones such as, “select * from my_table limit 10″ to retrieve the first 10 rows not working.  Using “select top 10 col1,col2,….coln from my_table” will.

So how can you help?  Very easily! :)   The CakePHP website shows us how:

Contributing to Cake

We are always looking for contributions, so don’t be shy. There are two ways to get involved:

1. Documentation:

The Cookbook is ready to accept your input. Everyone can help with the documentation effort by simply logging in with your Bakery account, writing (or editing) a section and submitting it for review. The application is still under development, so if you find a problem, submit a ticket following the recommended procedure. Visit #cakephp-docs on irc.freenode.net.

2. Bugs, Enhancements and Optimizations:

Contributing code to CakePHP is easy: Submit test cases and attach them to tickets. That’s it. Fame, glory, and praise to all those who make the effort.

Thanks to all those who have already contributed to CakePHP. We look forward to everyone’s future contributions.

Take a look at the source code for the drivers.

Back on November 5th, I reported that in my blog post Woohoo! Looks like Evolution will be able to connect to Microsoft Exchange again! that the Exchange plugin for Evolution was fixed.  Well, they fixed one part but many of us still aren’t able to use the plugin. :(

Bug 306975:  Evolution: Exchange-Connector-setup 2.24.2 unable to log in to exchange

If you are running into this problem, please let it be known on the bug page!

Pedro Villavicencio over at Ubuntu says:

upstream said the bug is fixed with evolution 2.24, could you please
comment on http://bugzilla.gnome.org/show_bug.cgi?id=375727 if you still get the issue or confirm that it’s fixed? thanks in advance.

** Changed in: evolution-exchange (Ubuntu)
Status: Triaged => Incomplete


evolution-exchange: unable to setup exchange account: e2k_properties_get_prop: assertion `props != NULL’ failed https://bugs.launchpad.net/bugs/25106

Don’t know what VMware VMotion is? VMotion allows you to easily move one virtual machine to another VMware ESX host that is connected to the same storage mechanism (presumably SAN) with no downtime. Looks promising :)

Image courtesy of VMware

Image courtesy of VMware

Dell has a demonstration using Microsoft SQL Server where they move the live SQL Server from one blade to another with no outage: