PASS DBI-1.28 sun4-solaris 2.7
This distribution has been tested as part of the cpan-testers effort to test as many new uploads to CPAN as possible. See http://testers.cpan.org/ Please cc any replies to [EMAIL PROTECTED] to keep other test volunteers informed and to prevent any duplicate effort. -- Summary of my perl5 (revision 5.0 version 6 subversion 1) configuration: Platform: osname=solaris, osvers=2.7, archname=sun4-solaris uname='sunos max 5.7 generic_106541-08 sun4u sparc sunw,ultra-enterprise ' config_args='' hint=recommended, useposix=true, d_sigaction=define usethreads=undef use5005threads=undef useithreads=undef usemultiplicity=undef useperlio=undef d_sfio=undef uselargefiles=define usesocks=undef use64bitint=undef use64bitall=undef uselongdouble=undef Compiler: cc='cc', ccflags ='-fno-strict-aliasing -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64', optimize='-O', cppflags='-fno-strict-aliasing -I/usr/local/include' ccversion='', gccversion='2.95.2 19991024 (release)', gccosandvers='solaris2.7' intsize=4, longsize=4, ptrsize=4, doublesize=8, byteorder=4321 d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=16 ivtype='long', ivsize=4, nvtype='double', nvsize=8, Off_t='off_t', lseeksize=8 alignbytes=8, usemymalloc=y, prototype=define Linker and Libraries: ld='cc', ldflags =' -L/usr/local/lib ' libpth=/usr/local/lib /usr/lib /usr/ccs/lib libs=-lsocket -lnsl -ldl -lm -lc perllibs=-lsocket -lnsl -ldl -lm -lc libc=/lib/libc.so, so=so, useshrplib=false, libperl=libperl.a Dynamic Linking: dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=undef, ccdlflags=' ' cccdlflags='-fPIC', lddlflags='-G -L/usr/local/lib'
Re: Seg Fault with perl 5.8.0 RC2
Please try to get a stack trace (plus a DBI trace level 9). Please post it together with the output from perl -V. Please also rebuild with perl 5.6.1 to double check that something's not changed on the Oracle side. Tim. On Wed, Jul 03, 2002 at 03:53:38PM -0500, Sam Seaver wrote: > This didn't happen with perl 5.6.1, but basically after creating a $dbh > handle using DBD::Oracle successfully, > any attempt to create a new $sth handle in any way results in a > segmentation fault. > > I'm using Red-Hat 7.2, and have just installed the latest perl 5.8.0 RC2 > version. My scripts ran fine with the 5.6.1 version. > > has anyone else tried DBD::Oracle with perl 5.8.0 RC2? > > (this is using DBI-1.28 and DBD-Oracle-1.12) > > Thanks > Sam >
Re: DBD-Oracle
The archives. Tim. On Wed, Jul 03, 2002 at 03:57:52PM +0100, Carson, Jim wrote: > Can anyone assist on the following problem please? > > marlin:/home/jz26xf/DBD-Oracle-1.12 # make test > cp ora_explain blib/script/ora_explain > /usr/bin/perl -I/opt/perl-5.6.1/lib/5.6.1/PA-RISC2.0 > -I/opt/perl-5.6.1/l > ib/5.6.1 -MExtUtils::MakeMaker -e "MY->fixin(shift)" > blib/script/ora_explain > PERL_DL_NONLAZY=1 /usr/bin/perl -Iblib/arch -Iblib/lib > -I/opt/perl-5.6.1 > /lib/5.6.1/PA-RISC2.0 -I/opt/perl-5.6.1/lib/5.6.1 -e 'use Test::Harness > qw(&runt > ests $verbose); $verbose=0; runtests @ARGV;' t/*.t > t/base../usr/lib/dld.sl: Can't shl_load() a library > containing > Threa > d Local Storage: > /oracle/home/8.1.7/JRE/lib/PA_RISC/native_threads/libjava.sl > /usr/lib/dld.sl: Exec format error > Failed to load Oracle extension and/or shared libraries: > install_driver(Oracle) failed: Can't load > 'blib/arch/auto/DBD/Oracle/Oracle.sl' > for module DBD::Oracle: Exec format error at > /opt/perl-5.6.1/lib/5.6.1/PA-RISC2. > 0/DynaLoader.pm line 206. > at (eval 1) line 3 > Compilation failed in require at (eval 1) line 3. > Perhaps a required shared library or dll isn't installed where expected > at t/base.t line 19 > The remaining tests will probably also fail with the same error. > *** Please read the README and README.help files for help. *** > t/base..FAILED tests 4-5 > Failed 2/5 tests, 60.00% okay > t/general.../usr/lib/dld.sl: Can't shl_load() a library > containing > Threa > d Local Storage: > /oracle/home/8.1.7/JRE/lib/PA_RISC/native_threads/libjava.sl > /usr/lib/dld.sl: Exec format error > install_driver(Oracle) failed: Can't load > 'blib/arch/auto/DBD/Oracle/Oracle.sl' > for module DBD::Oracle: Exec format error at > /opt/perl-5.6.1/lib/5.6.1/PA-RISC2. > 0/DynaLoader.pm line 206. > at (eval 1) line 3 > Compilation failed in require at (eval 1) line 3. > Perhaps a required shared library or dll isn't installed where expected > at t/general.t line 20 > t/general...dubious > Test returned status 255 (wstat 65280, 0xff00) > t/long../usr/lib/dld.sl: Can't shl_load() a library > containing > Threa > d Local Storage: > /oracle/home/8.1.7/JRE/lib/PA_RISC/native_threads/libjava.sl > /usr/lib/dld.sl: Exec format error > Can't load 'blib/arch/auto/DBD/Oracle/Oracle.sl' for module DBD::Oracle: > Exec fo > rmat error at /opt/perl-5.6.1/lib/5.6.1/PA-RISC2.0/DynaLoader.pm line > 206. > at t/long.t line 4 > Compilation failed in require at t/long.t line 4. > BEGIN failed--compilation aborted at t/long.t line 4. > t/long..dubious > Test returned status 255 (wstat 65280, 0xff00) > t/ph_type.../usr/lib/dld.sl: Can't shl_load() a library > containing > Threa > d Local Storage: > /oracle/home/8.1.7/JRE/lib/PA_RISC/native_threads/libjava.sl > /usr/lib/dld.sl: Exec format error > Can't load 'blib/arch/auto/DBD/Oracle/Oracle.sl' for module DBD::Oracle: > Exec fo > rmat error at /opt/perl-5.6.1/lib/5.6.1/PA-RISC2.0/DynaLoader.pm line > 206. > at t/ph_type.t line 20 > Compilation failed in require at t/ph_type.t line 20. > BEGIN failed--compilation aborted at t/ph_type.t line 20. > t/ph_type...dubious > Test returned status 255 (wstat 65280, 0xff00) > t/plsql./usr/lib/dld.sl: Can't shl_load() a library > containing > Threa > d Local Storage: > /oracle/home/8.1.7/JRE/lib/PA_RISC/native_threads/libjava.sl > /usr/lib/dld.sl: Exec format error > Can't load 'blib/arch/auto/DBD/Oracle/Oracle.sl' for module DBD::Oracle: > Exec fo > rmat error at /opt/perl-5.6.1/lib/5.6.1/PA-RISC2.0/DynaLoader.pm line > 206. > at t/plsql.t line 17 > Compilation failed in require at t/plsql.t line 17. > BEGIN failed--compilation aborted at t/plsql.t line 17. > t/plsql.dubious > Test returned status 255 (wstat 65280, 0xff00) > t/reauthskipped test on this platform > Failed Test Status Wstat Total Fail Failed List of Failed > > > > t/base.t 5 2 40.00% 4-5 > t/general.t 255 65280 ?? ?? % ?? > t/long.t 255 65280 ?? ?? % ?? > t/ph_type.t 255 65280 ?? ?? % ?? > t/plsql.t 255 65280 ?? ?? % ?? > 1 test skipped. > Failed 5/6 test scripts, 16.67% okay. 2/5 subtests failed, 60.00% okay. > *** Error exit code 2 > Stop. > marlin:/home/jz26xf/DBD-Oracle-1.12 # make install > Installing > /opt/perl-5.6.1/lib/site_perl/5.6.1/PA-RISC2.0/auto/DBD/Oracle/Oracle > ...sl > Files found in blib/arch: installing files in blib/lib into architecture > depende > nt library tree > Installing /opt/perl-5.6.1/man/man1/ora_explain.1 > Installing /opt/perl-5.6.1/man/man3/DBD::Oracle.3 > Installing /opt/perl-5.6.1/man/man3/DBD::Oraperl.3 > Writing > /opt/perl-5.6.1/lib/site_perl/5.6.1/PA-RISC2.0/auto/DBD/Oracle/.packlist > Appending installation info to > /opt/perl-5.6.1/lib/5.6.
installing dbi/dbd
hi I am trying to install the dbi and dbd module for mysql to work for perl. I have downloaded and unzipped the modules. I am using dbd v 2.1017 and dbi ver 1.28 the problem occurs when i try to install the modules. I am using mandrake 7.2 which installed perl into /usr/bin/ when i did perl Makefile.pl it came up with the error saying that unable to locate installed perl libaries. It says it is redcommened to install perl into a standard location before building extensions, but ican't see anything wrong with the installation of perl. It also says it can't find /usr/lib/perl5/5.60/i386-linux/CORE/perl.h. in that CORE directory there is one file called libperl.so I am not sure why it won't install the modules and put them into the @inc array. I have installed the modules from cpan, so can't see anything wrong with the modules, any advice would be very welcome thanks ian _ Send and receive Hotmail on your mobile device: http://mobile.msn.com
DBI can't connect to Oracle 9i
I have a connection problem: DBI->connect(BBRP.LLNL.GOV) failed: ERROR OCIEnvInit at disable_all_foreign_keys.pl line 32 % perl -MDBI -MDBD::Oracle -MDBD::Sybase -le 'print "$DBI::VERSION $DBD::Oracle::VERSION"' 1.14 1.06 % uname -a SunOS trna 5.8 Generic_108528-11 sun4u sparc SUNW,Sun-Fire-880 DBD::Oracle was built on 8i client libraries. I figure this won't be a problem since SQL*Plus can use 8i client to connect to a 9i database. Any ideas? Ciao, Tim
Seg Fault with perl 5.8.0 RC2
This didn't happen with perl 5.6.1, but basically after creating a $dbh handle using DBD::Oracle successfully, any attempt to create a new $sth handle in any way results in a segmentation fault. I'm using Red-Hat 7.2, and have just installed the latest perl 5.8.0 RC2 version. My scripts ran fine with the 5.6.1 version. has anyone else tried DBD::Oracle with perl 5.8.0 RC2? (this is using DBI-1.28 and DBD-Oracle-1.12) Thanks Sam
Re: Accessing DBCC from DBI
On Wed, Jul 03, 2002 at 09:43:53AM -0700, Michael Peppler <[EMAIL PROTECTED]> wrote: > On Wed, 2002-07-03 at 09:28, Accardo, Glen wrote: > > > > I just tried to prepare/execute/fetch results for the following > > a dbcc call in MS SQL Server. I get an error stating that > > there is no select statement running--which is true. > > > > Is there a mechanism for getting the results of DBCC calls through > > DBI? The do method doesn't seem to return anything more than > > pass/fail, and what I need is all of the output from the > > DBCC calls. > > DBCC output is sent as "error" messages. DBD::Sybase handles this by > letting you define an ad-hoc error handler. Maybe DBD::ODBC has the same > sort of functionality. Nope, DBD::ODBC doesn't have that functionality. I submitted a patch a couple of years ago to address the issue, but it kinda got lost in the shuffle and I moved on to other projects without following up on it. I hope to re-integrate the patch into the latest DBD::ODBC soon, but I'm still trying to get access to an appropriate Windows box... -- David Good[EMAIL PROTECTED] This space intentionally left blank.
PASS DBI-1.28 sun4-solaris 2.7
This distribution has been tested as part of the cpan-testers effort to test as many new uploads to CPAN as possible. See http://testers.cpan.org/ Please cc any replies to [EMAIL PROTECTED] to keep other test volunteers informed and to prevent any duplicate effort. -- Summary of my perl5 (revision 5.0 version 6 subversion 1) configuration: Platform: osname=solaris, osvers=2.7, archname=sun4-solaris uname='sunos flr5 5.7 generic_106541-18 sun4u sparc ' config_args='' hint=recommended, useposix=true, d_sigaction=define usethreads=undef use5005threads=undef useithreads=undef usemultiplicity=undef useperlio=undef d_sfio=undef uselargefiles=define usesocks=undef use64bitint=undef use64bitall=undef uselongdouble=undef Compiler: cc='gcc', ccflags ='-fno-strict-aliasing -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64', optimize='-O', cppflags='-fno-strict-aliasing -I/usr/local/include' ccversion='', gccversion='3.0.3', gccosandvers='solaris2.7' intsize=4, longsize=4, ptrsize=4, doublesize=8, byteorder=4321 d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=16 ivtype='long', ivsize=4, nvtype='double', nvsize=8, Off_t='off_t', lseeksize=8 alignbytes=8, usemymalloc=y, prototype=define Linker and Libraries: ld='gcc', ldflags =' -L/usr/local/lib ' libpth=/usr/local/lib /usr/lib /usr/ccs/lib libs=-lsocket -lnsl -ldl -lm -lc perllibs=-lsocket -lnsl -ldl -lm -lc libc=/lib/libc.so, so=so, useshrplib=false, libperl=libperl.a Dynamic Linking: dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=undef, ccdlflags=' -Wl,-E' cccdlflags='-fPIC', lddlflags=' -W,l-E -G -L/usr/local/lib'
Re: Accessing DBCC from DBI
On Wed, 2002-07-03 at 09:28, Accardo, Glen wrote: > > I just tried to prepare/execute/fetch results for the following > a dbcc call in MS SQL Server. I get an error stating that > there is no select statement running--which is true. > > Is there a mechanism for getting the results of DBCC calls through > DBI? The do method doesn't seem to return anything more than > pass/fail, and what I need is all of the output from the > DBCC calls. DBCC output is sent as "error" messages. DBD::Sybase handles this by letting you define an ad-hoc error handler. Maybe DBD::ODBC has the same sort of functionality. Michael -- Michael Peppler / [EMAIL PROTECTED] / http://www.mbay.net/~mpeppler [EMAIL PROTECTED] / ZetaTools, Inc / http://www.zetatools.com ZetaTools: Call perl functions as Sybase stored procedures! signature.asc Description: This is a digitally signed message part
DBD-Oracle
Can anyone assist on the following problem please? marlin:/home/jz26xf/DBD-Oracle-1.12 # make test cp ora_explain blib/script/ora_explain /usr/bin/perl -I/opt/perl-5.6.1/lib/5.6.1/PA-RISC2.0 -I/opt/perl-5.6.1/l ib/5.6.1 -MExtUtils::MakeMaker -e "MY->fixin(shift)" blib/script/ora_explain PERL_DL_NONLAZY=1 /usr/bin/perl -Iblib/arch -Iblib/lib -I/opt/perl-5.6.1 /lib/5.6.1/PA-RISC2.0 -I/opt/perl-5.6.1/lib/5.6.1 -e 'use Test::Harness qw(&runt ests $verbose); $verbose=0; runtests @ARGV;' t/*.t t/base../usr/lib/dld.sl: Can't shl_load() a library containing Threa d Local Storage: /oracle/home/8.1.7/JRE/lib/PA_RISC/native_threads/libjava.sl /usr/lib/dld.sl: Exec format error Failed to load Oracle extension and/or shared libraries: install_driver(Oracle) failed: Can't load 'blib/arch/auto/DBD/Oracle/Oracle.sl' for module DBD::Oracle: Exec format error at /opt/perl-5.6.1/lib/5.6.1/PA-RISC2. 0/DynaLoader.pm line 206. at (eval 1) line 3 Compilation failed in require at (eval 1) line 3. Perhaps a required shared library or dll isn't installed where expected at t/base.t line 19 The remaining tests will probably also fail with the same error. *** Please read the README and README.help files for help. *** t/base..FAILED tests 4-5 Failed 2/5 tests, 60.00% okay t/general.../usr/lib/dld.sl: Can't shl_load() a library containing Threa d Local Storage: /oracle/home/8.1.7/JRE/lib/PA_RISC/native_threads/libjava.sl /usr/lib/dld.sl: Exec format error install_driver(Oracle) failed: Can't load 'blib/arch/auto/DBD/Oracle/Oracle.sl' for module DBD::Oracle: Exec format error at /opt/perl-5.6.1/lib/5.6.1/PA-RISC2. 0/DynaLoader.pm line 206. at (eval 1) line 3 Compilation failed in require at (eval 1) line 3. Perhaps a required shared library or dll isn't installed where expected at t/general.t line 20 t/general...dubious Test returned status 255 (wstat 65280, 0xff00) t/long../usr/lib/dld.sl: Can't shl_load() a library containing Threa d Local Storage: /oracle/home/8.1.7/JRE/lib/PA_RISC/native_threads/libjava.sl /usr/lib/dld.sl: Exec format error Can't load 'blib/arch/auto/DBD/Oracle/Oracle.sl' for module DBD::Oracle: Exec fo rmat error at /opt/perl-5.6.1/lib/5.6.1/PA-RISC2.0/DynaLoader.pm line 206. at t/long.t line 4 Compilation failed in require at t/long.t line 4. BEGIN failed--compilation aborted at t/long.t line 4. t/long..dubious Test returned status 255 (wstat 65280, 0xff00) t/ph_type.../usr/lib/dld.sl: Can't shl_load() a library containing Threa d Local Storage: /oracle/home/8.1.7/JRE/lib/PA_RISC/native_threads/libjava.sl /usr/lib/dld.sl: Exec format error Can't load 'blib/arch/auto/DBD/Oracle/Oracle.sl' for module DBD::Oracle: Exec fo rmat error at /opt/perl-5.6.1/lib/5.6.1/PA-RISC2.0/DynaLoader.pm line 206. at t/ph_type.t line 20 Compilation failed in require at t/ph_type.t line 20. BEGIN failed--compilation aborted at t/ph_type.t line 20. t/ph_type...dubious Test returned status 255 (wstat 65280, 0xff00) t/plsql./usr/lib/dld.sl: Can't shl_load() a library containing Threa d Local Storage: /oracle/home/8.1.7/JRE/lib/PA_RISC/native_threads/libjava.sl /usr/lib/dld.sl: Exec format error Can't load 'blib/arch/auto/DBD/Oracle/Oracle.sl' for module DBD::Oracle: Exec fo rmat error at /opt/perl-5.6.1/lib/5.6.1/PA-RISC2.0/DynaLoader.pm line 206. at t/plsql.t line 17 Compilation failed in require at t/plsql.t line 17. BEGIN failed--compilation aborted at t/plsql.t line 17. t/plsql.dubious Test returned status 255 (wstat 65280, 0xff00) t/reauthskipped test on this platform Failed Test Status Wstat Total Fail Failed List of Failed t/base.t 5 2 40.00% 4-5 t/general.t 255 65280 ?? ?? % ?? t/long.t 255 65280 ?? ?? % ?? t/ph_type.t 255 65280 ?? ?? % ?? t/plsql.t 255 65280 ?? ?? % ?? 1 test skipped. Failed 5/6 test scripts, 16.67% okay. 2/5 subtests failed, 60.00% okay. *** Error exit code 2 Stop. marlin:/home/jz26xf/DBD-Oracle-1.12 # make install Installing /opt/perl-5.6.1/lib/site_perl/5.6.1/PA-RISC2.0/auto/DBD/Oracle/Oracle ...sl Files found in blib/arch: installing files in blib/lib into architecture depende nt library tree Installing /opt/perl-5.6.1/man/man1/ora_explain.1 Installing /opt/perl-5.6.1/man/man3/DBD::Oracle.3 Installing /opt/perl-5.6.1/man/man3/DBD::Oraperl.3 Writing /opt/perl-5.6.1/lib/site_perl/5.6.1/PA-RISC2.0/auto/DBD/Oracle/.packlist Appending installation info to /opt/perl-5.6.1/lib/5.6.1/PA-RISC2.0/perllocal.po d marlin:/home/jz26xf/DBD-Oracle-1.12 # marlin:/home/jz26xf/DBD-Oracle-1.12 # perl -V Summary of my perl5 (revision 5.0 version 6 subversion 1) configuration: Platform: osname=hpux, osvers=11.00, archname=PA-RISC2.0 uname='hp-ux marlin b.11.00 c 9000800 71829 32-user license ' config_args=''
Accessing DBCC from DBI
I just tried to prepare/execute/fetch results for the following
a dbcc call in MS SQL Server. I get an error stating that
there is no select statement running--which is true.
Is there a mechanism for getting the results of DBCC calls through
DBI? The do method doesn't seem to return anything more than
pass/fail, and what I need is all of the output from the
DBCC calls.
Any help is appreciated, and happy 4th!
glen accardo
BMC Software, Inc.
-
use strict;
use DBI;
my ($instance, $user, $password, $db) =
('gaccardo', 'sa', 'xxx', 'master');
my $dbh = DBI->connect("dbi:ODBC:DRIVER={SQL Server};".
"SERVER=$instance;".
"DATABASE=$db", {RaiseError => 0, PrintError => 0})
or die "\n\nCannot connect.\n\n$DBI::errstr\n";
DBI->trace(9, 'C:\temp\dbi_trace.txt');
my $sth = $dbh->prepare("DBCC CHECKALLOC");
$sth->execute();
do {
my @query_results;
while (@query_results = $sth->fetchrow_array) {
print join (', ', @query_results) . "\n"
}
} while ( $sth->{odbc_more_results} );
-
DBD::ODBC::st fetchrow_array failed: (DBD: no select statement currently
executing err=-1) at D:\Qa\mbt\automation\perl\test.pl line 20.
PASS DBI-1.28 i686-linux 2.4.7-10smp
This distribution has been tested as part of the cpan-testers effort to test as many new uploads to CPAN as possible. See http://testers.cpan.org/ Please cc any replies to [EMAIL PROTECTED] to keep other test volunteers informed and to prevent any duplicate effort. -- Summary of my perl5 (revision 5.0 version 6 subversion 1) configuration: Platform: osname=linux, osvers=2.4.7-10smp, archname=i686-linux uname='linux divot.flr.follett.com 2.4.7-10smp #1 smp thu sep 6 17:09:31 edt 2001 i686 unknown ' config_args='' hint=recommended, useposix=true, d_sigaction=define usethreads=undef use5005threads=undef useithreads=undef usemultiplicity=undef useperlio=undef d_sfio=undef uselargefiles=define usesocks=undef use64bitint=undef use64bitall=undef uselongdouble=undef Compiler: cc='cc', ccflags ='-fno-strict-aliasing -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64', optimize='-O2', cppflags='-fno-strict-aliasing -I/usr/local/include' ccversion='', gccversion='2.96 2731 (Red Hat Linux 7.1 2.96-98)', gccosandvers='' intsize=4, longsize=4, ptrsize=4, doublesize=8, byteorder=1234 d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=12 ivtype='long', ivsize=4, nvtype='double', nvsize=8, Off_t='off_t', lseeksize=8 alignbytes=4, usemymalloc=n, prototype=define Linker and Libraries: ld='cc', ldflags =' -L/usr/local/lib' libpth=/usr/local/lib /lib /usr/lib libs=-lnsl -lgdbm -ldb -ldl -lm -lc -lcrypt -lutil perllibs=-lnsl -ldl -lm -lc -lcrypt -lutil libc=/lib/libc-2.2.4.so, so=so, useshrplib=false, libperl=libperl.a Dynamic Linking: dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=undef, ccdlflags='-rdynamic' cccdlflags='-fpic', lddlflags='-shared -L/usr/local/lib'
PASS DBI-1.28 sun4-solaris 2.7
This distribution has been tested as part of the cpan-testers effort to test as many new uploads to CPAN as possible. See http://testers.cpan.org/ Please cc any replies to [EMAIL PROTECTED] to keep other test volunteers informed and to prevent any duplicate effort. -- Summary of my perl5 (revision 5.0 version 6 subversion 1) configuration: Platform: osname=solaris, osvers=2.7, archname=sun4-solaris uname='sunos flr4 5.7 generic_106541-18 sun4u sparc ' config_args='' hint=previous, useposix=true, d_sigaction=define usethreads=undef use5005threads=undef useithreads=undef usemultiplicity=undef useperlio=undef d_sfio=undef uselargefiles=define usesocks=undef use64bitint=undef use64bitall=undef uselongdouble=undef Compiler: cc='gcc', ccflags ='-fno-strict-aliasing -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64', optimize='-O', cppflags='-fno-strict-aliasing -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64' ccversion='', gccversion='3.0.2', gccosandvers='solaris2.7' intsize=4, longsize=4, ptrsize=4, doublesize=8, byteorder=4321 d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=16 ivtype='long', ivsize=4, nvtype='double', nvsize=8, Off_t='off_t', lseeksize=8 alignbytes=8, usemymalloc=y, prototype=define Linker and Libraries: ld='gcc', ldflags =' -L/usr/local/lib ' libpth=/usr/local/lib /usr/lib /usr/ccs/lib libs=-lsocket -lnsl -ldb -ldl -lm -lc perllibs=-lsocket -lnsl -ldl -lm -lc libc=, so=so, useshrplib=false, libperl=libperl.a Dynamic Linking: dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=undef, ccdlflags=' -Wl,-E' cccdlflags='-fPIC', lddlflags=' -W,l-E -G -L/usr/local/lib'
Help with DBI->connect
Hi, I'm new with DBI and mod-perl, i'm trying to connect to a database in a remote computer using DBI:Oracle. When I try a connection locally, the process runs fine, when I try a connection from a remote computer I got the following error: Couldn't connect to database: Error while trying to retrieve text for error ORA-12705 (DBD ERROR: OCISessionBegin) Can anyone tell me what is happening? What configuration do I have to set on my machine to connect to the database? Thanks in advance, Ricardo Oliveira _ INTERNET MAIL FOOTER A presente mensagem pode conter informação considerada confidencial. Se o receptor desta mensagem não for o destinatário indicado, fica expressamente proibido de copiar ou endereçar a mensagem a terceiros. Em tal situação, o receptor deverá destruir a presente mensagem e por gentileza informar o emissor de tal facto. - Privileged or confidential information may be contained in this message. If you are not the addressee indicated in this message, you may not copy or deliver this message to anyone. In such case, you should destroy this message and kindly notify the sender by reply email. -
Re: sth->cancel
> On Tue, Jul 02, 2002 at 04:44:59PM +0200, Waldemar Zurowski wrote: > > On Mon, 1 Jul 2002 21:34:50 +0100 > > Tim Bunce <[EMAIL PROTECTED]> wrote: > > > > > > Yet is't a horribly long name. Why don't you change "connect" into > > > > "connect_to_database", "prepare" into "prepare_statement" and "do" into > > > > "prepare_and_execute_statement"? > > > > > > Huffman coding. > > > > Well - I personally like name 'finish'. It is doing what I want (in current context of course.) It is finishing a query. > > Trouble is, thousands of people (literally) think it finishes/deallocates > the statement handle and/or that they need to call it after fetch loops. > > Tim. > I sometimes need "finish" to prevent Oracle from whining that I havn't read all the rows I've selected. How about "discard", or "no_more", or "enough_already", or "thank_you_thats_enough"? :-) Thinking about it, "enough" seems a reasonable suggestion! -- David Adams Computing Services Southampton University
