andyd70
asked on
IB/Firebird Stored Procedures in ASP.
I am using the IBPhoenix ODBC Driver.
I have a Simple Stored Procedure
CREATE PROCEDURE GET_GUID
RETURNS (
SGUID CHAR (38))
AS
declare variable s CHAR(38);
BEGIN
S = '{';
s= '{' || GUID_CREATE() ||'}';
SGUID = S;
END
Which creates a GUID.
I am trying to access this from an ASP Site with no luck.
My Asp Code look like.
connect = "data source=wsi;user id=SYSDBA;password=masterk ey"
Dim guid
set Conn = Server.CreateObject("ADODB .Connectio n")
Conn.Open Connect
Set sp = Server.CreateObject("ADODB .Command")
sp.ActiveConnection = Connect
sp.CommandType = adCmdStoredProc
sp.CommandText = "execute Procedure GET_GUID"
sp.Parameters.append sp.Createparameter(":SGUID ", adChar,adParamOutput)
sp.Execute
guid = sp("SGUID")
I cannot seem to access the Returned Value. Please tell me what I am doing wrong.
I have a Simple Stored Procedure
CREATE PROCEDURE GET_GUID
RETURNS (
SGUID CHAR (38))
AS
declare variable s CHAR(38);
BEGIN
S = '{';
s= '{' || GUID_CREATE() ||'}';
SGUID = S;
END
Which creates a GUID.
I am trying to access this from an ASP Site with no luck.
My Asp Code look like.
connect = "data source=wsi;user id=SYSDBA;password=masterk
Dim guid
set Conn = Server.CreateObject("ADODB
Conn.Open Connect
Set sp = Server.CreateObject("ADODB
sp.ActiveConnection = Connect
sp.CommandType = adCmdStoredProc
sp.CommandText = "execute Procedure GET_GUID"
sp.Parameters.append sp.Createparameter(":SGUID
sp.Execute
guid = sp("SGUID")
I cannot seem to access the Returned Value. Please tell me what I am doing wrong.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.