SQL Explorer tool GONE in 10.1a

[regulatre]

The SQL Explorer tool is gone as of 10.1a.

As far as I can tell, we need to create a new ODBC DSN for each different database we want to connect to.

All gripes aside, I know it's still possible to run SQL queries against the DB, it just has to be done through a third-party application.

Does anyone have a favorite (freeware) ODBC query tool?

It seems like it would be possible to make a JDBC connection to the DB (like the explorer tool would do) and not have to create an odbc connection. Anybody know more about this?

 

[gnobiron]

SQuirreL SQL

I am using SQuirreL SQL, a Java Program giving access to any database providing a JDBC connection. It's far better than SQL Explorer.

http://squirrel-sql.sourceforge.net/

 

[regulatre]

Nice. I'll check it out.
I've been playing with the MSQRY32.exe tool that comes with office, but it is very buggy.

I am using SQuirreL SQL, a Java Program giving access to any database providing a JDBC connection. It's far better than SQL Explorer.

http://squirrel-sql.sourceforge.net/