Results 1 to 5 of 5
  1. #1
    Join Date
    Dec 2002
    Posts
    5

    Unanswered: SYBASE Stored Procedure Fails

    Hi I am using SYBASE ODBC DRIVER to connect to SYBASE SERVER ASE 11.9.2.
    The driver I am using is SYODASE.DLL with the latest EBF 10572.

    I've got a stored procedure in SYBASE SERVER,
    When I execute the stored procedure from MS Access using either DAO or ADO,
    it DOESN'T DO ANYTHING, meaning it's not performing the desired
    functionality.
    It used to work well when we were using a different driver (from MS) to
    connect to SYBASE SERVER, this problem started when we changed to this latest driver from SYBASE.
    I even included the WorkArounds2 value 25 in the connection string, but it doesn't work.

    Can anyone please help and let me know what I need to change with the new driver.

    Thanks in advance.

    Praveen.

  2. #2
    Join Date
    Feb 2002
    Location
    Willy is on vacation
    Posts
    1,208
    Hi praveenp,

    Intersting, have you got SET NOEXEC ON. Worth checking that out.

    Or simply run SET NO EXEC OFF when you call the Stored proc.

    Cheers
    Willy

  3. #3
    Join Date
    Sep 2002
    Location
    Hong Kong
    Posts
    159

    Re: SYBASE Stored Procedure Fails

    Hi,

    Check you can do something using this driver. This checks your SQL is really hitting the server.

    If so create a stored procedure with the same name that does the same thing. Checks to see if you can call the stored procedure. May be there's an error that's not being trapped or something.

    Richard.

  4. #4
    Join Date
    Dec 2002
    Posts
    5
    Hi,
    Thanks for your replies,
    But The stored procedure is already in production and I can't mess with that.
    I have set the option SET EXEC ON, still it doesn't work.

    I've got an insert statement in the stored procedure, it's into a table.
    The table has got two memo fields, will that cause any problems with the new driver ??

    Thank You.

  5. #5
    Join Date
    Sep 2002
    Location
    Hong Kong
    Posts
    159
    Originally posted by praveenp
    I've got an insert statement in the stored procedure, it's into a table.
    The table has got two memo fields, will that cause any problems with the new driver ??

    Thank You.
    Memo field, does that correspond to text, rather than char/varchar?

    How does the stored procedure insert the text?, Does it insert the row and then use writetext, or just a simple insert. How are you passing the text parameters to the stored procedure?

    Do you have an ODBC trace log or something that can be posted here?

    Richard.

Posting Permissions

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