We help IT Professionals succeed at work.

We've partnered with Certified Experts, Carl Webster and Richard Faulkner, to bring you a podcast all about Citrix Workspace, moving to the cloud, and analytics & intelligence. Episode 2 coming soon!Listen Now

x

Need a Standalone Visual Query Tool for multiple database types (ODBC), Any Suggestions?

naj2576
naj2576 asked
on
Medium Priority
292 Views
Last Modified: 2006-11-18
Hello All,

I need to find a standalone program that offers a Visual Query Editor interface for designing select statements, that can execute SQL Statements against multiple types of Databases (through ODBC), and can export the results to a CSV file (or some other flat text format).

I have tried searching around on the net for a couple of days, and I have yet to find anything that meets these requirements.  I've been trying to limit my search to freeware programs, but if I have to pay a small fee for a program I do not mind.

I need to be able to run this program off of a flash drive (thumb drive, jump drive, whatever you want to call it).  I am in and out of clients offices all day and you would be surprised how many of them lack any program that can connect to a database through ODBC.  I mean, I thought that Excel was pretty much standard in any office setting, but I digress...

If anyone can make some recommendations on software that I should try, I'd really appreciate it.

Thanks.
Comment
Watch Question

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts
Commented:
I seem to recall MS offers a tool like that (subset of the Access interface).  Perhaps a search at microsoft would yield the info.  It's been several years since I ran across it.
CERTIFIED EXPERT
Most Valuable Expert 2015
Distinguished Expert 2018
Commented:
May be a little more sophisticated than you need:

http://www.dbxtra.com/

/gustav

Author

Commented:
Thanks for the ideas.  Couldn't get the boss to go for any of them.  Back to the drawing board.

Commented:
Thanks for the points.  Too bad regarding the boss.
CERTIFIED EXPERT
Most Valuable Expert 2015
Distinguished Expert 2018

Commented:
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.