Sorry for the top-posting, but your e-mail is very difficult to read because of the formatting.
I can tell you that if you read the DBI archives, there is a binary release for perl 5.8.2, not for 5.6.1. I suspect your issue is more related to the fact that you changed the "architecture". Don't do that. The modules are built for specific versions of perl (and DBI and DBD builds go together). If you upgrade to build 808 from ActiveState, you can use: ppm install ftp://ftp.esoftmatic.com/outgoing/DBI/5.8.2/DBI.ppd ppm install ftp://ftp.esoftmatic.com/outgoing/DBI/5.8.2/DBD-Oracle.ppd ppm install ftp://ftp.esoftmatic.com/outgoing/DBI/5.8.2/DBD-ODBC.ppd Jeff > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Friday, February 06, 2004 1:39 PM > To: [EMAIL PROTECTED] > Cc: [EMAIL PROTECTED] > Subject: Severe DBI-Oracle DBI-ODBC Problem > > > > > 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 >       &a > mp;nbsp; eval {...} called at > F:/Perl/site/lib/DBI.pm line 182 >       &a > mp;nbsp; require DBI.pm called at > perl_code.pl line 5 >       &a > mp;nbsp; main::BEGIN() called at > F:/Perl/site/lib/DBI.pm line 182 >       &a > mp;nbsp; 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 > ;      & > nbsp;     &nb > sp; [3.00   ] Simple Common > Gateway Interface Class > DBD-ODBC     & > ;nbsp;   [0.28   ] > ODBC driver for the DBI module. > DBD-Oracle     &a > mp;nbsp; [1.03   ] Oracle > database driver for the DBI module > DBI     &nbsp > ;      & > nbsp;     &nb > sp; [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: >       &a > mp;nbsp; 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 !!!!!!!! > > > >
