BI Administration Tool ODBC issue — Oracle Analytics

Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

BI Administration Tool ODBC issue

Received Response
21
Views
4
Comments
Sher Ullah Baig
Sher Ullah Baig Rank 3 - Community Apprentice

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:

odbc Registry.png

Regards

Answers