Crystal & SQL Server Stored Procedures

[MrMystery]

I have a Crystal 8 report which connects to a SQL Server 7 stored procedure.
It works fine when I run it from my own desktop, but when I place it on our intranet, where it is run via Internet Explorer / Crystal Report viewer DLL, it returns an error;
"Error detected by Database DLL". If I change the report to connect to an SQL 'view' instead, it works ok.
Can anyone shed any light on this?

 

[pgtek]

hi

have you tried saving your report with data?

cheers



pgtek

 

[synapsevampire]

Might be the connectivity used, try changing to a different type.

If ODBC, try native, if native, try ODBC.

Also make sure that you apply the hotfixes:

http://support.crystaldecisions.com/search/advsearch.asp?ref=default.asp_selectlist

-k

 

[Rob22]

Check the permissions of the login id you are using to access the SQL Server. You may need to give the login you are using the proper rights to execute the stored procedure.

Rob