SQL Server RPC to Sybase via ODBC example

  • Does anyone have an example of how to issue and RPC call from SQL Server 2000 to Sybase 12.5 via an ODBC connection.  I get the following error when running

    "exec servername.dbname.db.myproc '123'

    No return status or output parameters will be returned from this stored procedure unless you use only parameter markers to pass parameter values.]

  • "{call myproc ?}"

     

    ? param that you have to pass


    Kindest Regards,

    Vasc

  • {call ?=myproc ?}

    this is if you want the result of sp

     


    Kindest Regards,

    Vasc

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply