QueryODBC > Enhancements

Version 3.3.14 Enhancements

Command Line Parameters
You can now launch QueryODBC using command line parameters to connect to a database and execute a query. The connection parameter is "/c" and must be followed by a space then a valid OLE DB connection string surrounded by double quotes. You can use a QueryODBC login file to generate and obtain the OLE DB connection string. The query parameter is "/q" and must be followed by a valid query surrounded by double quotes. The command line can be passed to Windows using either the Windows Start/Run dialog, or a batch (.BAT) file.

The following example command line will launch QueryODBC, connect to a database and execute a query (you can also connect without executing a query by dropping the "/q" parameter):
QueryODBC.exe /c "Provider=SQLOLEDB;UID=sa;PWD=myPass;Database=DemoDb;" /q "select * from mytable"

Version 3.3.13 Enhancements
	Replace feature Replace functionality has been added to the Find/Replace screen (previously called the Find screen). Use the Replace button to replace one item at a time, or use the Replace All button to replace all items matching the Find text.

Version 3.3.12 Enhancements
	Improved Handling of Evaluation Period Expiration QueryODBC now allows you to enter licensing information regardless of whether your evaluation period has expired. Previously you could not enter licensing information after the expiration of the evaluation period.
Version 3.3.11 Enhancements
	Store License Information in Non-User Specific Location QueryODBC now stores your license information in a location that is not user specific. Multiple users can now use QueryODBC on a single machine without re-entering the license information for each user. Please note that pursuant to QueryODBC's license agreement, you may only install QueryODBC on a single computer for each licensed seat. Please refer to the license agreement for details.
Version 3.3.10 Enhancements
	Windows XP Memory Fix QueryODBC no longer runs out of memory when copying large amounts of data into the Results grid using Windows XP.
Version 3.3.9 Enhancements
	Execute Sub-Commands You can now execute selected portions of your commands in the Command tab. To execute only a portion of a command, simply highlight (by selecting the text) the portion you wish to execute. When command text is highlighted, QueryODBC only executes the highlighted portion of the command. When no text is highlighted, QueryODBC executes the entire command. Use this feature to execute sub-queries contained in your main query.
	New Option to Clear Statistics Tab on Login A new option has been added to automatically clear the data from the Statistics tab when you login to a new database. Use the "Clear before new login" checkbox in the Statistics tab of the Options screen to activate this feature.
	Contents of Login File Displayed in Statistics Tab When you connect to a database using a login file, the name and path as well as the contents of the login file are now displayed in the Statistics tab. Previously only the name and path were displayed.

Version 3.3.8 Enhancements
	Enhanced Double-Click Word Selection Double-Click word selection in the Command and Statistics tabs has been enhanced so that column and table names are fully selected. Previously only a portion of the name was selected if the name contained non-apha/numeric characters.
	Storage of Last Login File Path QueryODBC now remembers the last path used for login files and will automatically take you to the last used path when the Use File button is clicked in the Login window.

Version 3.3.7 Enhancements
	Save Login Connection Values to File You can now save your login connection values to a login file. The login file allows you to re-connect to a database without manually re-entering the connection values. In the Login window, use the "Save" button to create a login file. Use the "Use File" button to login using a login file.

Version 3.3.5 Enhancements
	Save Results as an ADO Recordset File You can now save query results as an ADO Recordset file (.ado). Use this file format to move data from one table, database or database provider to another, or create persisted recordsets. To move data, first save your query results as an ADO Recordset file, then use the new Insert Data menu option to load the data into the desired destination table. The destination table can be in the same database, or a different database. QueryODBC's list of "save results as" formats is now as follows: ADO Recordset (.ado), HTML Document (.htm), SQL Statement (.sql), and Text (.txt).
	Insert Data Menu Option Use the new Insert Data menu option to load the data contained in an ADO Recordset file into a database table. To load data, select the desired table (or view) in the tree within the schema tab and then click on the Insert Data option in the Process menu.

Version 3.3.0 Enhancements
	Backup and Restore Data / Migrate Database Providers Backup processing allows you to create a backup copy of the data contained in your database. Restore processing allows you to load the backup data into the original database, or any other database with the same schema. This processing can be used to move data from one database provider to another (i.e. MS Access to Oracle, Oracle to MS SQL Server, etc.).
	Paste BLOB Text into Results Grid You can now paste BLOB text data directly into the results grid. Previously you had to use the view detail window to paste BLOB text.
	Support for Oracle OLEDB Provider You can now use the Oracle OLEDB provider to login to Oracle databases. This provider is supplied by Oracle Corporation and can be downloaded for free @ http://otn.oracle.com/software/content.html. Previously you had to use the Microsoft "Generic ODBC" or "MS Oracle" providers to login to Oracle databases. The Microsoft providers are installed when you install MDAC. Any of these three providers can now be used to login to Oracle databases. Each provider allows for differing levels of functionality.

