Connecting to an external table in 9.X gives the error: Function sequence error.

Version 1

    Details

    Attempting to connect to an External Table in 9.X Edit Set and you get the following error:

    Function sequence error

    Last SQL String:

    SELECT SCHEMA_NAME() AS CURRENT_SCHEMA

    Last ODBC Command:

    Function: SQLGetData(Column: 1, Type: 1)

     


    Resolution

    Cause
    External Table resides in a database on SQL 2000 server which is not compatible with HEAT 9.X versions.


    Resolution
    Upgrade the SQL Server to at minimum SQL 2005 where this external table resides.