>
>
> Greetings.
>
> Context:
>
> Windows XP client
>
> Perl
> This is perl, v5.8.7 built for MSWin32-x86-multi-thread
> (with 7 registered patches, see perl -V for more detail)
> Binary build 813 [148120] provided by ActiveState
> http://www.ActiveState.com
> Built Jun 6 2005 13:36:37
>
> Note: perl -V output below
>
> DBI
> DBI version 1.48
> DBD-ODBC version 1.13
> DBD-Oracle version 1.16
>
> Installed via (a varient of) this:
> ppm install -force -follow
> ftp://ftp.esoftmatic.com/outgoing/DBI/5.8.4/DBI.ppd
> ppm install -force -follow
> ftp://ftp.esoftmatic.com/outgoing/DBI/5.8.4/DBD-Oracle.ppd
> ppm install -force -follow
> ftp://ftp.esoftmatic.com/outgoing/DBI/5.8.4/DBD-ODBC.ppd
>
> Oracle server (remote)
> Oracle8i Enterprise Edition Release 8.1.7.4.0 - 64bit
> Production
> With the Partitioning option
> JServer Release 8.1.7.4.0 - 64bit Production
>
> ORACLE_HOME is set both in the registry (via Oracle client-side
> installation process) and also in the system environment variables
> (by me, for good measure?).
Chances are something is wrong in the registry or environment. Is there
a TNS_ADMIN set anywhere? Are you running under a web server when it's
not working?
Jeff
>
> Symptoms:
> SqlPlus connection works fine.
>
> A perl script attempting connection works fine ONLY when the
> script is run from \orant\net80\admin.
>
> When the script is run from anywhere else, I get this error:
>
> ORA-12154: TNS:could not resolve the connect identifier specified
> (DBD ERROR: OCIServerAttach)
>
> Note that printf("%s\n", $ENV{'ORACLE_HOME'});
> displays c:\orant (as expected).
>
> Help!
> And Thanks!
> - C Seelig =====================================================
> C:\Documents and Settings\SeeligC\Start Menu>perl -V
> Summary of my perl5 (revision 5 version 8 subversion 7) configuration:
> Platform:
> osname=MSWin32, osvers=5.0, archname=MSWin32-x86-multi-thread
> uname=''
> config_args='undef'
> hint=recommended, useposix=true, d_sigaction=undef
> usethreads=define use5005threads=undef useithreads=define
> usemultiplicity=define
> useperlio=define d_sfio=undef uselargefiles=define usesocks=undef
> use64bitint=undef use64bitall=undef uselongdouble=undef
> usemymalloc=n, bincompat5005=undef
> Compiler:
> cc='cl', ccflags ='-nologo -Gf -W3 -MD -Zi -DNDEBUG -O1 -DWIN32
> -D_CONSOLE
> -DNO_STRICT -DHAVE_DES_FCRYPT -DBUILT_BY_ACTIVESTATE
> -DNO_HASH_SEED
> -DUSE_SITECUSTOMIZE
> -DPERL_IMPLICIT_CONTEXT -DPERL_IMPLICIT_SYS -DUSE_PERLIO
> -DPERL_MSVCRT_READFIX',
> optimize='-MD -Zi -DNDEBUG -O1',
> cppflags='-DWIN32'
> ccversion='12.00.8804', gccversion='', gccosandvers=''
> intsize=4, longsize=4, ptrsize=4, doublesize=8, byteorder=1234
> d_longlong=undef, longlongsize=8, d_longdbl=define, longdblsize=10
> ivtype='long', ivsize=4, nvtype='double', nvsize=8,
> Off_t='__int64',
> lseeksize=8
> alignbytes=8, prototype=define
> Linker and Libraries:
> ld='link', ldflags ='-nologo -nodefaultlib -debug -opt:ref,icf
> -libpath:"C:\Perl\lib\CORE" -machine:x86'
> libpth=\lib
> libs= oldnames.lib kernel32.lib user32.lib gdi32.lib winspool.lib
> comdlg32.lib advapi32.lib shell32.lib ole32.lib oleaut32.lib
> netapi32.lib uuid.lib
> ws2_32.lib mpr.lib winmm.lib version.lib odbc32.lib odbccp32.lib
> msvcrt.lib
> perllibs= oldnames.lib kernel32.lib user32.lib gdi32.lib
> winspool.lib
> comdlg32.lib advapi32.lib shell32.lib ole32.lib oleaut32.lib
> netapi32.lib uuid.lib
> ws2_32.lib mpr.lib winmm.lib version.lib odbc32.lib odbccp32.lib
> msvcrt.lib
> libc=msvcrt.lib, so=dll, useshrplib=yes, libperl=perl58.lib
> gnulibc_version='undef'
> Dynamic Linking:
> dlsrc=dl_win32.xs, dlext=dll, d_dlsymun=undef, ccdlflags=' '
> cccdlflags=' ', lddlflags='-dll -nologo -nodefaultlib -debug
> -opt:ref,icf
> -libpath:"C:\Perl\lib\CORE" -machine:x86'
>
>
> Characteristics of this binary (from libperl):
> Compile-time options: MULTIPLICITY USE_ITHREADS USE_LARGE_FILES
> USE_SITECUSTOMIZE PERL_IMPLICIT_CONTEXT
> PERL_IMPLICIT_SYS
> Locally applied patches:
> ActivePerl Build 813 [148120]
> Iin_load_module moved for compatibility with build 806
> PerlEx hacks for CGI::Carp
> Less verbose ExtUtils::Install and Pod::Find
> instmodsh upgraded from ExtUtils-MakeMaker-6.25
> 24699 ICMP_UNREACHABLE handling in Net::Ping
> 21540 Fix backward-compatibility issues in if.pm
> Built under MSWin32
> Compiled at Jun 6 2005 13:36:37
> @INC:
> C:/Perl/lib
> C:/Perl/site/lib
> .
>
>
