BI Administration Tool ODBC issue

Question

Hi All,

I am trying to create Connection pool in my repository for MS Excel Files so i am trying to create ODBC System DNS connection,

but when i run ODBC wizard i can NOT See MS Excel Driver.

Once i check, I found out BI Admin tool is takeing ODBC from "C:\Windows\System32" BUT MS Excel Driver is available in "C:\Windows\SysWOW64"

So how am i going to direct BI Admin Tool to take ODBC from "C:\Windows\SysWOW64" NOT from  "C:\Windows\System32"

Windows Registry:

Regards

Sher Ullah Baig · Answer

Thanks Thoms this resolved my issue. A followup question, Do i need to perform any Configuration on Linux Server to read Excel File ? i saw some blogs but couldn't understand them well.

Thanks agian

Thomas Dodds · Answer

Did you try something like this?  http://hostilecoding.blogspot.com/2012/10/obiee-how-to-import-data-from-excel-on.html

Sher Ullah Baig · Answer

Hi Thomas,

Thanks i tired but problem is that BI Admin Tool is by default picking DNS Connection from "Windows\System32\odbcad32.exe"

I want to tell BI Tool to Pick DNS Connection from here "windowns\SysWOW64\odbcad32.exe"

Regards

sher