ODBC Error

[j***@sentinel.com]

I'm trying to build a report using InfoMaker 10 and Microsoft SQL
Server 2000, using an anonymous block which will create a couple of
temp tables, one of which is called #ST1.

After I enter the sql, on returning to the main InfoMaker screen I get

Database error:

SQLSTATE = S0002
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name
'#ST1'.

There are other reports in the library which use this technique, and
they work ok; but if I try to modify their SQL code in any way, even
by adding a single space, I get the same error.

Fwiw, the SQL works ok in MS Query Analyzer.

Does anyone have any suggestions?

Thanks,

Jim

Jim Puls
Sentinel Technologies

[John Olson [Team Sybase]]

Did you upgrade your InfoMaker and/or MS SQLServer after creating the ones
that currently work? It sounds like a syntax problem where maybe that isn't
supported anymore. Try exporting the DW syntax of the DWs that work and the
one that doesn't. Compare the syntax to find out what is different. If you
find the difference you could potentially get this new DW working by
changing the syntax in a text editor then importing it into your PBL.

Regards,
John

Post by j***@sentinel.com
I'm trying to build a report using InfoMaker 10 and Microsoft SQL
Server 2000, using an anonymous block which will create a couple of
temp tables, one of which is called #ST1.
After I enter the sql, on returning to the main InfoMaker screen I get
SQLSTATE = S0002
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name
'#ST1'.
There are other reports in the library which use this technique, and
they work ok; but if I try to modify their SQL code in any way, even
by adding a single space, I get the same error.
Fwiw, the SQL works ok in MS Query Analyzer.
Does anyone have any suggestions?
Thanks,
Jim
Jim Puls
Sentinel Technologies