Might be a problem with you TNSNAMES.ORA files or something like that. If
your DBD is reading from one there should be no problem reading another
even a different version it is just a matter of changing you connection
string
for eample
$db = DBI->connect('dbi:Oracle:','[EMAIL PROTECTED]','tester80', {
AutoCommit => 0 } );
connects me to 8i.
while
$db = DBI->connect('dbi:Oracle:','[EMAIL PROTECTED]','tester90', {
AutoCommit => 0 } );
gets me connected to 9i
in my TNSNAMES.ORA the entreis look like this
tpgoracle8.tpg =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)
(HOST = 000.000.000.000)
(PORT = 8080)
)
)
(CONNECT_DATA = (SERVICE_NAME = tpg1oracle8)
)
)
and
tpgoracle9.tpg =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)
(HOST = 000.000.000.000)
(PORT = 8080)
)
)
(CONNECT_DATA = (SERVICE_NAME = tpg1oracle9)
)
)
"Juan Carlos García" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Hi.
> This is the first time I send a message to the list, and I don't know
> if this is the correct method. If not, forgive me.
>
> In my company, we have a database in Oracle 8 and another one in Oracle 9.
> When we installed the DBI module, the ORACLE_HOME that we used was
> the corresponding to the 9 version. Now, I need to access to the
> database in 8 version, But, I can't.
>
> My question is, it's possible to access to two databases of different
versions?
>
> Excuse me if my english is not very well.
>
> Thanks in advance for any answer.
>
>
