DBDriver failed to load dbd_oci.dll while creating universe

[Former Member]

Hello All,

I am trying to create a universe with Oracle as source. When I logged into Universe Designer and proceed to created a universe by selecting oracle 11 as data source, the designer throws an error:

" (CS) "DBDriver failed to load : C:\Program Files (x86)\Business Objects\BusinessObjects Enterprise 12.0\win32_x86\dataAccess\connectionServer\dbd_oci.dll (%1 is not a valid Win32 application.)" .

Below are the environment details:

OS : windows 2008 server 64 bit

BO Server : BOE 3.1 sp3 32 bit

CMS : MySQL 5.1

Oracle Client: Oracle 11g 64 bit client is installed.

I have set the path and environment variables relating to oracle as well.

If I create a DSN and test connection it works fine. Please let me know your suggestions and inputs to resolve this error.

Thanks

Mahesh

[Former Member · Accepted solution]

Mahesh,

Oracle Client: Oracle 11g 64 bit client is installed.

You have to Install 32bit. As of now, BO has no driver connectivity for 64 bits.

Hope it will help you.

Thank You!!

[Former Member · Accepted solution]

As BOCP-BOE, said, BOE XI 3.1 is a 32-bit application and is designed to 32-bit middleware connectivity. This is mentioned in the SAP BusinessObjects Enterprise XI 3.1 SP3 for Windows u2013 Supported Platforms document.

The document is available at http://service.sap.com/~form/sapnet?_SHORTKEY=01100035870000726132&_SCENARIO=01100035870000000202&_O...

(You will need an SMP login)