ASP Alliance Member: MTG

ASP Query Analyzer

For those of you who don't know what a Query Analyzer is: it's a client application that allows SQL commands to be performed against a data store. The data store can be any OLE DB/ODBC compatible store such as MS-SQL Server, MS-Access, Oracle, mySQL, etc.

If you are familiar with SQL Server 7.0 then are most likely familiar with the SQL Server Query Analyzer. This handy client tool allows you to perform DELETE, INSERT, UPDATE, SELECT, EXEC, and more SQL commands which result in the application returning status, recordset, and other types of information. If you are familiar with Access then you are most likely familiar with the Query\Run (!) feature which allows you to run queries on the fly.

Until now, I haven't seen a Query Analyzer designed in ASP.

I have created one and you can download it by clicking here. It's a self-extracting executable that contains the ASP file called tsql.asp.

The TSQL.asp Application is pretty simple to use:

Enter a Connection String:
For a SQL Server connection you would type:
Provider=SQLOLEDB;Data Source=Computer_Name;Initial Catalog=Database_Name;User Id=User_Name;Password=Password
For a System DSN using ODBC you would type:
DSN=DSN_Name
For a File DSN using ODBC you would type:
FILEDSN=File_Name.dsn
For a MS-Access Database Connection you would type:
Drive={Microsoft Access Driver (*.mdb)};DBQ=Database_File_Name
Enter the SQL commands in the text area
When you are done with both areas click on the Execute Script button.

The TSQL.asp file should be stored on a web site directory hosted by an IIS 3/4 server in order for it to work correctly.

Technical Notes: This ASP Query Analyzer is designed to work with ADO version 2.0 or later. If this application doesn't work properly, download the latest ADO version by downloading Microsoft's latest MDAC (Microsoft Data Access Components) by cliking here.

Start using the TSQL.asp Query Analyzer NOW!

Comments & Questions Form Comment(s):