Sybase database stored procedure call problem RRS feed

  • Question

  • Hi,

    I am trying to call a very simple stored procedure in Sybase but I am not able to get the result set. Store procedure is very simple and it only selects rows from database. Following is more information:

    1. Connection String:
      Provider='Sybase.ASEOLEDBProvider.2'; Initial Catalog=MyCatalog;   
      User ID=myUser;Data Source=My Source;Password=MyPass"
    2. I have privileges to access Stored Procedure.
    3. I have tried with both .NET 1.1 and 2.0
    4. Interesting is that I can use the same Stored Procedure in Crystal Report and it gives me the desired output.
    5. I am getting No Exceptions in this call.
    6. I am using OleDB classes to access the database.

    Please give me any idea to how solve this problem.


    Interface Mirror
    Thursday, March 5, 2009 5:01 AM

All replies

  • Can you post the code that shows how you call this SP?
    Val Mazur (MVP) http://www.xporttools.net
    Thursday, March 5, 2009 10:57 AM