Skip to Content
0
Former Member
Mar 19, 2009 at 01:57 PM

Crystal Reports 2008: Databse Connector Error: 42S02 [SQL Native Client]

256 Views

Hello

I have a stored procedure on MS SQL 2005 Server and I will use them in a report (set location). An "SQL Native Client" - Connection will be used.

On Crystal Report XI it works fine, but with Crystal Reports 2008 an error occurs (same ODBC, stored procedure and DB):

Error: 42S02 [SQL Native Client][SQL Server] Invalid object Name '#temp_table'.

In the procedure the temp table is created (create #temp_table ...) but the error comes when I will access the table

after some other code.

Can someone help me?

Best regards

Stephan