Problem using RogueWave with SQLServer temp tables

[Lakshmi]

RogueWave : 2.21.
MSSQLServer : 6.5
VC : 6.0

I submit SQL to the ODBC using Roguewave call: myconnection.executeSQL(). The connection is valid. I could create / modify temporary tables (with prefix #).But when I use RWDBTable to check if this table exists, it fails (though the table exists).

// Temp table already created.
RWDBTable table = myconnection.database().table(temptablename);
if( table.exists( myconnection, TRUE ) )
{
...
}
//I can still use the table for inserts

The if statement returns false.

Thanks for any suggestions.