AdHocQ
| Home | Screenshots | Download | Support |
AdHocQ is freeware - it is free for evaluation purposes and for non-commercial use. In a commercial environment, the software must be licensed.
Please see Support for licence information and contact details.
AdHocQ 1.6 Download (664KB)
.Net Framework 3.5 or later.
For MySQL connections, you may need MyOleDB.
For Oracle connections, you may need Oracle Data Access Components (you probably don't need the version with Oracle Developer Tools for Visual Studio).
When you start AdHocQ, it will try to communicate with the adhocq website for version information. Only your current AdHocQ version number is transmitted, and no information is stored. You can choose to block this http request with your firewall without impacting on AdHocQ's functionality.
Download (664KB) When choosing tables, you can expand them to see what columns they have.
Download (493KB) Minor navigation improvements, e.g. allowing you to choose which page to go back to.
Download (462KB) Gives a warning if there is a possibility of an aggregate having inflated values due to over-counting (i.e. a fan trap warning).
Download (225KB) Can perform aggregate functions (e.g. Minimum, Maximum, Sum etc.).
Download (219KB) Can join multiple tables together.
Download (210KB) Can specify queries directly in SQL.
Download (210KB) Ability to save and re-use queries.
Download (207KB) Some bug fixes (SQLServer connection string, thread handling).
Download (204KB) Previous connections are remembered and can be re-used.
Download (202KB) You can specify the sort order of the results.
Download (198KB) A 'Show Query' button lets you see the SQL query; also fixes a bug (edited conditions weren't being deleted properly).
Download (197KB) You can copy results to clipboard.
Download (197KB) You can export the results of the query to CSV.
Download (193KB) The results are now paginated.
Download (191KB) Second beta, limited testing. Handles Oracle schema names, database access now threaded.
Download (189KB) First beta, limited testing. Doesn't work very well with Oracle or large datasets. Only for the brave!
AdHocQ - Business Intelligence Made Easy
Please see Support to contact us regarding reciprocal links. Links to this site should say something like 'AdHocQ - Simple ad hoc query tool for database reports - build up your ad hoc query in steps, through a wizard-style interface. Supports MS Access, MySQL, Oracle, SQLServer'.