Thursday, 18 September 2008

Essbase 64bit ODBC quick fix

I thought I would just post a quick fix before I move on to the 3rd part of the ODI series, if you have ever installed essbase 9.3.1 64bit windows and try and use the merant ODBC drivers you will notice that no 64bit drivers don't seem to exist if you look in the Data source administrator.

If you look in the 32bit ODBC administrator you will see all the 64bit drivers, not much use them being there, somebody must of accidently sent them to the wrong place when creating the full proof and tested installation package.

If you look in the registry under HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBCINST.INI you will see the 32bit drivers mixed in with the 64bit drivers


The 64bit drivers should be in HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI
To fix the issue is no big deal all you need to do is add the correct parameters to the registry, so to create the parameters Merant 64bit Oracle Wire protocol just create a batch script:-


(sorry it as an image because it didnt format so well on the blog.)



Notice the last line you need this to associate driver with the driver details.
Just repeat for the drivers you want to use on 64bit.

Another way would be to export from regedit to .reg file, update the file to point to the new location and just run that.

Hopefully this maybe useful to anybody that encounters the problem.

4 comments:

Anonymous said...

Hi John,

Thanks a lot for your posts. I am starting off with Hyperion Planning (OEM 11). I have managed to install the sample planning application that comes with OEM 11.

It would be great if you can start a tutorial/discussion about how planning is done with respect to that sample application.

FOr example, How writeback is done, how the workflow is created, how a budgeting process will work,

Thanks alot,

John Goodwin said...

Thanks for your comment, it is definitely something I will add to my list of areas to cover

JM said...

Hi John,
Great Blog - I've just discovered it today. Instead of creating a file, the 64-bit install does create a RegUpdateODBC51.bat file that would do it. The newest GA release (9.3.1.3) will work correctly, but the other 9.3.1 versions had to be updated - some of the folder paths were wrong, as well as pointing to 5.1 drivers instead of 5.2 drivers (only 5.2 drivers are included in install). Just FYI

Anonymous said...

Hi......
Thanks for your posts.They are very helpful.Can u please provide some information regarding hyperion strategic finance.