Emergency assistance - This should never be so difficult! ?
All day working switching between the 2 activestate binary installation
versions from activestate site & DBD/DBI versions.  No headway
connecting
to oracle via perl DBI.  Windows 2k - new system. Everything newly
installed for this PC.  I do not see an activestate 6.xx binary at the
activestate site ?   Uninterested in diving into the typical horror
story of compiling from scratch .
Is there a package which includes the Oracle DBD & DBI together
to guarantee compatibility?   Is there a trusted compiled binary of
recent
verions 6.xx activestate ( although current versions 5.xx work fine on
all other PCs ).
Please provide insight into current combination of DBI/DBD-Oracle/Activestate
downloads which work together.   Only oracle client is loaded on
local system
( NOT FULL oracle).  Instance to connect with is on a remote server (
not
sure how that matters but this is only BIG difference I can see ).
Not a "new code issue" because these codes work fine on other systems
for connecting remote to same oracle instance.  Only difference is
other working systems DO HAVE FULL oracle installation on each
local machine & therefore I do not bother with DBD-ODBC connectivity I
use
DBD-Oracle direct.  Could it be that full oracle install should be on
local sys for
this remote connectivity to work ( even if not using the local instance) ?
Could it be there are dlls or other files included in a full instance that
would mitigate this ?
Codes never get past DBI connect string.
--------------------------------
Here is error using    
DBD-ODBC   module &
its connect string:
Loading DB routines from perl5db.pl version 1.07
Editor support available.
Signal SEGV at F:/Perl/site/lib/DBI.pm line 182
        eval {...}
called at
F:/Perl/site/lib/DBI.pm line 182
        require DBI.pm
called at
perl_code.pl line 5
        main::BEGIN()
called at
F:/Perl/site/lib/DBI.pm line 182
        eval {...}
called at
F:/Perl/site/lib/DBI.pm line 182
Error using   DBD-ORACLE   module & its
connect
string :
( gives identical error as above DBD-ODBC module ).
So can't use either connection method.
---------------------------------
Here are versions:
>ppm query
CGI            &
nbsp;      
[3.00   ] Simple Common
Gateway Interface Class
DBD-ODBC        
[0.28   ]
ODBC driver for the DBI module.
DBD-Oracle      
[1.03   ] Oracle
database driver for the DBI module
DBI            &
nbsp;      
[1.14   ] Database
independent interface for Perl
--------------------------------
Here are both connect strings each tried ( dbi-odbc & dbi-oracle ):
[code]
use CGI qw/:standard/;
use DBI;
%attr = (  PrintError => 0, RaiseError => 1);
# my $dbh1 = DBI->connect('DBI:Oracle:oracle_name','userid','passwd',
\%attr) or die "Couldn't connect to database: " . DBI->errstr;
  my $dbh1 = DBI-&
