Very Computer

Hi,

        How do you call a stored procedure in Sybase 10 through MS RDO?  
        On the Sybase server, you can type

EXEC OPR_ACN_QUERY '0181-63931'
GO

        and get some results.

I have tried two ways of getting a rdoResultset, with varying degrees of
failure.  

(1) Calling the stored procedure as the source argument of my
rdoConnections(0).OpenResultset call

    Dim results As rdoResultset

    On Error GoTo DataRetrievalErrorHandler

    Set results = rdoEnvironments(0).rdoConnections(0).OpenResultset( _
        "EXEC OPR_ACN_QUERY '0181-63931'", _
        rdOpenForwardOnly, rdConcurReadOnly)

The results.RowCount is "-1" meaning that the number of rows returned is
"not available".      

(2) As a Prepared Statement

    Dim prep_stmt As rdoPreparedStatement
    Dim query As String

    query = "{ call OPR_ACN_QUERY ( ? ) }"

    Set prep_stmt =
rdoEnvironments(0).rdoConnections(0).CreatePreparedStatement("ACN_Query",
query)

    prep_stmt.rdoParameters(0) = "' 0181-6391' "
    Set results = prep_stmt.OpenResultset(rdOpenForwardOnly,
rdConcurReadOnly)

        The ODBC driver reports that there is a syntax error in this case.

I' d appreciate any help.  Thanks.

--

In your first method
The fact that the rowcount is unavailable does not surprise me. The
rowcount may not be known until you transfer all the rows to the client PC.
With a forward only cursor this won't happen until you have read all the
rows into your application. If you change to a static cursor then the ODBC
driver will buffer rows for you and it _may_ know the rowcount earlier.

NOTE You should use the rdExecDirect option when opening a resultset
directly from the connection object. If you don't do this RDO will create a
stored procedure with which to execute your SQL statement. This will slow
down execution.

In your second method

Quote:>     prep_stmt.rdoParameters(0) = "' 0181-6391' "