QueryODBC
Reviews
Rated "editors' pick" (5 stars out of 5) by ZDNet.
Key Benefits
 |
Work with any ODBC compliant or
OLE DB compatible database |
|
Work with Microsoft services such as MS Indexing Service and MS Active Directory Service |
|
View detailed database schema information |
|
View query results in a grid (spreadsheet)
format |
|
Insert, delete and edit records
by typing, or copying and pasting, in the results grid |
|
Execute asynchronous SQL commands
and SQL scripts (commands can be canceled prior to completion) |
|
Backup and restore data |
|
Move data from one table,
database or database provider to another |
|
Edit, insert, display, copy and
save Binary Large Object (BLOB) data |
|
Analyze SQL code (highlights keywords, comments and character strings) |
|
Save query results as an ADO, HTML, text, or SQL (INSERT statements) file |
|
Format HTML output based on a fully customizable HTML template file |
|
View and maintain a log of actions performed |
Overview
QueryODBC allows you to work with any ODBC compliant
or OLE DB compatible database, as well as Microsoft services such as Microsoft Indexing Service and Microsoft Active Directory Service. With QueryODBC you can explore your database's schema, and execute asynchronous queries, SQL commands and SQL scripts on your database. As you type SQL commands, QueryODBC analyzes your SQL code and highlights keywords, comments and character strings. SQL code is also analyzed when you open SQL command files.
QueryODBC displays query results in a grid (spreadsheet) and
allows you to insert, delete, and edit records by typing or copying and pasting
in the grid. You can also sort, reformat, sum and search & replace the results within the grid.
Query results can be saved to a file in ADO, HTML, text or SQL format, or copied
to the clipboard. Results saved in ADO format can be used to move your
data from one table, database or database provider to another. Results saved in HTML format are saved as a web page, and are formatted based on a fully customizable HTML template file. The HTML template file supports enumeration of row and/or column format within the results table (repeating formats by row and/or column). Results saved in SQL format are saved as SQL INSERT
statements. Binary Large Object (BLOB) data can be edited, inserted, viewed, copied or saved to a file using the view detail (BLOB) window.
QueryODBC allows you to backup and restore the
data in your database, as well as move your data from one table, database or
database provider (i.e. migrate from MS Access to Oracle, Oracle to MS SQL
Server, etc.) to another. You can move all of your data at once, or choose to
move only selected data.
QueryODBC allows you to run previously saved queries, commands and scripts, and save new queries, commands and scripts to a file. QueryODBC's previous and next options allow you to efficiently re-run queries, commands and scripts executed during the current session.
As you work in QueryODBC, your actions are logged in the statistics tab, and to a statistics log file (optional). The statistics tab also provides performance information such as total elapsed time and records per second for query result retrieval and file save operations, as well as the path and file name of each file saved. Statistics data can be saved to a text file.
System Requirements
|
Win95, Win98, NT4.0, Win2000, WinMe, WinXP |
|
MDAC v2.5 or later
|
Screen Shots
Recent Enhancements
Download the Evaluation Version of QueryODBC
Order QueryODBC
|