Version 3.2.5 Enhancements
	Support for MS Active Directory Service Provider You can now use QueryODBC to access your Microsoft Active Directory Service data. To connect to the service, select the "MS Active Directory Service" provider and enter your user ID and password in the login window. You must use the query syntax documented in the Microsoft Active Directory Service Reference to query this data.
	Significant Speed Improvement Saving Changes in Results Grid We have significantly improved the processing speed when saving large amounts of changes in the results grid.
	Significant Speed Improvement When Deleting Data in Results Grid We have significantly improved the processing speed when deleting large amounts of data in the results grid.
	Elapsed Time for Saving Results Grid Changes Total elapsed time for saving results grid changes is now calculated and displayed in the statistics tab.

Version 3.2.1 Enhancements
	Significant Speed Improvement When Pasting Data in Results Grid We have significantly improved the processing speed when pasting large amounts of data in the results grid.

Version 3.2.0 Enhancements
	Edit Text BLOB Data in the View Detail Window You can now edit text BLOB data by typing in the view detail window. A new update button has been added to the view detail window to allow you to update the results grid with your revised text BLOB data. Updated text BLOB data is treated like any other edited data in the results grid. Previously, text BLOB data had to be edited in an application external to QueryODBC (i.e. Word Pad, Note Pad, etc.). The edited text file was then inserted into the database using the insert button in the view detail window. You can still use this method of editing text BLOB data if you desire.
	Support for MS Indexing Service Provider You can now use QueryODBC to access your Microsoft Indexing Service data. To connect to the service, select the "MS Indexing Service" provider and enter the desired catalog name in the login window. You must use the query syntax documented in the Microsoft Indexing Service Reference to query this data.
	Clear Binary BLOB's A new button has been added to the view detail window that allows you to clear the binary BLOB data contained in a cell of the results grid.

Version 3.0.0 Enhancements
	Edit, Insert and Delete Records in Results Grid Database records can be edited, inserted and deleted using the results grid. To edit a record, simply type or paste your revisions into the cells of the results grid. Cells that have been edited display with a green background. To insert a record, use the insert option in the edit menu (or use the insert toolbar button). This option inserts a new row in the results grid. Type or paste the data for the new record into cells of the inserted row. If you paste into an insert row and your paste data contains multiple records, additional insert rows will be generated automatically to accommodate the data for each pasted record. Rows in the results grid that contain inserted records display with a yellow background. To delete records, select the records you want to delete and use the delete option in the edit menu (or use the delete toolbar button). Rows in the results grid that contain deleted records display with a red background. Use the undo option in the edit menu to reverse your changes to edited cells or inserted records prior to saving. To save your changes, use the save option in the file menu (or the save toolbar button). Changes saved in the results grid are treated the same as UPDATE, INSERT, and DELETE commands by the database. As a result, you can use the ROLLBACK command to undo your results grid changes even after you have saved them.
	Insert Binary Large Object (BLOB) Data You can now insert BLOB data into any BLOB field in your database. To insert BLOB data, select the desired destination BLOB field (cell) in the results grid and click the view detail button (the view detail window will appear). Click the insert button on the view detail window and select the file that contains the BLOB data you want to insert. The cell that has been edited as a result of the inserted BLOB data will appear with a green background in the results grid. Use the undo option in the edit menu to reverse your changes to edited fields prior to saving. To save your changes, use the save option in the file menu (or the save toolbar button). Changes made in the results grid are treated the same as UPDATE, INSERT, and DELETE commands by the database. As a result, you can use the ROLLBACK command to undo your changes even after you have saved them.
	Right Click Menus Right click menus have been added to all of QueryODBC's tabs to allow you to perform common tasks more efficiently.

Version 2.5.1 Enhancements
	Stored Procedures The results of stored procedures that return record sets are displayed in the results grid. Previously record sets produced by stored procedures were not displayed in the results grid.

