ASP-SQL from Orbera Technologies

Beta 1 Documentation

1. What Is ASP-SQL?

ASP-SQL is a small ASP application that allows "SQL Monitor" access via ODBC and ASP.

2. Getting Started

To insall the application, place all the files in an IIS directory which has both read and script exececute permission. Point your browser at aspsql.asp to run the application. You must be running Version 5.0 or later of the MS Scripting Engines. You can download these from http://msdn.microsoft.com.

If you find when first running the application that you receive an asp error stating that JScript.Encode is not found on the server, reinstall the 5.0 scripting engine.

3. Using ASP-SQL

By entering a valid ADO Connection String, you may execute arbitrary SQL statements and obtain table information.

Multiple SQL statements must be separated by a semicolon.

When executing SQL, you may choose how errors and transactions are handled :

Errors

When entering multiple SQL statements you can choose to stop at the first error or continue regardless of errors.

Transaction Control

You can choose to turn transaction control ON, in which case ASP-SQL will invoke a transaction before your first SQL statement and commit after the last statement (or rollback if there were any errors). If you leave transaction control OFF (the default) then you are responsible for managing transactions by entering appropriate SQL transaction control statements.

 

 


4. Support and Comments

Customers may request support or pass on comments by emailing support@orbera.com