After the Admin Client Only installation blog a lot of people asked me how to install the ODBC drivers on the same machine.
Here it is:
What you first need is the nqsodbc.dll file which is located under <Oracle_FMWHome>/bifoundation/server/bin or if you have installed it like I described under c:\Oracle\home\bifoundation\server\bin. As you have registered all the DLL’s in this directory this DLL should also be registered, so Windows knows of it and can use it.
- You have to have the Admin Tool installed
- if so you’ll find the DLL file in the directory you just installed the Admin Tool
- The DLL is also registered then, if you followed all the steps in my blog post
- Start regedit and make a backup of your registry for safety reasons
- You’ll have to add the two attached reg files to your registry
regedit /s ODBCDrivers.reg
regedit /s OracleBIServer11g.reg
/s stands for silent, you can of course just execute regedit
- Check whether regedit has added them under
Have fun and so long,Andreas
Hi
Can you reupload "ODBCDrivers.reg" & "OracleBIServer11g.reg" as i am unable to download from the links you provided.
Thanks
Raghava
Hi Raghava,
the files are uploaded as text files again. Problem was that the browser was not able to display .reg correctly.
Have fun and so long,
Andreas
Good to see you back online again Andreas!
Grusse John
http://obiee101.blogspot.com/
Hey John,
good to see you are still reading my blog, John !
Thanks for the welcome back and so long,
Hi Andreas,
I had the requiement to use Admintool in Windows 7 x64 and based on your technique : i works!
Only, there is 2 ODBC branches in registry that you have to document, so there is the one you pointed out and this one with exactly the same content :
[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBC.INI\....]
( Something strange with Microsoft...a surprise...not really ) They put ODBC 32 bits in SySWoW64 and ODBC 64 bits in system32.
Regards
Bruno
Hi Bruno,
thanks a lot for your comment. That are great news that 64 Bit Admin Tool is running now. Especially as I just switched to Win 7 64 Bit. @(:->)>O<
And I am glad my blog post was of help for you.
Have a nice day and so long,
Thanks,
By the way, you have to use the 32bits ODBC to swith the server name for ONLINE open of repository : (C:\Windows\SysWOW64\odbcad32.exe )...and when you are done the ODBC admin fill crash ( but the modifications are still!!!!)
I have been working in BI since 15 years and used stuff from many software vendors, but with Oracle, the REAL Power is community and blogs like yours...that is true power !
Take care.
that's what I just found out last week.
I wanted to post about, but you are faster than me. Great.
For the statement regarding community is true power I could not agree more !
Thanks a lot and so long,
Oh What fun Windows 2008 64 bit is.
Nice to see the love being shared here, but has anyone actually got a full Win2k8 environment working?
How to execute registry fiels which you have mentioned
Hi SPN,
you just have to double click on the reg file if file ending is connected to regedit. If not click and execute it with regedit, then Win adds the entry to his registry.
Cheers,