Skip to Content
0
Former Member
Sep 30, 2011 at 06:44 PM

Report fails on CE usin stored proc as data source and Native Client driver

12 Views

Iu2019m using Crystal Reports 10. I have a report with a stored procedure as data source. All my other reports using views as data source. Weu2019re upgrading db from SQL Server 2000 to 2008 and start using Native Client driver.

Thereu2019s no problem to generate this report from .rpt on my local PC. But got the following error message when generate from Crystal Enterprise:

Error Message: The table could not be found. File D:\Program Files\Crystal Decisions\Enterprise 10\Data\procSched\......reportjobserver\~tmp12c06c5641c4d50.rpt.

It looks like sth related to Native Client driver. It works if I change to use old native driver in DSN on CE server.

Any ideas/advises? Appreciated to your help!