Free SQL Software?

[Kronix]

Another newbie question -

I'm looking for some simple (free, or shareware) SQL software that will help me write my SQL statements for my db. Is there a program that will connect with my (dbase) db and allow me to write in the SQL strings with some sort of GUI interface?

What does everyone else use? Up to this point, I've been manually typing in my strings by hand into ASP pages, but it's getting rather tedious as my operations become more complex.

Any suggestions?

[mendhak]

http://www.red-gate.com/index.asp

http://www.mysql.com
http://www.mysql.com/downloads/gui-mysqlgui.html



Not sure though, but it's worth a look.

[WiseGuy]

Here's what I use, it's very easy to use, and you can conncet to miltiple DBs.
The only thing you need to do is make an ODBC connection in windows.
If you don't know how just ask.

http://gpoulose.home.att.net/

It's a 70 days evaluation so lots of time to use!


The WiseGuy

[mendhak]

And you're bound to find the crack somewhere

[WiseGuy]

Here's another one, wich is a little more advanced I guezz, But I found a crack for this one so you'll have no problems with registration sh|t!

http://www.cardett.co.nz/aqt42.zip

It's called Advanced Query tool

and here's the crack (somewhere):


WiseGuy

[Kronix]

Thanks, all. I'll take a look at these options. Anything is better than doing it by hand.

[Kronix]

Hmm...

I've tried several of the programs mentioned, all with the same result - I can see the tables in my database, but when I click on one of them to expand the treeview (to see the fields), the program says "Please wait..." and locks up. Three different ones do it, so I'm guessing it's not a program problem.

Which means I must be messing up my DSN? This is all new to me, so I'm not entirely sure of the differences between User, System and File. From what I gather, a User DSN allows users to login to the db if they're at the same machine, a System DSN allows anyone to access the db (don't have to login) from the same machine, and a file DSN allows users to log in from a LAN, etc.

...am I close?

Anyhow, I chose System DSN, and I've selected dbase databases. I add the proper path, and everything looks great... except I can't seem to get any more info than just the table names.