I am trying to add a Stored Procedure through the Database Expert to my report. My Tables and Views are working fine. I can see my Stored Procedures, but when I press "OK" on the Enter Value prompt, I get a Database Connector Error: 'Cannot obtain error message from server.' The Stored Procedure is not added to my report.
Alternatively, if I don't press okay but hit the "X" to close the Enter Value prompt, the Stored procedure is added to my report, but the table shows up blank.
I am using Crystal Report 2008 with Microsoft SQL Server 2005, and an ODBC connection (I have tried both SQL Server and SQL Native Client as drivers.
Has anyone experienced this before or know of a possible explanation?
Thank you in advance and hope this ends up helping someone else also!