Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2005
    Posts
    119

    Unanswered: Cannot create Crystal Report using a Stored Procedure with parameters

    Hi,

    Iíve been searching on why I canít create a Crystal Reports using a Stored Procedure (SP) with parameters. Iím encountering this error: Database Connector Error: Cannot obtain error message from server.

    I tried several scenarios, I can create the report using a Stored Procedure with parameters provided that these parameters are assigned a value inside the Stored Proc, or if these parameters (declared in the create proc line) are not used at all inside the Stored Proc.

    So, isolating the problem. I cannot create a report when the SP has parameters (declared in the create proc line), these parameters were not assigned a value, and these parameters are used.

    Is there a workaround here? Hope somebody can help. Thanks.

  2. #2
    Join Date
    Oct 2005
    Posts
    119
    I tried creating a new Stored Procedure with parameters and used these parameters inside my SP. And I was able to use this SP in my Crystal Report. So the problem is not about that SP w/ parameters. Kindly help me figure out what is this error about and how to fix this.

    Error: Database Connector Error: Cannot obtain error message from server.

Posting Permissions

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