Report Viewer in IIS

[MrMystery]

I am running IIS on Windows NT 4 Server.
I have a copy of Crystal Reports 8 installed on the same server.
I have an HTML page which links to a Crystal Report.
The Crystal report is linked to an SQL server 'view'.
I load up Internet Explorer and connect to the web page, click on the link and the Crystal Reports viewer loads in the browser, and the report works perfectly.
However, a similar report which is linked to an SQL Stored Procedure returns a 'DLL Error'.
I have tried creating an SQL view with identical data selections as the stored procedure, and this works fine. Does anyone know why the stored procedure version is giving me problems?

 

[jmeckley]

It might be a driver issue. I had something similar when I created a SP conecting to a view which connected to Active Directory. If I used an ODBC connection for the report data source The errors went away. Before that I was using a native SQL Server connection.

Jason Meckley
Database Analyst
WITF

 

[MrMystery]

Thanks for your reply.
I have tried both the ODBC connection and the native SQL in the report.
Both give me the same error.
Any other ideas?

 

[jmeckley]

here is the document I used on crystals support page.
[tt]

http://support.crystaldecisions.com/communityCS/TechnicalPapers/scr_general_sql_server_error.pdf

[/tt]

Jason Meckley
Database Analyst
WITF