Analytics Software

Hi all,

I am currently testing OBIEE connection with PostgreSQL database, BI server is on the Red Hat Enterprise Linux and my client machine is Windows Vista. I believe that rare ones have established this connection but configuration should be the same as for MySQl so any recommendations could be helpful..

I set everything up, configured unixODBC, OBI odbc.ini etc. When I test connection locally in offline mode and with isql in the shell, it succeeds, but in online mode I cannot update row count and view data. I get the following error:
State: HY000. Code: 10058. NQODBC SQL_STATE: HY000
nQSError: 43093 An error occured while processing the EXECUTE PHYSICAL statement
nQSError: 16023 The ODBC function has returned an error. The database may not be available, or the network may be down

Also when trying to retrieve data through my Presentation service application I get similar error that ODBC function returned an error and the database may not be available, or the network may be down..


Please help, it is urgent!

Thank you!

Ami