Calling a store procedure from vb6 with sql server 
Author Message
 Calling a store procedure from vb6 with sql server

HI ALL !,i try to calling a store procedure from vb6 with sql server(7/2000) and
i receive this error message "no open cursor or cursor close",please send your

 this is the definition of my store proc.

-----------------------------------------------------
the store proc should return the square of a number
-----------------------------------------------------
CREATE PROCEDURE SP_CARRER


         AS


        RETURN
---------------------------------------------------
This is the code for calling the store proc
---------------------------------------------------
 Dim sqlstr As String
 Dim localrs As rdoResultset

  On Error GoTo Error_Handler:

    Cn.Connect = "uid=sa" & ";pwd=" & ";server=SQLServerName"
    & ";driver={SQL Server};database=" & SQLDataBase & ";DSN='';"
    Cn.CursorDriver = rdUseOdbc
    Cn.EstablishConnection (rdDriverNoPrompt)





  Set localrs = Cn.OpenResultset(sqlstr, rdOpenKeyset, rdConcurValues)

  If Not localrs.EOF Then

  MsgBox "reponse = " & CStr(localrs.rdoColumns(0).Value)

  End If
----------------------------------------------------------------------



Sat, 04 Oct 2003 23:56:13 GMT
 
 [ 1 post ] 

 Relevant Pages 

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

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

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

4. Calling Oracle Stored Procedure from within SQL Server Stored Procedure

5. Calling Stored Procedure that calls Stored Procedure in ASP

6. Calling a stored procedure on another server from within a stored procedure

7. How to call an Oracle Stored procedure from MSSQL Server Stored Procedure

8. Calling Java Stored Procedure from SQL Stored Procedure

9. VB6 code with ADO to call Storeed Procedure on SQL Server 2000

10. Calling a Java Stored Procedure from another Java Stored Stored Procedure

11. VB6 call to Access2000 stored procedure

12. How did I call a store procedure by using VB6 DAO connection


 
Powered by phpBB® Forum Software