AdHocQ

Simple ad hoc query tool for database reports

Licence

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.

Current version

AdHocQ 1.6 Download (664KB)

System requirements

.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.

History

26-Jul-2010 1.6

Download (664KB) When choosing tables, you can expand them to see what columns they have.

8-May-2010 1.5

Download (493KB) Minor navigation improvements, e.g. allowing you to choose which page to go back to.

26-Feb-2010 1.4

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).

13-Feb-2010 1.3

Download (225KB) Can perform aggregate functions (e.g. Minimum, Maximum, Sum etc.).

16-Dec-2009 1.2

Download (219KB) Can join multiple tables together.

1-Nov-2009 1.1

Download (210KB) Can specify queries directly in SQL.

26-Oct-2009 1.0

Download (210KB) Ability to save and re-use queries.

10-Oct-2009 Beta 0.9

Download (207KB) Some bug fixes (SQLServer connection string, thread handling).

20-Aug-2009 Beta 0.8

Download (204KB) Previous connections are remembered and can be re-used.

18-Jul-2009 Beta 0.7

Download (202KB) You can specify the sort order of the results.

23-May-2009 Beta 0.6

Download (198KB) A 'Show Query' button lets you see the SQL query; also fixes a bug (edited conditions weren't being deleted properly).

4-May-2009 Beta 0.5

Download (197KB) You can copy results to clipboard.

19-Apr-2009 Beta 0.4

Download (197KB) You can export the results of the query to CSV.

6-Apr-2009 Beta 0.3

Download (193KB) The results are now paginated.

22-Mar-2009 Beta 0.2

Download (191KB) Second beta, limited testing. Handles Oracle schema names, database access now threaded.

21-Feb-2009 Beta 0.1

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

Listed at

Best Freeware Download 5 stars award from www.download25.com AdHocQ 5 stars award Antivirus Report for AdHocQ 1.4 on SuggestSoft.com Download AdHocQ

Reciprocal links

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'.

WareZone - Download Free Software