OBIEE — MSSQL server anomalies Part I

OBIEE — MSSQL server anomalies:

In a recent project I had a chance to work extensively with integrating OBIEE with MS SQL Server.
MS SQL Server – 2008 R2
OBIEE – BP1 on Windows 64 Bit, Oracle Linux
We had several issues with this combination and would like to document some here in this forum:
OBIEE comes bundled with the following ODBC drivers: DataDirect 6.0 SQL Server Native Wire Protocol (On Windows)
This is the


Sign up today & get $10k worth of free dbaas assesssmentRegister Now
+ +