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

[Former Member]

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!

[former_member11696 · Accepted solution]

Hello,

CR 10 does not support the MS SQL Native Driver, if you want to use OLE DB then use the MS OLE DB Provider for SQL Server up to SQL 2005. SQL 2008 does not support the MDAC version so you have to install the SQL 2008 Client tools to use the SQL Native 10 driver. CR 10 does not support that Native 10 Driver.

See this MS Kbase: http://msdn.microsoft.com/en-us/library/ms131035.aspx

Convert back to the old driver for 2005 and then use ODBC if using SQL 2008, it should work...

Don

[Former Member · Accepted solution]

Thank your very much Don! Appreciated your help.

I'll try as you suggested.

[Former Member · Accepted solution]

Hi Don,

Thank you again for your suggestion.

I've tried to convert back to the old driver for 2000 and then use ODBC, it worked...

Dina