"No Resultset produced" when using temp tables in stored proc

I am using microsofts jdbc driver and I am trying to call a stored
procedure to get a resultset from SQL Server.
Usually this works fine when I select something from an ordinary table
but when I am involving a temp table in the final select statement I
do not get any resultset in return?
Lars wrote:

> I am using microsofts jdbc driver and I am trying to call a stored
> procedure to get a resultset from SQL Server.
> Usually this works fine when I select something from an ordinary table
> but when I am involving a temp table in the final select statement I
> do not get any resultset in return?
I believe the result set *does* come back, but your other stuff in the
procedure before the final select will also be returning update counts etc,
so you need to loop to handle all the update counts as well, before
getResultSet() will find the returned data.
Joe Weinstein at BEA

"List of Values Failure" error in CR

I have designed a Crystal report from an ODBC connection. But recently I was asked to change the connection to JDBC. The data is from an SQL database. I have set the database location to JDBC from crystal report program. Everytime I preview the resuls I get the following error message.

"Prompting failed with the following error message: 'List of Values failure: fail to get values. [Cause of error: Failed to open connection. Failed to open the connection. UNKNOWN.rpt']. Error source: prompt.dll Error code: 0x8004380D."

Please help.Goto Database and Set Location and set the path
Do verify Database also