Results 1 to 5 of 5
  1. #1
    Join Date
    Nov 2003
    Posts
    18

    Unanswered: Crystal Reports 9 calling DB2 stored procedures

    I have DB2 V7.2 on Linux. I have written a stored procedure on the server. Calling it from my NT DB2 client works fine. But when I call it from Crystal Reports 9, it gives me SQL10113N The specified library <spname> could not be loaded. Have anybody experience this issue before?

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Do you know if Crystal Reports 9 supports calling DB2 Stored Procedures?
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  3. #3
    Join Date
    Jun 2001
    Posts
    20
    I had faced the same problem with DB2 v7.2 on Linux. Didn't face the problem after changing to DB2 v8.1

    Two questions

    1. What's the OS on which Crystal is running?
    2. What's the driver you are using? If its Windows, are you using ODBC or Native Driver
    Renga

  4. #4
    Join Date
    Nov 2003
    Posts
    18
    1) Crystal and DB2 client is on NT workstation.
    2) ODBC driver version 7.01.00.88 on d:\program files\sqllib\bin.
    It is installed by DB2 client.
    By the way, I have out parameters in my stored procedure.

  5. #5
    Join Date
    Jun 2001
    Posts
    20
    Hi,

    I dont think you can access out parameters from crystal.

    Crystal expects a result set. I have tried this in Crystal 8.5 and was unable to do it.
    Renga

Posting Permissions

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