Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2002

    Unanswered: Stored Procedures using OLE DB driver for Sybase ASE 12.5 through ADO


    I'm wondering if anyone got around running stored procedures directly through the ADO controls, withing the need of the explicit parameter append calls.

    I have something like this.

    Dim cmd as ADODB.Command, rs ad ADODB.RecordSet
    cmd.ActiveConnection = GetConnectionString()
    cmd.CommandType = adCmdText
    cmd.CommandText = "sp_DoSomething 1,2,'varcharparam'"
    cmd.Prepared = True

    rs.CursorLocation = adUseClient
    rs.Open cmd, , adOpenForwardOnly, adLockReadOnly

    When this is run, it returns the following error

    [Native Error code: 203]
    [DataDirect ADO Sybase Provider] The name 'sp_DoSomething 1,2,'varcharparam'' is not a valid identifier.

    The code was running fine on Sybase ASE 12.0, but the error appeared once I've upgraded to ASE 12.5.

    Anyone know if there are any settings that gets this working, besides needing to resolve to


  2. #2
    Join Date
    Sep 2003

    I faced the same problem too. I am not sure if what ever
    I suggest is the solution to your problem. But it worked fine
    for a C++ Client. Try calling the stored procedure as

    cmd.CommandText = "sp_DoSomething (1,2,'varcharparam')"


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts