ODBC stored proc polling with temporary tables

by Anupama Nair

Dec 14, 2020

We have set up an ODBC adapter to poll a stored proc.

We found that if the stored proc has a temporary table defined the rows returned are always 0.

Any idea why this would be and what we can do to get around it?

  • up

    Joe Klug

    Which vendor is the database? What is the stored procedure code?  Does this code work outside of the ODBC adapter, like in SQL Server Management Studio?

    2

    Dec 17, 2020