Re: Off Topic, slightly - Crystal Reports internal format

On Mon, 10 Jun 2002 Jared.Still_at_radisys.com wrote:

> 1) for the dbname...why not just change the SID in TNSNAMES
> that the ODBC DSN is using to point to the snap-shotted(?)
> instance
>
> I'm eliminating tnsnames.ora files on the desktop, so that is out.
>

Sorry...I haven't used onames or OID yet; but does it not still provide the same level of abstraction as TNSNAMES without the file? The ODBC DSN is still separate and will have to resolve whether it is doing so through names or whatever. I still think you would change the logical side (service_name) to point at a different physical db and Bill's fine ODBC software won't care. The risk is that they use the same DSN for updating; then you would have a problem.

> 2) I think private synonyms would be the way to go for the
> table naming problem. Why did they not just use the same
> names on the snapshot site....been there done that, got the
> T-shirt
>
> Private synonyms will either:
> * not work
> * confuse the user.
>
> 'They' is me. The table names reflect the fact that the
> tables are materialized views. FWIW there are public
> synonyms for the tables, but Crystal doesn't use them.
>
> Jared

'Crystal doesn't use them'??? then the schema must be encoded in the SQR SQL statements. If this is true then you have another problem because you want to rename the schema. If you don't want to modify/recompile the SQR then why not create the schema that SQR expects and front the MV tables with synonyms.

Oh...and when did we start caring if the user was confused? =8-) j/k

Cheers

Jeff H.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jeff Herrick
  INET: jherrick_at_host.ott.igs.net

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).