ODBCOpenEx function for IBM Planning Analytics (TM1)

    Where can the ODBCOpenEx function be used?

      Which TM1 Server version is the ODBCOpenEx function available for?

        What is the syntax for ODBCOpenEx?

        • ​​Source = ODBC data source name
        • Client = user on the data source
        • Password = password for the client
        • UseUnicodeODBC = flag to use Unicode interface, 1 is true.

        Relevant Functions

        • ODBCClose = Closes an ODBC connection
        • ODBCOpen = Opens a connection between TM1 to an ODBC database
        • ODBCOpenEx = Opens an ODBC data source for output specifying that the connection should be opened as a Unicode connection
        • ODBCOutput = Executes a SQL query from TM1 to an ODBC database. Used in conjunction with ODBCOpen
        • SetODBCUnicodeInterface = Sets whether the ODBC interface should use the Unicode wide functions or the regular single-byte character functions