I have the server address and login info, what utility can I use to access my database and run SQL querys?

8/3/2005 1:32:19 PM

Oracle's SQL Plus should do the trick, pretty sure that is free. TOAD is another I remember offhand but you would have to just use the shareware trial.

8/3/2005 1:37:21 PM

can you SSH into the server?

That is the easiest way possible.

Else, http://www.mobiustech.net/qtsql/

8/3/2005 1:39:29 PM

ps - doing this on a windows machine would be grrrreat

8/3/2005 2:03:45 PM

when I took CSC 440 (Databases), we used Squirrel SQL, its a sourceforge project

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

From what I remember, I got it working with Microsoft SQL Server 2000, MySQL, and Oracle 9i

8/3/2005 2:14:27 PM

obligatory "google, motherfucker"

8/3/2005 6:18:18 PM

You could write some VBA code in Excel and use DAO

8/3/2005 10:04:42 PM

access

8/3/2005 10:05:55 PM

six responses to synapse, and the question, "what database is the server running?" has not come up yet.

8/3/2005 10:51:03 PM

That's cuz he clearly doesn't have SSH or terminal access

and he basically needs a frontend to connect to the database server using ODBC/JDBC.

8/4/2005 1:27:55 AM

I use DBTools Pro for all non-mssql servers, and MS SQL Enterprise manager for all MSSQL servers.

8/4/2005 7:35:52 AM

I ended up using the Query Analyzer tool included with MS SQL Server, works perfectly

Query Express looks like a quick and easy standalone product too, would have used that if I didn't have a SQL Server install disk.

8/5/2005 9:09:13 AM