Oracle BI Answers Direct Database Request issue

環境： Oracle BIEE 10.1,   sql server 2000

問題描述： 在OBIEE Answers介面建立資料庫直接請求，其中連線池設定為:  [stat].[connection pool]出現錯誤提示：error : Odbc driver returned an error (SQLExecDirectW).
error : State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 27022] Unresolved Connection Pool object: "[stat].[connection pool]". (HY000)
error : SQL Issued: {call NQSGetQueryColumnInfo('EXECUTE PHYSICAL CONNECTION POOL "[stat].[connection pool]" select * from t_gate')}

顯示出無法解析連線池物件。

解決方法：將連線池設定為"stat"."connection pool"，一定要加上雙引號。