You have a database that speaks ODBC, and you need to run a quick query or a batch of SQL scripts. You don't want to open a full database IDE to do it. Query Tool (using ODBC) is a small Windows utility for that job.
Quick facts
- Version (32-bit): 6.1.9.89
- Also available: a 64-bit build, 7.0.7.74
- Platform: Windows
- Download size: about 6.37 MB
- Data access: ODBC data sources (a sibling tool covers ADO and OLE DB)
Key features
Query any ODBC data source and write SQL scripts
You can query ODBC data sources and author SQL scripts and queries in one window.
Run several scripts or stored procedures at once
The tool can execute multiple SQL scripts or stored procedures simultaneously, so you don't have to run them one by one.
See results in a grid or as free-form text
Results can go to a grid or to free-form text, whichever suits the query.
Export results and inspect ODBC drivers
The Query Tools suite can export results in Excel, XML and HTML formats and retrieve ODBC driver information, which helps when you're debugging a connection.
Who it's for
It suits developers and database administrators who work with ODBC sources and want a lightweight tool for writing and running SQL.
Pros and cons
- Pro: small download and a focused feature set.
- Pro: a 64-bit edition is available.
- Con: the 32-bit ODBC build is on an older version line (6.1) than the 64-bit build (7.0).
- Con: Windows only.
FAQs
Does it work with 64-bit drivers?
The 64-bit edition (7.0 line) is the one meant for 64-bit data sources. The 32-bit edition is on the 6.1 line.
Can it connect to OLE DB sources?
That's handled by the related ADO edition of the tool, not the ODBC one.
Can I run more than one script at a time?
Yes. It runs multiple SQL scripts or stored procedures simultaneously.
System requirements
Windows. The vendor's page doesn't list anything more specific.