Query Tool (using ODBC)

Query Tool (using ODBC) is a compact Universal Data Access (UDA) software application that empowers you to query ODBC data sources, author SQL scripts and queries, return query results, as well as get ODBC driver information.

The tool employs a user-friendly layout that allows you to execute or cancel the process, as well as save the files to HTML file format. It provides tabs for multiple query editors and implements smart buttons in the main panel for helping you trigger quick actions, such as print data, perform searches, query with current connection, and reconnect.

You are allowed to query using the current, changed or new connection. A new connection can be established by selecting the file data source that describes the driver that you wish to connect to. You may use any file data source that refers to an ODBC driver which is installed in your machine.

You may choose between various types of files for setting up a data source, such as TXT, CSV, MDB, DBF, XLS, DB, and MDX file format, as well as SQL server, Microsoft Visual FoxPro Driver, Microsoft FoxPro-Treiber, and Microsoft ODBC for Oracle.

The tool lets you reconnect, disconnect, change the connection, manage transactions (commit, rollback), and retrieve table, package, procedure and function definitions in text view mode (otherwise the results are shown in a grid by default).

Several tweaks can be applied to the current connection, as you may specify the query timeout (in seconds), enter the query batch separator, use quoted identifiers, as well as select the query execution thread priority (e.g. normal, lowest, highest).

You can make use of an ODBC data source administrator for setting up data related to user, system and file DSN, drivers, tracing, and connection pooling. Plus, you can manage a remote desktop connection, schedule tasks, write command-line arguments, and get system information.

Query Tool (using ODBC) comes with a decent feature pack and provides an intuitive working environment for helping you query ODBC data sources without investing too much time and effort into it.