I am facing the same problem with Oracle. As far as I see it on the server you must have 64 bit drivers. I think they have a bug with the Oracle 32 bit client and BOBI 4.0 client coexisting on the server.
However this is directly from BO installation guide.
Note:
Although the Client Tools are supported on 64-bit operating systems, the Client Tools themselves
are only available as 32-bit applications.
When installing a database driver for Client Tools on 64-bit operating systems, ensure that you install
the 32-bit version. A 32-bit application cannot use a 64-bit driver.
If you install both the Client Tools and BI platform servers on the same 64-bit Windows operating
system, you must install both 32-bit and 64-bit database drivers on the machine. You must also
ensure that both 32-bit and 64-bit database connector middleware is installed and that their data
source configurations are identical since Client Tools requests in this scenario may be handled by
either of the two 32-bit or 64-bit Native Connectivity Services.
With the SQL server the best way is to create OLEDB connections to the data sources for BO 4.0 when the client tools are on the server.
Ok Just installed Oracle client 32 bit and Oracle client 64 bit on my BO 4 server and the connections to Oracle db that were created on the client are working on the server.
I am unable to get the client connections to work on the crystal reports on BI launchpad for BOXI 4.0 (OS Windows 2008, Reporting Database Oracle 11g, Repository Database -SQL Server). 32 bit and 64 bit clients are installed (as our report content includes both Crystal 2011 and WebI) and I am able to create ODBC connections via these clients to the Reporting database.
I created these environment variables-
ORACLE_HOME32
TNS_ADMIN
TNS_ADMIN32
BOE_USE_32BIT_ENV_FOR=ORACLE_HOME, TNS_ADMIN
For those who got this to work. Is any other configuration needed on the BOE Application?
No error. The crystal reports keeps on running with no output. The same report works fine when downloaded on the client workstation (which has a 32 bit oracle client installed). I opened a ticket with SAP but havent recieved much direction so far.
I suspect the crystal report is using the 64 bit libraries instead of 32 but not sure how to configure it to look at the right libraries.
Yes. For 32 bit ODBC connection, used the exe - C:\Windows\SysWOW64\odbcad32.
Uinstalled the 64 bit client. I was able to run the crystal report with the default
option ( use original database logon on information) with a 32 bit ODBC connection with a DSN having the same name as the client machine.
But cannot use a custom database login-
if ODBC driver option is selected, error masg-Error in File ~tmp4447dc39c37186.rpt: Failed to load database information
for Oracle driver option is selected, error msg- Failed to open the connection. ~tmp11b87dc2c7e6902.rpt
The database info provided on the report database configuration tab is correct as I am able to use SQL plus to connect successfully with the same information
The above errors show up when I try run the report (run now) from CMC.
(BOB member since 2007-10-16)
(BOB member since 2002-08-19)
(BOB member since 2007-10-16)
(BOB member since 2005-01-06)