Hello!
Currently, I'm using existing "DataDirect 7.1.4 SQL Server Wire Protocol" as a ODBC Driver to connect SQL Server database in my linux server.
I tried to create a simple report on OBIEE Answers, but it always throws an ODBC Driver error. After, I made few changes at Administration tool - Phyiscal layer in features tab, I unchecked below defaults boxes for SQL then it started working fine with the report results and I can see the data.
1) DISTINCT_SUPPORTED
2) ORDERBY_SUPPORTED
3) EXPRESSIONS_IN_ORDERBY_SUPPORTED
4) IDENTIFIER_QUOTE_CHAR
I think this might be the driver issue. Please help me with the steps, how to Configure ODBC Driver with the SQL Server Native Client 11.0 in Linux Server.
Appreciated your help!
Thanks,
Jithendra