I believe that one of the problems with using Oracle on NT is that the ORA_HOME is in
the registry. Whereas in UNIX you can set it in the Perl script with:
# Location of the tnsnames.ora file you want to use
$ENV{'TNS_ADMIN'} = "/home/oracle/admin/sqlnet/tnsname.dir";
# ORACLE_HOME
$ENV{'ORACLE_HOME'} = "/home/oracle/product/8.0.5";
Stanley G. Martin
Midwest Consulting Group
Sprint Platform & Strategy Mgmt
913.315.3133
[EMAIL PROTECTED]
-----Original Message-----
From: jschell [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 12, 2001 3:17 PM
To: Robert.Jones2
Cc: jschell; activeperl; perl-win32-users
Subject: Re: DBI:Oracle tnsnames.ora
Jones Robert Contr 81 CS/SCK wrote:
>
> OS: Windows 2000 & NT
> Perl 5.005 activestate build 522
> DBI [1.13.1] Database independent interface for Perl
>
> On our systems we run Oracle 7.0, 8.0 and 8.1 servers. Each of these has
> it's own tnsnames.ora file for hostnames that the Oracle driver queries.
>
> 1) Which tnsnames.ora will Oracle default to using DBI:Oracle ?
>
> 2) How can you change the tnsnames.ora file being referenced by DBI:Oracle ?
>
I would guess that 8.1 will access 8.0 and 7.0, so I would probably set
it up that way.
If that doesn't work, I would guess that setting the PATH env var
correctly, before running each script, would do the trick.
_______________________________________________
Perl-Win32-Users mailing list
[EMAIL PROTECTED]
http://listserv.ActiveState.com/mailman/listinfo/perl-win32-users
