HELP - ASP Calling SQL Server Stored procedure 
Author Message
 HELP - ASP Calling SQL Server Stored procedure

Can anyone help me get String output value from SQL Stored procedure.

Procedure is declared as:


And ASP code i tried is:

set MyConnection = Server.CreateObject("ADODB.Connection")
MyConnection.Open "DSN=LocalServer;UID=sa;PWD=;DATABASE=berza"

Set ExpandCmd = Server.CreateObject("ADODB.Command")
Set ExpandCmd.ActiveConnection = MyConnection
ExpandCmd.CommandText = "{call expand(?,?)}"

adParamInput)
adVarChar, adParamOutput)

Set ExpandRs = ExpandCmd.Execute

but I always got:
"The application has improperly defined a Parameter object"
becouse of the marked line.
Thanks



Sat, 08 Sep 2001 03:00:00 GMT  
 HELP - ASP Calling SQL Server Stored procedure
ExpandCmd.CommandText = "expand"


Sat, 08 Sep 2001 03:00:00 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. Calling SQL Server Store Procedure

2. Calling SQL Server Store Procedure

3. HELP: Calling Stored Procedure w/large output from VB6 (using SQL Server)

4. HELP: Calling Stored Procedure w/large output from VB6 (using SQL Server)

5. HELP: Calling Stored Procedure w/large output from VB6 (using SQL Server)

6. Calling stored SQL procedures from ASP

7. SQL Server Stored Procedures from ASP

8. accessing SQL Server 7 stored procedure from asp

9. Need Help In SQL Server - Store Procedure

10. ASP.net VB.Net Stored Procedures in SQL Server

11. Calling a SQL Server 2000 store procedure from MS-Access

12. Calling Crystal Report from VB, repo is based on Stored Procedure in Sql Server

 

 
Powered by phpBB® Forum Software