Login Script - ASP over ODBC

[marius.hole]

Hello.

I need to set up a login script with information for the users.

The problem is;

I have a script (user.asp) that queries a database over odbc.

http://intranett/print/user.asp?UserName=%username%

I need to include this script in the login information box, so the users may get information about how many pages they have printed and what the account balance is.

It is important that the users not can see or get the path of the script or the content of the script.

Is it possible to convert the asp script to a vbs?

--script start--

<%

If Request.QueryString("UserName") <> "" Then

set User = Request.QueryString("UserName")

Set rs = Server.CreateObject("ADODB.Recordset")

QUERY = "SELECT TotalPagesPrinted, Balance FROM UserQuotas WHERE UserName ='" + User +"'"

rs.Open QUERY, "PrintManagerPlus"

If (rs.EOF) Then

Response.Write "No information available for User: "+User+"<P> <P> <P> <P>"

Else

Response.Write "UserName: " & User & "<BR>"

Response.Write "Total Pages Printed: " & rs("TotalPagesPrinted") & "<BR>"

Response.Write "Balance: $" & rs("Balance") & "<BR>"

End If

rs.Close

End If

%>

--script stop--

I’m grateful for any answer or idea. Thanks in advance.

[fizban2]

is this a SQl or access DB on the backend? it could probably be converted to and vbs script, but then where would you run it from? call it through the asp page?