Skip to content

Releases: edwig/ODBCQueryTool

Release 3.4.1

30 Dec 18:18

Choose a tag to compare

Fixed a bug getting the database "Ping" from Firebird.
Also fixes a crash on that database after a few minutes.

Release 3.4.0

09 Oct 15:46

Choose a tag to compare

This version is dedicated to the conversion to Unicode 16.
The Unicode versions are still in early development stages.
For production environments you are still encouraged to choose for the (old fashioned)
ANSI/MBCS coding version.

You can make a choise from the following set of installers:

  • 32 Bits ANSI/MBCS coding
  • 32 Bits Unicode version
  • 64 Bits ANSI/MBCS coding
  • 64 Bits Unicode version

Release 3.3.1

10 Aug 15:35

Choose a tag to compare

Releasenotes 3.3.1

It is now possible to override the character set from the database by using one of two methods:

  1. Reading the default character set from a system table (e.g. Firebird);
  2. Choosing a character set directly from a list.

You can find this setting by navigating to the 'Text' menu, and then 'Permanent settings' and
then to the 'SQL' tab. There you will find the field 'Charset handling'. When choosing the third
option ('Use charset translation') the combobox for 'character set' will become active and you
can choose a character set.

Most notabely you can use this setting for RDBMS types that are not directly supported such as
for instance a 'SAP-Hana' database. Or for database types where the ODBC driver does not correctly
hands over the character buffer in UTF-16 form to the MS-Windows operating system.
Such as the Firebird ODBC driver 2.x

NOTE:Do NOT forget to reset this general setting when connecting to a different database that does
not adhere correctly to the ODBC standard! As it will bite you as it did me!! :-(

Release 3.3.0

27 May 17:34

Choose a tag to compare

In this release the free 'odbc-connection-string' feature is implemented (at last).
Connections can have the combination of "datasource" / "user" / "password".
Or a free connection string. In the latter case, only the 'datasource' name is
stored for the connection.

Optionally you can leave out the user name and/or the password name if a datasource
does not require these for security reasons. An MS-Access database or the MS-Excel ODBC driver
are examples of these.

There is a new button "Connection string" on the connection dialog, or you can use the
'Details' button to fill in a connection string to your liking.

Release 3.2.4

24 Apr 18:25

Choose a tag to compare

Releasenotes 3.2.4

At-Exec data at the end of a SELECT, or no NUMERIC columns gotten as a SQL_C_CHAR

Version 3.2.3

17 Apr 05:03

Choose a tag to compare

Fix for login dialog and the "production / development" switch
QueryRewriter no has knowledge of the 'UPDATE STATISTICS' statement

Release 3.2.2

19 Mar 18:18

Choose a tag to compare

  • Fix for decimals in NUMERIC/DECIMAL datatypes.
  • Fix for reading stored-procedures from SQL-Server
  • Precision and scale are recalculated before syncing with the database
  • Please note that the SQLMigrate tool has been removed from the SQLComponents library
    and now officially exists within this project.

Release 3.2.1

23 Jan 16:38

Choose a tag to compare

Fix for removing old and stale settings from the roaming profile directory

Release 3.2.0

22 Jan 18:22

Choose a tag to compare

Adding in this release:

  • SQLMigrate tool to migrate between RDBMS vendors
  • QueryReWrite tool to make queries versatile for more than 1 vendor
  • Upgrades of all major libaries (BaseLibrary, SQLComponents, StyleFramework)
  • Smaller improvements (SQL_NTS option for running queries)

v3.1.0

22 Dec 15:38

Choose a tag to compare

Releasenotes version 3.1.0

  • Added toasts when (de-)populating the object tree of the QueryTool
  • Added the SQLMigrate program from the SQLComponents to the toolsset.
    The program can be reached through the new 'Tools' submenu.
    This program makes it possible to migrate complete database sets from one database to
    another, even if it is of a different vendor making.
    Real life situations that has been tested include conversions from the following:
    Informix -> Oracle
    Informix -> PostgreSQL
    Informix -> Firebird
    Oracle -> SQL-Server
    Oracle -> MySQL & MariaDB
    SQL-Server -> Oracle