I have a procedure called Validateloginbyuserpass that I need to call in 
ASP.  It needs a username and password and it returns values.  Here is 
what I have so far:
_______
Username="jenny"
Userpassword="jennypassword"
Dim orst,conn
Set orst=Server.CreateObject("ADODB.recordset")
Set conn=Server.CreateObject("ADODB.connection")
conn.Open "DSN=ACCE; uid=username; pwd=password"
CmdText= "Validateloginbyuserpass '" & Username & "', '" &Userpassword &"'"
orst.open cmdtext, conn

Response.write orst("P_First_Nm") 'write user first name given a login
_____

When I run this page I get a query error.  How can I call this procedure 
correctly?  Here are the parameters in the procedure:

PROCEDURE VALIDATELOGINBYUSERPASS (Login with Username/Password 
Combination)
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 P_LOGIN_ID                     VARCHAR2(200)           IN
 P_PASSWD                       VARCHAR2(30)            IN
 P_CUST_ID                      VARCHAR2(10)            OUT
 P_FIRST_NM                     VARCHAR2(30)            OUT
 P_LAST_NM                      VARCHAR2(30)            OUT
 P_HASH_CD                      VARCHAR2(30)            OUT
 P_EMAIL                        VARCHAR2(2000)          OUT
 P_AUTH_ROLE                    VARCHAR2                OUT
 P_RESULT                       VARCHAR2                OUT
 P_RESULT_MSG                   VARCHAR2                OUT
 
Thanks for any help,
Anh Do
anhdo@a...