Query Tools (using ODBC and ADO): a 64-bit SQL query tool for Windows
You have a database that only answers through an ODBC driver, and the 32-bit tools you have can't see the 64-bit drivers installed on your machine. Query Tools (using ODBC and ADO) from George Poulose Software is built for this situation. It gives you a 64-bit build for 64-bit drivers and a 32-bit build for 32-bit ones.
Quick facts
- Current versions: 7.0.7.74 (64-bit) and 6.1.9.89 (32-bit)
- Platform: Windows
- Download size: about 6.37 MB
- Data access: ODBC and OLE DB data sources
Key features
Query ODBC and OLE DB data sources from one tool
You can connect to ODBC data sources and OLE DB data sources, then write and run SQL scripts and queries against them.
Run several scripts or stored procedures at the same time
The tool can execute multiple SQL scripts or stored procedures simultaneously. That saves you from running them one after another.
See results in a grid or as free-form text
Query results can go to a grid or to free-form text, depending on which is easier to read for the query you ran.
Export results to Excel, XML and HTML
You can export what you get back in Excel, XML and HTML formats, so sharing results with others is simple.
Check driver and provider details
The tool can retrieve ODBC driver information and OLE DB provider properties. That helps when you are working out why a connection behaves the way it does.
Who it's for
It suits developers and database administrators who need a small, plain Windows utility to test connections and run SQL against ODBC or OLE DB sources. This is especially true if you need the 64-bit drivers.
Pros and cons
- Pro: both 64-bit and 32-bit builds ship in a single installer of about 6 MB.
- Pro: supports both ODBC and OLE DB, and exports to Excel, XML and HTML.
- Con: it is Windows-only.
- Con: it is a focused query utility, so you shouldn't expect it to be a full database management suite.
FAQs
Does it work with 64-bit ODBC drivers?
Yes. The 64-bit edition is version 7.0.7.74, and a 32-bit edition is included for 32-bit drivers.
Can I export my results?
Yes. You can export to Excel, XML and HTML.
Can I run more than one script at once?
Yes. It can execute multiple SQL scripts or stored procedures simultaneously.
Does it only handle ODBC?
No. It also handles OLE DB data sources.
System requirements
The vendor lists the platform as Windows.