go to OracleBI_HOME/setup here you will see the odbc.ini file open that and look for
change the servermachine from localhost to ipaddress (of the machine where you have the obiee installed) and then start the services and see how it goes
I didnt find odbc.ini file in my installed files.
Could you please give me the exact location of it. I didnt find even 'setup' folder. I have checked in both OracleBI and OracleBIData. We are using OBIEE 10g.
check the ODBC connectivity,
Because of improper details in ODBC DSN also it may deliver this type of error.
Noticed that unable to connect to database. problem inODBC DSN. Looking through that.