On 11/21/06, Pascal Bleser wrote:

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1

Sunny wrote:

...

what are your recommendations for a simple GUI which may execute and list results from SQL queries, send to MS SQL server? Something like MySQL's Query browser, or MS's own Enterprise manager. I do not need something fancy, I need to be able to run queries, and view the results.

- - DbVisualizer: http://www.minq.se/products/dbvis/ * excellent * not opensource but has a (very capable) freeware version

- - Squirrel SQL: http://www.squirrelsql.org/ * not near as fancy as DbVisualizer but still does its job well * GPL/LGPL

Download a type 4 (pure java) JDBC driver for MS SQL, e.g. here: http://jtds.sourceforge.net/

Note, I'm using DbVisualizer a lot at work (and occasionally Squirrel), but luckily I don't have to work with MS SQL - tested thoroughly with PostgreSQL, MySQL, Oracle and DB2 though.

Hope this helps.

cheers - -- -o) Pascal Bleser http://linux01.gwdg.de/~pbleser/ /\\ _\_v The more things change, the more they stay insane. -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.2 (GNU/Linux)

iD8DBQFFY4YEr3NMWliFcXcRAly+AKCUNRL+uxUiZAQyhPrj+fM9PWyccACfYEG0 bOqto30r3QUOMxS4dUhr5v8= =le2d -----END PGP SIGNATURE----- --

A really good cross platform tool is aqua data studio from aquafold.com it works with SQL Server when you have to use it ;) George -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org

On 11/21/06, Chuck Davis wrote:

George:

All the Java IDEs have that capability by default.

Java source code IDEs you mean?

You can get NetBeans and JDeveloper downloads.

They have some capabilities yes but not as many as this one I think.

Eclipse must surely have a module that can do it if you want to go through their module hell. But NetBeans has it by default. Just install the JDBC driver for your database and away you go.

I like NetBeans too :)

Chuck Davis

On 11/21/06, George Stoianov wrote:

...

On 11/21/06, Pascal Bleser wrote:

...

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1

Sunny wrote:

...

what are your recommendations for a simple GUI which may execute and list results from SQL queries, send to MS SQL server? Something like MySQL's Query browser, or MS's own Enterprise manager. I do not need something fancy, I need to be able to run queries, and view the results. -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org

-- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org

Of course, I'm not claiming it's a light weight solution! :) CD On 11/22/06, Chuck Davis wrote:

Hi George:

Well, all Sunny asked for was to enter a query and see the result. NetBeans does that very nicely (and much more) for any database with a JDBC driver.

Chuck

On 11/22/06, George Stoianov wrote:

...

On 11/21/06, Chuck Davis wrote:

...

George:

All the Java IDEs have that capability by default.

Java source code IDEs you mean?

-- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org

On Tuesday 21 November 2006 15:04, Pascal Bleser wrote:

Sunny wrote:

...

what are your recommendations for a simple GUI which may execute and list results from SQL queries, send to MS SQL server? Something like MySQL's Query browser, or MS's own Enterprise manager. I do not need something fancy, I need to be able to run queries, and view the results.

- DbVisualizer: http://www.minq.se/products/dbvis/ * excellent * not opensource but has a (very capable) freeware version

- Squirrel SQL: http://www.squirrelsql.org/ * not near as fancy as DbVisualizer but still does its job well * GPL/LGPL

I used Squirrel as well for a time. It does a nice job of handling MSSQL, MySQL, Derby and Access (blech!) databases. -- kai www.perfectreign.com || www.4thedadz.com a turn signal is a statement, not a request -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org