This content has been marked as final. Show 6 replies
Can you confirm if you have used the 32 bit ODBC drivers when created the DSN. In 64 bit Windows the 32-bit version of the Odbcad32.exe file is located in the %systemdrive%\Windows\SysWoW64 folder.1 person found this helpful
Check the Microsoft article: http://support.microsoft.com/kb/942976
Try re-creating the DSN with the 32 bit ODBC driver and recreate the OCE with that and check.
Thank You For Help.
Yes I have create the odbc through C:\Windows\SysWOW64\odbcad32.exe. But Still same error.
I had made fresh installation overnight from formating windows till installation of Hyperion Interactive Reporting but still I stuck in same error.
With Hyperion Interactive Studio it is working fine. But if I run the same report through workspace or try to connect to web client it gives this error.
Edited by: Akbar Qureshi on Mar 19, 2013 7:14 AM
Did you try to use ODBC/SQL server rather than ODBC/ODBC?..You will have to make changes in DSN,OCE and DAS and then restart DAS.1 person found this helpful
Yes, I tried that as well. Did'nt work. Same I tried for IBM Db2 as well --- ODBC --- DB2.
We are using old version of Hyperion 8.3, which is working perfectly fine from last 10 years. I was given a task to prepare a demo for Hyperion 18.104.22.168 so that we can think of moving over to new one. All of my reports are on .BQY document.
Thanks for all of you who helped me but I am still stuck and have tried almost every possbile thing which comes to my mind.
Since you have allready tried out couple of stuff, so nothing much to offer.1 person found this helpful
but consider this.
take one of your old bqy (guess it is still 8.3.x)
convert it to 9.x
then upload this converted 9.x to 11.x workspace.
First of all Thanks for all of you for Helping me Out...
Three things to keep in mind.
01) First to create Data Source with 32 bit ODBC File which Mr. Krishna Kumar told me. Thanks Mr. Krishna.
C:\Windows\SysWOW64\odbcad32.exe --- System DSN --- Add --- SQL Server or IBM DB2 ODBC Driver --- Finish ---- Click on Data Souce --- Click Configure ---- Save User ID and Password
02) Use ODBC --- DB2 or ODBC --- MS Sql Server while creating .oce file From Hypeiorn Interactive Studio, which Mr. Vivek Chetiapar told me. Thanks Mr. Vivek.
03) To access data from web client in Hyperion Workspace or Connecting our .BQY reports to database we have to create data source in our computer first then on Hyperion Workspace. Both Data Source name should be same always (Case sensitive) and data connection file which is .oce file should always be different name as compared to data source.
Data Source : dsHyperion
Data Connection : dcHyperion
All above is what I learned from my experiance, I am sorry if I have mention some thing wrong but the fact is it works with me........
Thanks Every One.......