Using .NET ODBC with mutiple queries

Hi

The following statement works fine in Hana Studio:

CREATE LOCAL TEMPORARY  table #prc as (select '1' AS Test from dummy);SELECT * FROM #prc;DROP TABLE #prc

But when executed via the .NET Odbc Driver it doesn't work.

Looks like the driver doesn't like multiple queries.

When using the SqlClient (Micorsoft) it works.

Do i miss something?

Thanks for any enlightment.

Philipp