Version 2.5.0 Enhancements
	Database Schema Explore the tables, stored procedures, views and data types in your database. Within each table, explore detailed information about the table's columns, primary key, foreign key, indexes and constraints. Within each stored procedure, explore detailed information about the stored procedure's parameters. Within each view, explore detailed information about the view's columns. Within data types, explore detailed information about the data types supported by the database provider.
	View, Copy or Save All Types of Binary Large Object (BLOB) Data If a query returns any type of BLOB data, QueryODBC will display "BLOB" in the cells of the results grid that contain the BLOB data. To view, copy or save the underlying BLOB data to a file, select the cell containing the BLOB and click the view detail button. The view detail (BLOB) window allows you to work with the currently selected BLOB. Previously QueryODBC only allowed you to view, copy or save BLOB text (not binary) data. QueryODBC now allows you to work with any type of BLOB data.
	Display Binary Large Object (BLOB) Data in RTF Format If a query returns BLOB data that is text in RTF (rich text format) format, QueryODBC will display the text in its fully formatted form. Previously QueryODBC displayed the RTF data in its "raw" form (RTF formatting codes were visible, and text was unformatted). If you save RTF BLOB data to a file using QueryODBC, you should use the ".rtf" file extension for the file name (i.e. "MyFile.rtf"). QueryODBC's list of viewable BLOB formats is now as follows: Images in bitmap, icon, metafile, enhanced metafile, JPEG, or GIF format, and text in text or RTF format.
	MDAC 2.5 Required QueryODBC version 2.5 takes advantage of features that are only available under MDAC 2.5 or greater. You must install MDAC 2.5 or greater before using QueryODBC version 2.5. Previously MDAC 2.1 or greater was required.

Version 2.0.0 Enhancements
	Format HTML Output Using a Template File A fully customizable HTML template file controls the format and content of an output web page generated by QueryODBC that contains your query results. Several sample HTML template files are provided. You can create an unlimited number of your own template files. QueryODBC's HTML template file supports enumeration of formatting within the rows and columns of the HTML table that displays your query results (i.e. repeating formats by row and/or column). You select the HTML template file to be used to format the HTML output.
	SQL Code Analysis QueryODBC analyzes your SQL code and highlights keywords, comments and character strings. You can control the colors used to highlight each of these items, as well as the automated capitalization of keywords. A keyword file is provided with QueryODBC listing all of the words that will be treated as keywords. You can edit this file or create your own keyword files, and select the keyword file used for SQL code analysis.
	View Binary Large Object (BLOB) Text Data QueryODBC allows you to view BLOB text data from the results grid. If your query returns BLOB text data, the results grid will display "BLOB" in the cell containing the BLOB text data. To view the underlying BLOB text data, select the cell containing the BLOB text data and click the view detail button. In the text detail (BLOB) window, you can view, copy, or save the BLOB text data to a file.
	New Toolbar A toolbar has been added to allow you to efficiently perform common tasks such as; open, read and save a file, cut, copy and paste, search for text, format amounts, sort results, connect to a database, re-run previous queries, set options, and get help.
	New Status Bar A status bar has been added to provide important information such as; processing status, current line number for the command and statistics fields, the name of the currently connected datasource or database, and CAPS, NUM and INS settings.
	Search for Text in All Tabs You can now search for text all three of QueryODBC's tabs (command, results, and statistics tabs). Previously Edit/Find was only available in the results tab.
	Open SQL Command File via Drag and Drop If you drag a text file (.SQL or .TXT) containing SQL commands and drop it in QueryODBC's command text field, the file will be opened.

Version 1.2.7 Enhancements
	Save Query Results as HTML Query results can be saved as an HTML document for posting on the web. Previously query results could be saved in text and SQL format only.

Version 1.2.5 Enhancements
	Asynchronous Query Execution All queries are executed asynchronously and thus can be canceled while the query is executing. Previously only SELECT queries were executed asynchronously.
	BLOB Result Display Query result cells with data type of BLOB (Binary Large Object) are displayed in the results grid as "BLOB." Previously QueryODBC did not display BLOB data properly in the results grid.

Version 1.2.0 Enhancements
	New File/Read Menu Option A new read option has been added to the file menu. The read option allows you to efficiently send large queries to the database, or read SQL scripts. The read option allows you to specify the number of characters sent to the database as a single command.
	Elapsed Time Precision In the statistics tab, elapsed time in seconds is now rounded to the nearest 1/100th of a second. Previously elapsed time was only displayed in whole seconds.
	MDAC Installation Warning Message A warning message now appears the first time you open QueryODBC reminding you that you must first install MDAC before using QueryODBC. See on-line help topic 'Installing QueryODBC' for information regarding MDAC installation.
	Enhanced Column Autosizing in Results Grid The column autosizing algorithm in the results grid has been enhanced.

QueryODBC > Enhancements

Version 3.3.14 Enhancements

Version 3.3.13 Enhancements

Version 3.3.12 Enhancements

Version 3.3.11 Enhancements

Version 3.3.10 Enhancements

Version 3.3.9 Enhancements

Version 3.3.8 Enhancements

Version 3.3.7 Enhancements

Version 3.3.5 Enhancements

Version 3.3.0 Enhancements

Version 3.2.5 Enhancements

Version 3.2.1 Enhancements

Version 3.2.0 Enhancements

Version 3.0.0 Enhancements

Version 2.5.1 Enhancements

Version 2.5.0 Enhancements

Version 2.0.0 Enhancements

Version 1.2.7 Enhancements

Version 1.2.5 Enhancements

Version 1.2.0 Enhancements