Re: Explicit Connection Problem

From: Fred Wiersma <fred.wiersma_at_cmg.nl>
Date: 1997/12/12
Message-ID: <EL2zyn.D9u.0.netsrv.att.cmg.nl@piziali.dv.org>#1/1

Use in TNSNAMES.ORA the same name for the 7.2 DB as for the 7.1 DB. Assuming Sql*Net version2, of course.

E.g.:

name =  (...
HOST = <7.2 host>
 SID = <7.2 instance>

)

which replaces

name =  (...
HOST = <7.1 host>
 SID = <7.1 instance>

)

After that, you cannot connect to the 7.1 DB with this TNSNAMES.ORA. If you want that, you must switch between connections.

Matt Schoaf wrote in message <66p5jg$b62_at_gatx_news.GATX.COM>...
>We have ProC programs which were compiled under ProC 2.2 which ran against
 a
>7.1.4 database. We are now trying to run them against a 7.3.2 database and
>after some research, I have determined that the explicit connection to the
>database is the problem.
>
>Has anyone else experienced this? We would certainly like to avoid
>re-compiling all our ProC programs in order to migrate to a newer database.
>
>--
>Matthew A. Schoaf
>Logix Consulting Incorporated
>********SPAM PREVENT********
> Please remove the '_no_spam_'
> from my email address...and
> pardon the inconvenience.
>************************************
>
>
>
Received on Fri Dec 12 1997 - 00:00:00 CST