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

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

    Hi!

    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

    cmd.Parameters.Append(cmd.CreateParameter(etc.))?

  2. #2
    Join Date
    Sep 2003
    Posts
    14
    Hey,

    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')"

    Reg
    Usha

Posting Permissions

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