Program crashes while executing a query using "TTU 12.0 SOLARIS-x8664 tdodbc.12.00.00.01" client on Solaris Intel platform
I have installed teradata ODBC client "TTU 12.0 SOLARIS-x8664 tdodbc.12.00.00.01" on Solaris Intel platform. The driver got installed correctly. And with other configurations (like LD_LIBRARY_PATH setting and ~/.odbc.ini configuration), I am able to connect to a teradata database and execute queries using the sample c++ program provided with the teradata client package.
Now my problem is, In a trial program written by me, I am trying to access this client through another third-party software "SQLAPI". In this case, I am able to connect to the a teradata database, but when I try to execute a query, the program crashes with a segmentation fault.
On the similar lines, I installed teradata ODBC client "TTU 13.0 LINUX-INDEP tdodbc.13.00.00.02" on Suse Linux platform and tried to execute a query on a teradata database using SQLAPI thirdparty library, it is working fine. Now, I am puzzled, why it is not working with this driver on Solaris Intel? Any known isues, anyone would like to share?
Moreover, using third-party library SQLAPI, I am able to connect to oracle database and execute the queries on both the platforms Suse Linux as well as Solaris Intel.
So, it seems there is some issue with "TTU 12.0 SOLARIS-x8664 tdodbc.12.00.00.01" on Solaris Intel platform (should I try any other driver, please suggest which one) or this solaris teradata odbc driver is not perfectly compatible with SQLAPI third-party library on Solaris Intel platform or I am missing some configuration.
Re: Program crashes while executing a query using "TTU 12.0 SOLARIS-x8664 tdodbc.12.00.00.01" client on Solaris Intel platform
The 12.0 ODBC version you are using is pretty old. Currently, we are only supporting bug fixes for 13.0 and 13.10 products. Your best option is going to be to use the 13.0 ODBC version. Keep in mind that these products are Backward compatible with older versions of the Teradata Database.