Not able to create Universe connection to oracle

building semantic layer
1

I have Windows7 with 64 bit architecture and i have installed oracle client 10g and am able to connect to the Oracle server from SQL plus and able to create an ODBC connection successfully. But when i try to create a connection from BO XIR 3.0 universe to Oralce 10g native client, i am getting the error “DBD: ORA-12154: TNS:could not resolve the connect identifier specified”
Even though i am giving the correct credentials. Please help me out

divyap (BOB member since 2010-09-08)

2

What is your server architecture, is that also 64bit?

You can’t mix 32bit on the serve and 64bit on the PC

BO is a 32bit application so you will need to use 32bit ODBC connection, not 64bit.

I know that on Server 2008 they gave a facility to have both, not sure if that is also available on Win7

plessiusa :netherlands: (BOB member since 2004-03-22)

3

Have u applied respect TNS entry in trans.ora file in ur local machine…

Regards
Suresh

suresher83 (BOB member since 2010-10-25)

4

Sorry, I hoped ur TNS try was corrected … becuase of ODBC and SQL Plus working fine… can u use the ODBC connection access driver to get ODBC connection

Regards
Suresh

suresher83 (BOB member since 2010-10-25)

5

Hi, the server is 32 bit architecture.
I am connecting to oracle using Oracle Client, so there is no conecept of ODBC 32/64 driver. While connecting to sql server i am using 32bit ODBC connection only. Please correct if i am worng.

divyap (BOB member since 2010-09-08)

6

You will then need to make sure that you are using a 32bit ODBC connection on your Win 7 machine as your trying to communicate from a 64 bit to 32 bit machine.

plessiusa :netherlands: (BOB member since 2004-03-22)

7

Any luck with this as we’re having similar problems.

The Emu :australia: (BOB member since 2002-09-13)

8

Have you tried everything already mentioned here.

plessiusa :netherlands: (BOB member since 2004-03-22)

9

Hi for oracle , i need to use Oracle native client not ODBC. So how can choose ODBC32/64

divyap (BOB member since 2010-09-08)

10

Have you searched the Oracle forums on this as this really is an Oracle issue not a Business Objects one. Business Objects just happens to be the software that you want to use in this situation.

plessiusa :netherlands: (BOB member since 2004-03-22)

11

You need to use the 32 bit version of Oracle, with its associated 32 bit libraries, to connect a 64 bit OS client to a 32 bit Oracle database.

Mak 1 :uk: (BOB member since 2005-01-06)

12

thank you , i will try this

divyap (BOB member since 2010-09-08)