Skip to Content
author's profile photo Former Member
Former Member

Error in Connecting SAP BO 4.0 Oracle 10XE

Hello Experts,

We are using SAP BO 4.0 Information Design Tool and trying to create a connection to oracle 10G XE database.

We are succesful in conneting through SQL Plus & able to ping through tnsping, but not able to connect through IDT

System configuration: Windows 7 64 bit, Oracle 10G XE 32 bit, SAP BO 4.0 SP4

We suspect the issue is due to 64 bit Operating system & 32 bit oracle, please provide your insights to fix this.



Error.jpg (84.1 kB)
Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Jul 21, 2014 at 10:40 AM


    For access the oracle data, You need to add the TNS in the BO Server. So check with your admin team TNS is added into the BO server or not.

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi

      Once the TNS is created in the BO server, you should not get the error.

      Try to Crete once gain from starting and check.

      is this because of OS is win7 64 bit and oracle 10g is 32 bit and SAP BO 4.0 is 64 bit?

      Check the below note. it may help you.

      1866869 - SBOP BI 4.0: Error: "Data source name not found and no default driver specified" when creating Multi-source

      enabled Data Foundation with 32-bit and 64-bit data providers in Information Design Tool

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.