How do you associate an Oracle_Home to business objects version 5 (5.1.7 which is compatible with oracle 9)when your PC has several ORACLE_HOMES? Despite changing the default ORACLE_HOME via C:\orant\bin\ohsel.exe to be ORACLE9 business objects always looks for the ORACLE7 client software and tnsnames. Is there a way to associate oracle middleware (tnsnames etc) to business objects via business objects itself?
Many Thanks
philipo (BOB member since 2005-07-22)
I don’t think there is any way that you can do this BO always has trouble - as you have found - if you have multiple Oracle homes on a machine…
Mak 1 
(BOB member since 2005-01-06)
I think a way to do it may be to:
Not convinced though…if you’ve 9i client is there any possiblity of dumping the earlier versions.
Nick Daniels (BOB member since 2002-08-15)
If you couldn’t force BO to use one specific oracle home (which I suspect you can do by registry / ini file hacking - search for ‘oracle’ in those) you can still try to synchronize your ons - tns files in multiple homes.
Of course try it only if it does not harm your other oracle based applications…
PeterC 
(BOB member since 2005-02-14)
Thanks for the replies - The reason I’m experimenting with the various different Oracle Client software is because I’m getting the following error message:
ORA-01722: invalid number :ORA-02063: preceding line from HOMIS_LIVE :-1722 when running a simple query e.g.
select multiple_name
from multiple
where mul_code = 809.
This query works fine in sqlplus and other 3rd part software e.g. TOAD. We’re using version 5 to access a 10g database I can query tables on the 10g database fine but when we query the views on the 10g database (the views are remotely derived from a 9 database. mult_code is a numeric field but if I change 809 to ‘809’ its is O.K in Bus Objects.
philipo (BOB member since 2005-07-22)
Version 5 is version 5.1.7 Business Objects. The problem seems to be querying views on a 10g database which are derived from a remote Oracle 9 database. Querying views on a Oracle 9 database derived remotely from another Oracle 9 database is fine.
philipo (BOB member since 2005-07-22)