SQL Server Temp Tables Item not found Crystal Report 9

[donly1k]

I have a Visual Basic Application that creates temp table for Crystal to use.

It is currently working with Crystal version 9. We are updating servers where the Temp tables resides so the location has changed.

The problem is that when I add the new connection using OLE to connect to the database, the temp tables do not appear in the list even though when I look in the DB they are there. See example below.

Do you know of any reason why this would happen and if there is any work around?

Thanks in advance for all your help.

SQL Sever 2000 Tempdb Table
dbo.##T_MyTable_1
dbo.##T_MyTable_2
dbo.##T_MyTable_3

Current Set Datasource Location Tempdb Server38
dbo.##T_MyTable_1
dbo.##T_MyTable_2
dbo.##T_MyTable_3


New Connection to "Set Datasource Location Tempdb Sever15"
dbo
.... No items found ....

 

[vidru]

You might be better off using stored procedures to return the data from your temp tables, or you might try using a Command. In any case, here's a whitepaper that discusses using local and global temp tables in stored procedures w/CR:

http://support.businessobjects.com/library/kbase/articles/c2005680.asp

-dave