Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
drewsalem
Constraint Violating Yak Guru
304 Posts |
 Posted - 2005-12-05 : 08:01:42
|
| Greetings from Tahiti,One of my users wants to query a couple of tables.I need a web based tool that will allow one of my users to query on some tables. All the existing tools out there appear to offer a wealth of administration bells and whistles. I just want a simple query tool that he can access via the web and not have to install on his machine.Any suggestions?Thanks,Drew |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
Srinika
Master Smack Fu Yak Hacker
1378 Posts |
Posted - 2005-12-05 : 15:11:21
|
| drewsalem,1. Do ur users know SQL (I mean to write queries as in Query Analyzer)?If not the application may be a bit complex, the table names / field names r to be selected, the query should be built with the conditions given, users should know the effect of "OR", "AND" and brackets. Still the Query should be parsed for syntax check etc etc.2. Do u mind users doing all SQL operations as Insert / Update / Delete / Drop Table ... in addition to Selecting ?If not one can create a simple application using ASP, create a User with only Select priviledges (db_reader) and use ADO to give the results on a table (as a office Web Component) or as text |
 |
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2005-12-05 : 15:56:08
|
| *DISCLAIMER* I don't think this is a good idea in general, but if you have proper security set up it should be ok.1. be sure that the SQL user account he uses has READ ONLY access to the tables2. Create a simple form in ASP.NET: 1) add 3 text boxes, labelled: UserName, Password, SQL (make the SQL one big, multi-line) 2) add a button 3) add a datagrid3. On the button's click event, simply the app execute the SQL in the text box against the database (using the username/password provided) and bind the results to the datagrid. 4. Repeat as necessary.Voila ! A simple, ugly, web interface into SQL Server.*DISCLAIMER* I don't think this is a good idea in general, but if you have proper security set up it should be ok. |
|
|
|
|
|
|
|
|
Simple web based query analyzer needed