gt;connect('DBI:ODBC:my-odbc-datasource.dsn','the_usernm','the_passwd',\%attr) or die
"Couldn't connect to database: " . DBI-&
gt;errstr;
[/code]
---------------------------------
Here are the 2 perl versions  precompiled binaries  I've
been switching between to force it to work.  From site:
http://ppm.activestate.com/PPMPackages/zips/
ActivePerl 5xx (e.g. ActivePerl 5_005.522)
ActivePerl 6xx (e.g. ActivePerl 5.6.1.623)
ActivePerl-5.6.0.623-MSWin32-x86-multi-thread.msi
ActivePerl-5.6.1.635-MSWin32-x86.msi
-------------------------------
Troubleshooting evidence all points back to DBI :
I can connect to same instance from command line sqlplus &
graphical sqlplus using oracle_name defined in tnsnames.
Therefore  local oracle connectivity config for Oracle client is
accurate.    Java code connections, sqlplus connect
&
tnsping
troubleshooting all work fine.  Only DBI is the holdup !.
I can also connect within other Msoft
apps using the created ODBC DSN therefore DSN is
fine ( used in the ODBC connection string).
>sqlplus schema_name/[EMAIL PROTECTED]
SQL*Plus: Release 8.1.7.0.0 - Production on Fri Feb 6 02:57:43 2004
(c) Copyright 2000 Oracle Corporation.  All rights reserved.
Connected to:
Oracle8i Enterprise Edition Release 8.1.7.0.0 - 64bit Production
>tnsping oracle_name
TNS Ping Utility for 32-bit Windows: Version 8.1.7.0.0 - Production on 0
04 03:30:06
(c) Copyright 1997 Oracle Corporation.  All rights reserved.
Attempting to contact (ADDRESS=(PROTOCOL=TCP)(HOST=10.2.2.2 )
(PORT=152 OK (20 msec)
--------------------------------
Relevant ?
I Had to REMOVE "architecture" tags from ppd files for both modules
to enable loading with PPM  ( otherwise, kept getting familiar error
"unable to
find ppd").  Here is edited ppd file which is same deletion for
DBD-Oracle:
[code]
<SOFTPKG NAME="DBD-ODBC" VERSION="0,28,0,0">
<TITLE>DBD-ODBC</TITLE>
<ABSTRACT>ODBC driver for the DBI module.</ABSTRACT>
<AUTHOR>Tim Bunce and Jeff Urlwin ([EMAIL
PROTECTED])</AUTHOR&
gt;
<IMPLEMENTATION>
<DEPENDENCY NAME="DBI" VERSION="0,0,0,0" />
<OS NAME="MSWin32" />
<CODEBASE HREF="C:/perl/5.6packages/x86/DBD-ODBC.tar.gz" />
</IMPLEMENTATION>
</SOFTPKG>
[code]
PPM Installation messages looked fine thereafter.
-----------------------------------
Version info:
> perl -V
Summary of my perl5 (revision 5 version 6 subversion 1) configuration:
  Platform:
    osname=MSWin32, osvers=4.0,
archname=MSWin32-x86-multi-thread
    uname=''
    config_args='undef'
    hint=recommended, useposix=true, d_sigaction=undef
    usethreads=undef use5005threads=undef
useithreads=define
usemultipl
ine
    useperlio=undef d_sfio=undef uselargefiles=undef
usesocks=undef
    use64bitint=undef use64bitall=undef uselongdouble=undef
  Compiler:
    cc='cl', ccflags ='-nologo -O1 -MD -Zi -DNDEBUG -DWIN32
-D_CONSOLE
CT -DHAVE_DES_FCRYPT  -DPERL_IMPLICIT_CONTEXT -DPERL_IMPLICIT_SYS -DPER
READFIX',
    optimize='-O1 -MD -Zi -DNDEBUG',
    cppflags='-DWIN32'
    ccversion='', 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='off_t',
=4
    alignbytes=8, usemymalloc=n, prototype=define
  Linker and Libraries:
    ld='link', ldflags ='-nologo -nodefaultlib -debug
-opt:ref,icf  -li
\Perl\lib\CORE"  -machine:x86'
    libpth="F:\Perl\lib\CORE"
    libs=  oldnames.lib kernel32.lib user32.lib
gdi32.lib
winspool.lib
.lib advapi32.lib shell32.lib ole32.lib oleaut32.lib  netapi32.lib uuid
k32.lib mpr.lib winmm.lib  version.lib odbc32.lib odbccp32.lib msvcrt.l
    perllibs=  oldnames.lib kernel32.lib
user32.lib
gdi32.lib winspool.
lg32.lib advapi32.lib shell32.lib ole32.lib oleaut32.lib  netapi32.lib
wsock32.lib mpr.lib winmm.lib  version.lib odbc32.lib odbccp32.lib msvc
    libc=msvcrt.lib, so=dll, useshrplib=yes,
libperl=perl56.lib
  Dynamic Linking:
    dlsrc=dl_win32.xs, dlext=dll, d_dlsymun=undef,
ccdlflags='
'
    cccdlflags=' ', lddlflags='-dll -nologo -nodefaultlib
-debug -opt:r
libpath:"F:\Perl\lib\CORE"  -machine:x86'
Characteristics of this binary (from libperl):
  Compile-time options: MULTIPLICITY USE_ITHREADS PERL_IMPLICIT_CONTEXT
LICIT_SYS
  Locally applied patches:
        ActivePerl
Build 635
  Built under MSWin32
  Compiled at Feb  4 2003 15:34:21
  @INC:
    F:/Perl/lib
    F:/Perl/site/lib
    .
--------------------
Here are system specs:
MS Win 2000 Svc Pack 3
Intel(Xeo) 3.06GHz
compaq server system ( I think 4 cpu  although don't see
how it matters).
---------------------
TIA  & much appreciated for you time !!!!!!!!
