cubeSQL and schedule backups

August 10th, 2012 | No Comments »

I think it’s time to write something about how to correctly setup a schedule backup with cubeSQL.

Most people don’t realise that it is a two step operation and we often receive support requests because in their opinion schedule backups do not work. I think that official documentation is not clear about this point and we plan to improve it in the next upcoming 4.3 version, in the meantime I’ll try to clarify required steps in this post.

Step 1 is to setup a schedule using the Schedules panel:

as you can see we added a new Schedule1 of type Backup, triggered every Sunday and 1:00 AM (and the Schedule Enabled checkbox is checked).

Once schedule has been created you need to ATTACH this schedule to a database in order to be able to correctly backups it. Please note that more than one schedule can be attached to a database and the same schedule can be attached to multiple databases!

Step 2 is to attach newly created schedule in the Databases panel:

select the database you want to backup and then from the Server menu select “Manage Schedules”:

From the popup menu then select newly created schedule and then press the Attach button.

cubeSQL new ODBC driver

July 9th, 2012 | 5 Comments »

Thanks to Jonathan Monroe from Actual Technologies we have another cubeSQL ODBC driver build.

The following issues remain:

  • indexes and primary keys are not returned
  • column nullability not returned for column descriptions
  • tables with date fields can’t be used as “linked tables” in MS Access
  • MS Word mail merge not yet supported
  • all text fields are concatenated together in PHP

You can download the new build in the cubeSQL download section. Please let us know of any issues you’ll find with this release.

cubeSQL on ARM processors

June 22nd, 2012 | 5 Comments »

Our Raspberry Pi is arrived… cubeSQL on ARM processors is now much more closer. Since the beginning cubeSQL has been designed to be portable to other platforms so Linux ARM porting should not be a very big task…

Stay tuned for future news ;-)

cubeSQL 4.3.0b5

May 9th, 2012 | 5 Comments »

During the past months we worked hard on the new upcoming cubeSQL release.
We fixed all know bugs and we added some powerful functionalities.

Here you go the details of all the changes so far:

  • SERVER: Fixed a small log issue related to vm commands
  • SERVER: Added SSL support
  • SERVER: Added DROP PREFERENCE ‘key’ custom command
  • SERVER: Added ENCRYPT DATABASE dbName WITH KEY newKey custom command
  • SERVER: Added DECRYPT DATABASE dbName custom command
  • SERVER: Improved REMOVE USER FROM GROUP custom command
  • SERVER: Improved CREATE DATABASE IF EXISTS custom command
  • SERVER: Improved handling of UTF-16 encoded databases
  • SERVER: SET PREFERENCE BACKUP_PATH on Windows now correctly handle UNC and Network paths
  • SERVER: While disconnecting client now waits at maximum 6 minutes if a backup operation is in progress
  • SERVER: Added preference key SSL_CONNECTIONS_ONLY
  • SERVER: Fixed a realsqlserver.settings migration bug
  • SERVER: Fixed a bug related to MVCC turned ON and CREATE TABLE command when that table already exists
  • SERVER: Improved debug output for Windows Service events
  • SERVER: Fixed a rare Linux 32bit crash bug triggered by vmselect
  • SERVER: Added -q and -m startup parameters (cubesql -h for usage)
  • SERVER On Windows do not stop cubeSQL service if user disconnects
  • ADMIN: New icon
  • ADMIN: New SSL connection option
  • ADMIN: Other small fixes
  • ADMIN: New data folder that contains a valid SSL certificate
  • ADMIN: On Linux now checks if libgtkhtml is installed before opening the News panel
  • PLUGIN: New SSL options

Please note that the archive contains just the executable files for all platforms and require a valid serial number in order to properly run. As always you can request a key from:

Download cubeSQL 4.3.0b5

Please report any bug to us!!!

cubeSQL mailing list

March 29th, 2012 | No Comments »

To better serve our customers we just opened a dedicated cubeSQL mailing list.
To subscribe just visit its dedicated admin page or send an email to

Some cubeSQL news

March 29th, 2012 | 4 Comments »

We are working on the next cubeSQL version… where you’ll see a lot of improvements and features.

We are interested in trying to port cubeSQL to an ARM processor with Linux OS… do you know some good devices we could use for development and testing? We know about the very interesting Raspberry Pi project but its availability is too uncertainty at this time.

Please advice…

cubeSQL ODBC Driver 1.0b2

March 13th, 2012 | No Comments »

cubeSQL ODBC Driver version 1.0b2 is now available from:

What’s new:

  • Fixed an issue that caused Win32 installer to install the driver with the wrong name
  • Added support for auto-commit transactions
  • Fixed problem with authentication for System DSN’s on Mac
  • Added support for Mac OS X KeyChain
  • Fixed problems with MS Access import

Please test the new version and let us know if you find any problem.

ODBC Driver on Windows 64bit clarification

February 28th, 2012 | 7 Comments »

From a Jonathan Monroe suggestion I posted this comment few minutes ago, but it’s very important so it deserves a separated post:

In order to use ODBC with a 32-bit application (such as MS Office) on 64-bit Windows, you have to install the 32-bit driver. In order to configure a DSN for the 32-bit driver, you have to use the 32-bit ODBC Administrator, located at:


A DSN configured using the default 64-bit ODBC Administrator will not be recognized by 32-bit applications. More information about this situation is available here:

It is important to understand that you have to use the 32-bit ODBC Administrator on 64-bit Windows if you want to use the driver with MS Office or any other 32-bit application.

cubeSQL ODBC Driver 1.0b1

February 27th, 2012 | 11 Comments »

Thanks to Jonathan Monroe from Actual Technologies we are proud to announce cubeSQL ODBC Driver version 1.0b1. You can download it from:

There are some outstanding issues, so it should be considered BETA software. The most serious problems right now are:

- the “auto-commit” mode (default) is not working. All inserts, updates and deletes must be manually COMMIT-ed
- the “Store user ID in Keychain” feature (OS X only) is not working. You should disable this checkbox on your DSN.

There are several minor issues with some of the numeric and date / time data types. So far the drivers have been tested with MS Excel on Mac and Windows, please test the new ODBC driver with your solution and let us know if you find any problem.

Special cubeSQL offer LAST DAY.

February 17th, 2012 | No Comments »

Today is the last day for the special 50% off cubeSQL offer.
New licenses can be purchased from:

Renewal licenses can be purchased from:

Don’t miss this opportunity!