Visual Basic Crystal Reports - SQL Server Temp Tables Item not found Crystal Report 9

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

SQL Server Temp Tables Item not found Crystal Report 9

Karlene

2005-06-06, 4:01 pm

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 ....

NewKidOnDBlock

Sponsored Links