This is the README for ODBC QueryTool
=====================================
This ODBC Query tool is meant to be used against ODBC datasources.
It's primary purpose was to test various SQL commands againt an ODBC
connection instead of an Oracle OCI connection. This was needed because
1) Specific ODBC SQL could be tested like "{ oj ... }" outer join syntax
2) Specific escape sequences could be testen like "{ fn ...}" syntax
3) General proof that a command does work against an ODBC connection
4) General proof that the ODBC connection does work
More general: nowdays every database tend to come with it's own administration
and query tools, which means that a user has to have knowledge of all seperate
tools and interfaces. This tool provides 1 (one) interface for a general
ODBC database, so that a user only needs one tool to learn.
The downside of this choice is that the more sophisticated administration tasks
cannot be administred right away other than by typing SQL. There are no
fancy dialogs to administer database dependent objects like stored procs and
such. The good thing about this is that the user gets to know their database
pretty well.
LATEST HISTORY
==============
Releasenotes 3.4.3
------------------
The scripting :if command now has multiple operators: '=', '<>', '<', '>', '<=', '>='
The value of a variable can now be printed in the :print command to the output file
A variable can be assigned the value of another variable with ":variable<n> = variable<x>;"
Fixed a bug in the variables dialog (See menu: Script/Variables)
Releasenotes 3.4.2
------------------
Updated the libraries to the latest version. After a half year of testing: fixing
a lot of small Unicode bugs
Added the 'mustard' (yelow) and 'dark' themes
Fixed a bug in the object-discovery of the Firebird drivers.
Columns of tables and procedure arguments are working again.
Fixed a bug in the installer. Check on 'not-yet-installed' added
Releasenotes 3.4.1
------------------
Fixed a bug getting the database "Ping" from Firebird.
Also fixes a crash on that database after a few minutes.
Releasenotes 3.4.0
------------------
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
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!! :-(
Releasenotes 3.3.0
------------------
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.
Releasenotes 3.2.4
------------------
- At-Exec data at the end of a SELECT, or no NUMERIC columns
Releasenotes 3.2.3
------------------
- Fix for login dialog and the "production / development" switch
- QueryRewriter no has knowledge of the 'UPDATE STATISTICS' statement
Releasenotes 3.2.2
------------------
- 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.
Releasenotes 3.2.1
------------------
- Fix for removing old and stale settings from the roaming profile directory
Releasenotes 3.2.0
------------------
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)
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
- Added the QueryReWriter program. Can be configured to translate SQL Queries from
on RDBMS to another. Use the config tab to set your favourite setup.
The program can be reached through tne new 'Tools' submenu.
Relaesenotes version 3.0.8
--------------------------
- Various fixes for discovery of views, stored procedures in SQL-Server
- Better filter combo box above the objects tree plus toasts
Releasenotes version 3.0.7
-------------------------
- Fixed discovery of stored-procedures, sql-text and parameters for MS SQL-Server
- Added discovery of global/local temporary tables
Releasenotes version 3.0.6
--------------------------
- Fixed problem with the "Table DDL" command. Table create statements are generated again.
- Fixed the problem with the F10 key (run current SQL command line). The program is now prevented
from entering the 'Select main menu' state, after the pressing of this key.
If you wish to use the main menu from the keyboard, use a single ALT key to go there.
Releasenotes version 3.0.5
--------------------------
- Fixed a bug when changing the default font in the settings when installed in "C:\Progam Files\Edo"
this is the default location, so a lot of users will have this settup. The crash derived from the
fact that there where no update rigths on the settings files.
ODBCQueryTool now makes a copy of the setup files to the roaming profile of the user and afterwards
works from this set of setting files. This also fixes the crash.
- Fixes for the saving of a changed text file when closing the application. A crash in the dialog
that asks for the fact that the users wishes to save her/his work is solved.
- Fixed unwanted/unneeded message in the installer that same version is already installed
- Updates from support libraries to the latest versions (SQLComponents, StyleFramework, BaseLibrary)
Releasenotes version 3.0.4
--------------------------
- Added the ":exit;" command to the script language
Releasenotes version 3.0.3
--------------------------
- Fixed a bug when setting the font for the results grid
- Updated to SQLComponents version 2.0.0 and BaseLibrary
- Dropped support for 32-Bits version. Only 64-Bits version now released
Releasenotes version 3.0.2
--------------------------
- Various small fixes and Open source license in all files
- Added a PayPal donation button.
Releasenotes version 3.0.1
--------------------------
- Fixed a bug in the login dialog when defining a new connection.
Releasenotes version 3.0.0
--------------------------
- Completely rewritten interface in the latest modern MFC style.
Releasenotes version 2.5.1
--------------------------
- Fixed various bugs in the handling of the MariaDB database in Oracle mode
Prefer to turn OFF the "Strict ODBC" handling in the general SQL settings
for this database type, as the replacement SQL's work better for this database
- Columns and other attributes of tables in other schema's can be discovered
than just the currently active database schema.
- All database types are tested and some minor bugs in the handling of 'text'
and 'longtext' columns have been fixed.
Releasenotes version 2.5.0
--------------------------
- Fixed a bug in the saving of the permanent file settings causing the application
to crash after changing the file settings (e.g. tabs and space inserts).
See: Menu / Text / File settings & information
- Fixed a bug in the parameter binding of a query with the ":variable<n>" settings
for a "?" binding in a query.
See the file "script_syntax.txt" for more details
- Fixed a bug in the ":select on" command of the scripting syntax
Columnnames and row values are now correctly written to the script output file,
provided that you have used the ":file" command previously.
See the file "script_syntax.txt" for more details
Releasenotes version 2.4.0
--------------------------
- The source code of the SQLComponents are now replaced by a deployment ZIP file
in the root directory of the project. The ZIP contains the include directory
of that component and the four library files.
For a full explanation, see: https://github.com/edwig/SQLComponents
- Various discovery methods for the info tree have been improved in speed for the
Oracle database. The methods are:
- SQLColumns -> Discovery of all columns of a table
- SQLStatistics -> Discovery of all indices of a table
- SQLTablePrivileges -> Discovery of all table privileges
- SQLColumnPrivileges -> Discovery of all column privileges (NEW !)
- New setting. See menu: "Text / Permanent settings / SQL Settings"
A new checkbox is added "Prefer ODBC Meta-SQL". These are the settings:
off : If a meta-sql is present in SQLComponents, that one is used,
otherwise the ODBC discovery is used;
on : The ODBC discovery routines are always used.
So now it is possible to switch between the on-board SQL meta queries or the
ones provided by the standard ODBC driver (even if they are slower an more incorrect).
Releasenotes version 2.3.3
--------------------------
- Fixed a bug in the startup cycle on the first discovery queries.
It turned out that there where a few tables for in there that not all users
have rights on to see (e.g. Oracle: "dba_db_links")
Similar bugs for Informix, Firebird, PostgreSQL and SQLServer have been fixed
- Errors in SQL now turn up always with the erring SQL statement in them, so we
can always see what went wrong.
Releasenotes version 2.3.2
--------------------------
- Fixed more exception errors
- Upgraded to latest Windows 10 SDK
Releasenotes version 2.3.1
--------------------------
- Fixed the integration of the SQLComponents StdException into the exception
handling of the OpenEditor source code. This makes it better in catching user
mistakes in SQL and logging in into databases.
Releasenotes version 2.3.0
--------------------------
- Fixed performance bug in starting of Oracle 12 database. Knocked of 6 seconds
of each login for meta info of tables and catalogs.
- Oracle databases now also display all linked catalogs in the driver page
- Connection errors at login are now shown
- Upgraded to the latest MS-Windows 10 SDK build (17763)
Releasenotes version 2.2.2
--------------------------
- Compileable in Visual Studio 2017 (fixed std::string throws)
- Fixed 'no error on F5 after end-of-file' bug
- Fixed CTRL-F12 file error after installation
- Fixed CTRL-F12 error after END-OF-FILE in the buffer
- NEW FEATURE: right click on a ODBC table in the table tree to
- SELECT first 100 rows of the table
- Create a DDL script of the table
Both right-click menu items only work on a table or a view node
Releasenotes version 2.2.1
--------------------------
- It is now possible to login on a database without a user/password combination
e.g. a spreadsheet or a MS-Access database
Releasenotes version 2.2.0
--------------------------
- Sequences and procedures in the treeview are working in Oracle 12.2c
- Sequences metadata current and start values have been changed from long to double
to accomodate Oracle 12.2 changes.
Releasenotes version 2.1.0
--------------------------
In this release much work has been done for the object tree. The object tree
is now fully functional with the folllowing objects
- Tables
- Table columns
- Primary and foreign keys
- Indices and table statistics
- pecial (unique) columns not visible as table columns
- Other table referencing this table
- Triggers for the table
- Sequences for the table
- Granted rights on the table
- Views
- Catalog tables
- Synonyms
- Sequences
- Triggers
- Stored procedures
Sequences, triggers and catalog tables are objects that are not directly
supported by ODBC. For these objects the tree will only fully function:
1.Firebird 3.x and higher
2.PostgreSQL 9.x and higher
3.MySQL 5.7 and higher
4.Oracle 11.2 and higher
5.IBM-Informix 12.x and higher
For triggers and stored procedures: you can see the full source code
of the persistent-stored-module by double clicking on the 'S'ourcecode
node under the trigger or stored procedure.
Releasenotes version 2.0.0
--------------------------
- This is the 10th year anniversary edition of the Open ODBC Querytool!
The following have been changed / extended:
- The object tree was previously a tree with just one table at the most.
It is now a tree with tables, views, catalogs, and procedures you can
expand any object at will, the control will then try to read in extra
information for you. Thusly reading the performance hit over more than
just one action.
- The implmentation info tree (odbc options) has been moved from the
SQLComponents module to the ODBCQuerytool module (no functional changes).
- The installer has been moved to the standard open source NSIS installer
- The SQLComponents library has been upgraded to version 1.4.2
- Repaired the number format export in the XLS Excel export.