Home
Name Modified Size Downloads / Week Status
odbcquerytool 2017-09-16 127127 weekly downloads
readme.txt 2017-09-16 3.5 kB 11 weekly downloads
Totals: 2 Items   3.5 kB 128
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 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.
Source: readme.txt, updated 2017-09-16

Thanks for helping keep SourceForge clean.

Screenshot instructions:
Windows
Mac
Red Hat Linux   Ubuntu

Click URL instructions:
Right-click on ad, choose "Copy Link", then paste here →
(This may not be possible with some types of ads)

More information about our ad policies
X

Briefly describe the problem (required):

Upload screenshot of ad (required):
Select a file, or drag & drop file here.

Please provide the ad click URL, if possible:

Get latest updates about Open Source Projects, Conferences and News.

No, thanks