Where to save the config values in classic asp.

Suppose you want to store the Connection string in classic asp.Follow the steps bellow.

1.In your application there should be a Global.asa file.
2.Please store the connection string  in Global.asa file

Sub Application_OnStart
Application("ConnString") = "put your connection string here"
End Sub

3.How to access the key in classic asp
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open Application("ConnString")

How to execute a stored procedure with output parameter.

Following is the stored procedure with output parameter.

CREATE PROCEDURE OUTParaMeterProcedure
(
@OutName NVARCHAR(MAX) OUT
)
AS
BEGIN
SET @OutName='Sibasis'
END

Please execute the procedure with following way.

DECLARE @Name NVARCHAR(MAX)
EXEC OUTParaMeterProcedure @OutName=@Name OUT

If you want to view the result then print the result