Seagate Info and SQL Server Stored Procedure

[Fahim]

Hi
I have a crystal report that has a stored procedure as a data source. There are two date parameters I am passing as string. The report runs fine in CR 7.0. When I add the report to Seagate Info 7.0 the report does not return any data. I ran a trace on SQL Server and found that Seagate Info passes the parameters as NULL.
Are Stored Procedures with Parameters supported in Seagate Info 7.0?
Any help will be appreciated.
Thanks
Fahim

 

[synapsevampire]

Sure they were supported. Although SI 7 no longer is by BO. Could be a known issue that a service pack resolved, but I doubt that you can find them now.

Perhaps you have different connectivity in SI?

Try putting CR 7 on the SI server and see if it runs there.

http://support.businessobjects.com/communityCS/TechnicalPapers/storproc.pdf.asp

-k

 

[Fahim]

I was using the PDsSQL.dll driver. I changed to PDsODBC.dll and created a DSN. It worked. Maybe it is a bug in SI.
Thanks for your reply