Connect error when running in BOE 1

[kskid]

Crystal XI
Oracle 8i database using Oracle ODBC driver

I am using the add command to link two table from two separate databases, SID76 and SID70

The remote Database link was created separately and is the following

create public database link sid70.world
connect to prduser identified by abc123
using 'SID70';

I have the following add command that runs fine in Crystal XI developer

From the report I am logged into SID76 database.

SELECT
  '7.6' "DB",
   MASTER_NAMES."LNAME", 
  MASTER_NAMES."FNAME",
  MASTER_NAMES."MNAME",
  MASTER_NAMES."MN_ID",
  MASTER_NAMES."PER_PERSON_ID"
FROM
  "PRDDBA"."MASTER_NAMES" MASTER_NAMES
WHERE
  MASTER_NAMES."LNAME" = UPPER( '{?LName}') AND
  MASTER_NAMES."FNAME" = UPPER('{?FName}')
UNION
SELECT
  '7.0' "DB",
   MASTER_NAMES70."LNAME", 
  MASTER_NAMES70."FNAME",
  MASTER_NAMES70."MNAME",
  MASTER_NAMES70."MN_ID",
  MASTER_NAMES70."PER_PERSON_ID"
FROM
  "PRDDBA"."MASTER_NAMES"@SID70.WORLD MASTER_NAMES70
WHERE
  MASTER_NAMES70."LNAME" = UPPER('{?LName}') AND
  MASTER_NAMES70."FNAME" = UPPER('{?FName}');

The report runs fine in Crystal XI but I get the following error when I try to run the same report in BO Enterprise using eith the CMC preview mode or Infoview

Failed to open the connection. Master_Name Command.rpt

Unable to retrieve Object.
Failed to open the connection. Master_Name Command.rpt

It appears that it does not recognizing the remote connection. Any ideas on what I need to do to correct it or is it something I need to address with BO?

 

[Turkbear]

Hi,
To test, try creating a view in SID76 that uses that same code..Base your report on the view..Publish and see if it works..




To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[synapsevampire]

I've not tried your scenario, but make sure that the CE server has an Oracle client on it or CE can't access the database at all.

I like turks test, however I would also suggest installing Crystal Reports on the CE server so that you can test these types of things, as it tends to provide better error messages.

-k

 

[kskid]

synapse,

That was the problem. The tnsnames.ora did not have sid75 but was still not connecting. We found more than one tnsnames.ora so we went through and updated all of them and now it's working as designed.

Star for you.