After installing OBIEE11g on windows 64 bit installation, the ODBC System DSN is set with a wrong driver file path on Microsoft Windows x64 with the following details.
Driver=..<MW_HOME>\Oracle_BI1\bifoundation\server\bin\NQSODBC.dll
Actually the installer should set the DSN driver to nqsodbc64.dll, rather the installer sets it to nqsodbc.dll, which does not exist on the disk.
So for this go to registry editor and change the driver to nqsodbc64.dll instead of nqsodbc.dll.
- Go to start-> Run -> type regedit
- Go to HKEY_LOCAL_MACHINE
->SOFTWARES
->ODBC
->ODBC.INI
-> coreapplication_XXXXXX
In left side window you will see all attributes for this application. In that double click on Driver attribute.It will popup an Edit string window. In that for Value data change the dll file version to NQSODBC64.dll from NQSODBC.dll and Click Ok to save this change.
3. Go to HKEY_LOCAL_MACHINE
->SOFTWARES
->ODBC
->ODBCINST.INI
-> Oracle BI Server11g_XXXXXX
i) In left side window you will see all attributes for this application. In that double click on Driver attribute.It will popup an Edit string window. In that for Value data change the dll file version to NQSODBC64.dll from NQSODBC.dll and Click Ok to save this change.
ii) Again In left side window double click on Setup attribute.It will popup an Edit string window. In that for Value data change the dll file version to nqssetup64.dll from nqssetup.dll and Click Ok to save this change.
The DSN driver setting has no functional impact and hence can be ignored.
Thanks,
Shiva
Dimitris
September 30, 2010 at 3:02 pm
Hi,
really nice tip.But in my case it does not work.
I have installed oracle bi 11g in windows server 2008 R2 64.
Everything work ok except from the admin tool.Any help??
tnks in advance!!!
Shiva Molabanti
October 8, 2010 at 3:10 pm
On 64-bit Operating systems we could not open OBIEE11g client tools.It is a bug in OBIEE11g.
Oracle will fix this in next release.
Thanks,
Shiva
Kijang
October 8, 2010 at 10:11 am
Hi Shiva,
I already have the same value for step 3, and so I just change the value in step 2. However, I noticed that everytime I start BI Services, the registry looks like write back to old value (nqsodbc.dll).
Do you, by chance, know any other solution, i.e. change config file (.ini) rather than registry?
Thanks for your informative post and thanks for your response.
Shiva Molabanti
October 8, 2010 at 3:13 pm
Even we change in any config files again the ODBC communication is depends on the dll files used by Operating systems. At the same time you should be the part of Administrators group on windows to change the registry entry .
Thanks,
Shiva
kaupind
January 26, 2011 at 4:44 pm
Hello Shiva,
Understanding you are SME in this field, I am trying to install OBIEE 11g
on 8GB & i7 processor (64bit) do you think i need to modify before installation as system requirment is 32 bit but in you past notification you have mention oracle will fix in next realase
Please confirm.
thanks
Musa
February 2, 2011 at 12:03 pm
Hi,
Did you have to do any deviations from the standard Install for OBIEE 11? Like install the JDK seperately, etc?
Sohail Nawaz
July 10, 2011 at 12:05 pm
Hi Shiva,
I have installted OBIEE 11g in Windows 2008 R2 64-bit server, its working fine, even Admin Tool is also working fine, I am facing problem with Excel sheet. I want to add Excel sheet as a data source. its working from Admin Client Tool 32 bit. But when i am loding repository in BI Server (Window 2008 R2 64-bit) then its not working please advice me.
Regards
Sohail
Mohammed Sameeruddin
October 10, 2011 at 12:10 pm
How to import excel files in OBIEE?
Solution
Please follow this link : http://www.oraclenerd.com/2011/01/obiee-import-excel-file-as-source.html
Ed
November 14, 2011 at 12:09 pm
This is because You’ve not set up the Excel File in the 64bit version of the ODBC driver (Located in C:\Windows\SysWOW64\odbcad32). It works on the Admin Client because its 32 Bit looking at the 32 bit driver.
When you load on to the server, It can’t see the driver because it’s looking at the 64bit ODBC. Simple solution re-build the driver with the EXACT same same names and setting in the 32bit version and it should work on both Admin tool and the Server.
Regards
Ed
Sohail Nawaz
July 10, 2011 at 12:07 pm
I follow the above steps, even its not working. Please give me any solution
Regards
Sohail
aneel
September 20, 2011 at 7:04 pm
Hi support,
I had installed OBIEE11g in window’s 7 32bits,but im unable to start services and Administrator Tool of RCU.if im try to start BI services it is disabling in nano seconds.Im not able to open RCU.presentation services are working gud.could pls tell me suggestions.
Thank’s in Advance
Anil