Fetch failure
First of all, I am new to perl, so be gentle with me. Any assistance would
be greatly appreciated
I'm having a problem with a perl script that uses DBI (1.15) with the
Oracle DBD (1.06) that seems to be tied to the number of fields I want
returned and the number of rows that are returned. Essentially, the script
is hanging on the fetch of the data. The database is on another server in
the same subnet.
In the SELECT, there's a ROWNUM limit. If I remove it, same problem. If I
drop it down to 100, then no problems. Before I put the RowCacheSize
parameter in the connect string, the script would hang at the execute
portion (after the "dbd_st_execute SELECT (out0, lob0)..." bit in the
dbitrace.log)
If I decrease the number of fields, I can increase the number of rows I get
back. However, the number of rows I can retrieve with the current number of
fields seems to be slowly decreasing. The first time I actually figured out
how many rows I could get back, it was at 517. Now, it's somewhere around 475.
I've tried modifying the way that I retrieve the data (fetch with
bind_colums vs. fields with fetchrow_array vs. etc.), the RowCacheSize and
others, but nothing seems to do anything.
Again, thanks for any assistance any of you can provide.
Here's a test script I created so I can work on the problem while not doing
everything the main script does:
--
#!/usr/bin/perl -w
BEGIN {
$ENV{ORACLE_HOME} = '/usr/local/OraHome';
$ENV{TWO_TASK}= 'SID';
}
use DBI;
use DBD::Oracle;
my $sid="SID";
my $user="user";
my $pass="pass";
DBI->trace( 4, 'dbitrace.log' );
my $dbh = DBI->connect("DBI:Oracle:$sid",$user,$pass, {RaiseError => 1,
RowCacheSize => -1});
my $strSQL = 'SELECT field1, field2, field3, field4, field5, field6,
field7, field8, field9, field10, field11, field12, field13, field14,
field15, field16, field17 FROM table_name WHERE rownum <= 1000 AND
otherfield IS NULL ORDER BY field5';
my $sth = $dbh->prepare ($strSQL);
$sth->execute();
my( $field1, $field2, $field3, $field4, $field5, $field6, $field7, $field8,
$field9, $field10, $field11, $field12, $field13, $field14, $field15,
$field16, $field17 );
$sth->bind_columns( \($field1, $field2, $field3, $field4, $field5, $field6,
$field7, $field8, $field9, $field10, $field11, $field12, $field13,
$field14, $field15, $field16, $field17) );
while ($sth->fetch) {
print "$field1\n";
}
$sth->finish;
$dbh->disconnect();
--
and here's the result from the dbitrace.log:
--
DBI 1.15-nothread dispatch trace level set to 4
-> DBI->connect(DBI:Oracle:SID, user, , HASH(0x80f86e0))
-> DBI->install_driver(Oracle) for perl=5.006 pid=26311 ruid=560 euid=560
install_driver: DBD::Oracle loaded (version 1.06)
New DBI::dr (for DBD::Oracle::dr, parent=, id=)
dbih_setup_handle(DBI::dr=HASH(0x816e0fc)=>DBI::dr=HASH(0x81bd828),
DBD::Oracle::dr, 0, Null!)
dbih_make_com(Null!, DBD::Oracle::dr, 88)
<- install_driver= DBI::dr=HASH(0x816e0fc)
-> connect for DBD::Oracle::dr (DBI::dr=HASH(0x816e0fc)~0x81bd828
'SID' 'user' HASH(0x81bc578))
New DBI::db (for DBD::Oracle::db, parent=DBI::dr=HASH(0x81bd828), id=)
dbih_setup_handle(DBI::db=HASH(0x81bc818)=>DBI::db=HASH(0x81bd81c),
DBD::Oracle::db, 816de50, Null!)
dbih_make_com(DBI::dr=HASH(0x81bd828), DBD::Oracle::db, 112)
<- connect= DBI::db=HASH(0x81bc818) at DBI.pm line 412.
-> STORE for DBD::Oracle::db (DBI::db=HASH(0x81bd81c)~INNER
'RaiseError' 1)
STORE DBI::db=HASH(0x81bd81c) 'RaiseError' => 1
<- STORE= 1 at DBI.pm line 437.
-> STORE for DBD::Oracle::db (DBI::db=HASH(0x81bd81c)~INNER
'PrintError' 1)
STORE DBI::db=HASH(0x81bd81c) 'PrintError' => 1
<- STORE= 1 at DBI.pm line 437.
-> STORE for DBD::Oracle::db (DBI::db=HASH(0x81bd81c)~INNER
'AutoCommit' 1)
<- STORE= 1 at DBI.pm line 437.
-> STORE for DBD::Oracle::db (DBI::db=HASH(0x81bd81c)~INNER
'RowCacheSize' -1)
<- STORE= 1 at DBI.pm line 441.
<- connect= DBI::db=HASH(0x81bc818)
-> prepare for DBD::Oracle::db (DBI::db=HASH(0x81bc818)~0x81bd81c
'SELECT field1, field2, field3, field4,
field5, field6, field7, field8, field9, field10, field11, field12, field13,
field14, field15, field16, field17
FROM table_name WHERE rownum <= 1000 AND otherfield IS NULL ORDER BY field5')
New DBI::st (for DBD::Oracle::st, parent=DBI::db=HASH(0x81bd81c), id=)
dbih_setup_handle(DBI::st=HASH(0x81bc83c)=>DBI::st=HASH(0x81bc590),
DBD::Oracle::st, 81bd804, Null!)
dbih_make_com(DBI::db=HASH(0x81bd81c), DBD::Oracle::st, 204)
dbd_st_prepare'd sql SELECT
dbd_describe SELECT (EXPLICIT, lb 80)...
fbh 1: 'FIELD1' NULLable, otype 1-> 5, db
Re: DBD::Pg 0.96 Possible Bug
On Thu, 19 Apr 2001 10:17:44 +0800 (PHT), Victor Michael Blancas alluded:
> Why is it that for DBD::Pg 0.95, the connect string is:
>
> $dbh = DBI->connect("dbi:Pg:dbname=$dbname", $username, $password);
>
> but in DBD::Pg 0.96, this doesn't work. I was only able to connect using
> the following connect string:
>
> $dbh = DBI->connect("dbi:Pg:dbname=$dbname;user=$username;password=$password");
>
> Is this a new DBI spec, or just for DBD::Pg. Could someone enlighten me.
> Thanks.
It's a bug, Here's a patch from Mark Stosberg:
--- Pg.pm.org Sun Apr 15 20:55:37 2001
+++ Pg.pm Sun Apr 15 20:54:07 2001
@@ -79,11 +79,15 @@
$Name =~ s/^.*dbname\s*=\s*//;
$Name =~ s/\s*;.*$//;
-$user = "" unless defined($user);
-$auth = "" unless defined($auth);
+ # if the $user and $auth aren't defined,
+ # first default to $ENV{DBI_USER} and $ENV{DBI_PASS}
+ # and then to "" if they are still undefined
+
+$user = $ENV{DBI_USER} unless defined($user);
+$auth = $ENV{DBI_PASS} unless defined($auth);
-$user = $ENV{DBI_USER} unless $user eq "";
-$auth = $ENV{DBI_PASS} unless $auth eq "";
+$user = "" unless defined($user);
+$auth = "" unless defined($auth);
my($dbh) = DBI::_new_dbh($drh, {
'Name' => $Name,
Jeff
RE: Problem installing DBI on perl 5.004_02
thank you for your answer but the problem is : - all our computer production is in perl 5.004_02 vesion (about 400 scripts) - we have problem with activeperl 5.6 (upper case of environment variables) and if we change the perl version we have to review all the 400 scripts and to test all our computer production it seems to be impossible quickly that's why a precompiled version of perl 5.004_02 with DBI installed woul have been wonderfull ... David -Message d'origine- De : Michael A. Chase [mailto:[EMAIL PROTECTED]] Envoyé : mercredi 18 avril 2001 20:39 À : Brochard, David; [EMAIL PROTECTED] Objet : Re: Problem installing DBI on perl 5.004_02 Unless you have requirements for some modules that ActiveState won't pre-build for you, you should use ActiveState's Perl distribution. Then you can use PPM to install modules that ActiveState has already built for you. Visit http://www.ActiveState.com/ to download it. Perl 5.004_02 is getting a bit old, this would be a good time to upgrade. -- Mac :}) ** I normally forward private database questions to the DBI mail lists. ** Give a hobbit a fish and he'll eat fish for a day. Give a hobbit a ring and he'll eat fish for an age. - Original Message - From: "Brochard, David" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, April 18, 2001 8:21 AM Subject: Problem installing DBI on perl 5.004_02 > I'd like to install DBI on perl 5.004_02 on windows NT 4 but I can't compile > it. > can someone help me find a pre-compiled version for this perl version > or give me any other advise ?
DBD::Pg 0.96 Possible Bug
Why is it that for DBD::Pg 0.95, the connect string is:
$dbh = DBI->connect("dbi:Pg:dbname=$dbname", $username, $password);
but in DBD::Pg 0.96, this doesn't work. I was only able to connect using
the following connect string:
$dbh = DBI->connect("dbi:Pg:dbname=$dbname;user=$username;password=$password");
Is this a new DBI spec, or just for DBD::Pg. Could someone enlighten me.
Thanks.
--
Mike
Re: DB and Access - hanging script
Post a snippet containing the offending code. You might also check out the DBI trace method. "Butler, Jeff" wrote: > > Hi all, > > Don't know if anyone else has encountered this > > I'm using DBI and Access, I insert a number of rows into a table, and then > at the end call prepare and execute an Insert that calls a query for it's > values. If I run the two with seperate processes, this is no problem. If I > try to perform the second insert directly after, the query executes ok, but > on the return from the function the script hangs as if something is going > out of scope. I can trace into OLE.pm, and in the FETCH method it hangs. > Can help with this, I'm kinda at a loss. > > Regards, > Jeff Butler > > > -Original Message- > > From: Prasanna Gopalakrishna [SMTP:[EMAIL PROTECTED]] > > Sent: Wednesday, April 18, 2001 1:47 PM > > To: [EMAIL PROTECTED]; [EMAIL PROTECTED] > > Subject: RE: RE: Error in DBD::Oracle Installation > > Sensitivity: Confidential > > > > Yes. I do have following links in $ORACLE_HOME/lib > > any suggestion? > > > > -rwxr-xr-x 1 oracle 800 6721160 Apr 20 2000 libclntsh.so > > -rwxr-xr-x 1 oracle 800 6796000 Mar 29 09:24 libclntsh.so.1.0 > > -rwxr-xr-x 1 root other6721160 Mar 29 09:21 libclntsh.so.1.0.tmp > > -rw-r--r-- 1 oracle staff9255260 Jun 22 2000 libclntsh.so.8.0 > > > > > > > > > > > > From: Mohanjit Singh <[EMAIL PROTECTED]> > > > Date: 2001/04/17 Tue PM 01:42:49 EDT > > > To: Prasanna Gopalakrishna <[EMAIL PROTECTED]> > > > Subject: RE: RE: Error in DBD::Oracle Installation > > > > > > Do u have following symbolic links under $ORACLE_HOME/lib > > > > > > lrwxrwxrwx 1 root monitor 16 Jul 12 2000 libclntsh.so -> > > > libclntsh.so.8.0 > > > -rwxr-xr-x 1 root monitor 9828696 Jul 12 2000 libclntsh.so.8.0 > > > > > > > > > > > > -Original Message- > > > From: Prasanna Gopalakrishna [mailto:[EMAIL PROTECTED]] > > > Sent: Tuesday, April 17, 2001 1:32 PM > > > To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] > > > Subject: Re: RE: Error in DBD::Oracle Installation > > > Sensitivity: Confidential > > > > > > > > > Still running around with the same problem. I wonder this could be the > > > problem! not sure... > > > > > > i) Do I need to set ORACLE_USER along with ORACLE_HOME, ORACLE_SID, > > > LD_LIBRARY_PATH environment before install DBD::Oracle > > > If yes who? admin or any db-user? > > > > > > > > > ii) also, do need to install any other Oracle client libraries. (Sqlplus > > > works though!) > > > > > > > > > > > > > > > > > > > > From: "Sterin, Ilya" <[EMAIL PROTECTED]> > > > > Date: 2001/04/17 Tue AM 10:50:11 EDT > > > > To: 'Prasanna Gopalakrishna ' <[EMAIL PROTECTED]>, > > "'[EMAIL PROTECTED] '" > > > ><[EMAIL PROTECTED]>, "'[EMAIL PROTECTED] '" <[EMAIL PROTECTED]> > > > > Subject: RE: Error in DBD::Oracle Installation > > > > > > > > Make sure your LD_LIBRARY_PATH is set correctly for the username which > > is > > > > installing DBD::Oracle > > > > > > > > Ilya Sterin > > > > > > > > -Original Message- > > > > From: Prasanna Gopalakrishna > > > > To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; Sterin, Ilya > > > > Sent: 04/17/2001 10:29 AM > > > > Subject: Error in DBD::Oracle Installation > > > > Sensitivity: Confidential > > > > > > > > Hi DBI-USERS, Tim, Ilya, ... > > > > > > > > > > > > I'm trying install DBD::Oracle on Solaris machine and tried all > > options > > > > as mentioned in the README.xxx files. Still having same problem when > > > > running make test. > > > > SQLPLUS works good on this machine. Any suggestions appreciated. > > > > > > > > Thanks > > > > > > > > Find an log for 'make' and 'make test' follows... > > > > > > > > > > > > Sun OS 5.7 > > > > Perl 5.005_03 (provided by Interwoven Teamsite) > > > > Oracle 8.0.3 > > > > DBI-1.15 > > > > DBD-Oracle-1.06 > > > > > > > > > > > > > > > > > > > > # make > > > > mkdir blib > > > > mkdir blib/lib > > > > mkdir blib/lib/DBD > > > > mkdir blib/arch > > > > mkdir blib/arch/auto > > > > mkdir blib/arch/auto/DBD > > > > mkdir blib/arch/auto/DBD/Oracle > > > > mkdir blib/lib/auto > > > > mkdir blib/lib/auto/DBD > > > > mkdir blib/lib/auto/DBD/Oracle > > > > mkdir blib/man1 > > > > mkdir blib/man3 > > > > cp Oraperl.pm blib/lib/Oraperl.pm > > > > cp Oracle.pm blib/lib/DBD/Oracle.pm > > > > cp oraperl.ph blib/lib/oraperl.ph > > > > /home/iw-home/iw-perl/bin/perl -p -e "s/~DRIVER~/Oracle/g" < > > > > > > /home/iw-home/iw-perl/lib/perl5/site_perl/5.005/sun4-solaris/auto/DBI/Dr > > > > iver.xst > Oracle.xsi > > > > /home/iw-home/iw-perl/bin/perl > > > > -I/home/iw-home/iw-perl/lib/perl5/5.00503/sun4-solaris > > > > -I/home/iw-home/iw-perl/lib/perl5/5.00503 > > > > /home/iw-home/iw-perl/lib/perl5/5.00503/ExtUtils/xsubpp -typemap > > > > /home/iw-home/iw-perl/lib/perl5/5.00503/ExtUtils/typemap Oracle.xs > > > > >xstmp.c && mv xstmp.c Oracle.c > > > > gcc -c -I. -I/home/oracle/precomp/public -I/home/oracle
Re: DBI-1.15 and DBD-Oracle-1.06 (2nd)
Did you install DBI and DBD-Oracle .. If you dont install DBD-Oracle you cannot connect to Database.. Rajanath - Original Message - From: "Tuanjai Sampannon" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Wednesday, April 18, 2001 11:48 AM Subject: DBI-1.15 and DBD-Oracle-1.06 (2nd) > Dear reader, > > I am trying to setup the following: > - Perl 5.6.1 > - Tk 800.022 > - DBI-1.15 > - DBD-Oracle-1.06 > - Oracle8i Enterprise Edition Release 8.1.6.0.0 > On Intel Solaris 8... > > To my knowledge these are the latest versions available... > > I am getting to DBD and there to make test, and then it fails... > > To be precise: I am getting core dumps while doing the tests... > If I ignore these and do 'make install', than I can connect to the database, > and retrieve some data, but I get a core dump at the end anyway... > > Please, I am a newbie to Perl, please help me! What am I doing wrong??? > > I am compiling Perl and DBD with the same compiler... > I have set ORACLE_SID, ORACLE_HOME, LD_LIBRARY_PATH, LD_RUN_PATH... > I can connect with Oracle using SLQ*Plus... > > What am I doing wrong??? I am desperate!!! > > With kind regards, > > Roland Slegers > [EMAIL PROTECTED] > > == > make test TEST_VERBOSE=1 > == > PERL_DL_NONLAZY=1 > /usr/bin/perl -Iblib/arch -Iblib/lib -I/usr/local/lib/perl5/5.6.1/i86pc-sola > ris -I/usr/local/lib/perl5/5.6.1 -e 'use Test::Harness qw(&runtests > $verbose); $verbose=1; runtests @ARGV;' t/*.t > t/base..dubious > Test returned status 0 (wstat 139, 0x8b) > test program seems to have generated a core > t/general...1..16 > ok 1 > ok 2 > dubious > Test returned status 0 (wstat 139, 0x8b) > test program seems to have generated a core > DIED. FAILED tests 3-16 > Failed 14/16 tests, 12.50% okay > t/long..create table dbd_ora__drop_me ( idx integer, lng LONG, > dt date ) > 1..140 > long_data0 length 10240 > long_data1 length 81920 > long_data2 length 71680 > create table dbd_ora__drop_me ( idx integer, lng LONG, dt date ) > --- insert some LONG data > ok 1 > ok 2 > ok 3 > ok 4 > --- fetch LONG data back again -- truncated - LongTruncOk == 1 > LongReadLen 20, LongTruncOk 1 > ok 5 > ok 6 > ok 7 > ok 8 > ok 9 > ok 10 > --- fetch LONG data back again -- truncated - LongTruncOk == 0 > LongReadLen 81910, LongTruncOk > ok 11 > ok 12 > ok 13 > ok 14 > ok 15 > ok 16 > --- fetch LONG data back again -- complete - LongTruncOk == 0 > LongReadLen 82920, LongTruncOk > ok 17 > ok 18 > ok 19 > ok 20 > ok 21 > ok 22 > ok 23 > ok 24 > --- fetch LONG data back again -- via blob_read > Skipped blob_read tests for LONGs with OCI8 - not currently supported. > ok 25 > ok 26 > ok 27 > ok 28 > ok 29 > ok 30 > ok 31 > ok 32 > ok 33 > ok 34 > ok 35 > long_data0 length 20480 > long_data1 length 81920 > long_data2 length 71680 > create table dbd_ora__drop_me ( idx integer, lng LONG RAW, dt date ) > --- insert some LONG RAW data > ok 36 > ok 37 > ok 38 > ok 39 > --- fetch LONG RAW data back again -- truncated - LongTruncOk == 1 > LongReadLen 20, LongTruncOk 1 > ok 40 > ok 41 > ok 42 > ok 43 > ok 44 > ok 45 > --- fetch LONG RAW data back again -- truncated - LongTruncOk == 0 > LongReadLen 40955, LongTruncOk > ok 46 > ok 47 > ok 48 > ok 49 > ok 50 > ok 51 > --- fetch LONG RAW data back again -- complete - LongTruncOk == 0 > LongReadLen 82920, LongTruncOk > ok 52 > ok 53 > ok 54 > ok 55 > ok 56 > ok 57 > ok 58 > ok 59 > --- fetch LONG RAW data back again -- via blob_read > Skipped blob_read tests for LONGs with OCI8 - not currently supported. > ok 60 > ok 61 > ok 62 > ok 63 > ok 64 > ok 65 > ok 66 > ok 67 > ok 68 > ok 69 > ok 70 > long_data0 length 10240 > long_data1 length 81920 > long_data2 length 71680 > create table dbd_ora__drop_me ( idx integer, lng CLOB, dt date ) > --- insert some CLOB data > ok 71 > ok 72 > ok 73 > ok 74 > --- fetch CLOB data back again -- truncated - LongTruncOk == 1 > LongReadLen 20, LongTruncOk 1 > ok 75 > ok 76 > ok 77 > ok 78 > ok 79 > ok 80 > --- fetch CLOB data back again -- truncated - LongTruncOk == 0 > LongReadLen 81910, LongTruncOk > ok 81 > ok 82 > ok 83 > ok 84 > ok 85 > ok 86 > --- fetch CLOB data back again -- complete - LongTruncOk == 0 > LongReadLen 82920, LongTruncOk > ok 87 > ok 88 > ok 89 > ok 90 > ok 91 > ok 92 > ok 93 > ok 94 > --- fetch CLOB data back again -- via blob_read > ok 95 > ok 96 > ok 97 > ok 98 > ok 99 > ok 100 > ok 101 > ok 102 > ok 103 > ok 104 > ok 105 > long_data0 length 10240 > long_data1 length 81920 > long_data2 length 71680 > create table dbd_ora__drop_me ( idx integer, lng BLOB, dt date ) > --- insert some BLOB data > ok 106 > ok 107 > ok 108 > ok 109 > --- fetch BLOB data back again -- truncated - LongTruncOk == 1 > LongReadLen 20, LongTruncOk 1 > ok 110 > ok 111 > ok 112 > ok 113 > ok 114 > ok 115 > --- fetch BLOB data ba
DBI-1.15 and DBD-Oracle-1.06 (2nd)
Dear reader, I am trying to setup the following: - Perl 5.6.1 - Tk 800.022 - DBI-1.15 - DBD-Oracle-1.06 - Oracle8i Enterprise Edition Release 8.1.6.0.0 On Intel Solaris 8... To my knowledge these are the latest versions available... I am getting to DBD and there to make test, and then it fails... To be precise: I am getting core dumps while doing the tests... If I ignore these and do 'make install', than I can connect to the database, and retrieve some data, but I get a core dump at the end anyway... Please, I am a newbie to Perl, please help me! What am I doing wrong??? I am compiling Perl and DBD with the same compiler... I have set ORACLE_SID, ORACLE_HOME, LD_LIBRARY_PATH, LD_RUN_PATH... I can connect with Oracle using SLQ*Plus... What am I doing wrong??? I am desperate!!! With kind regards, Roland Slegers [EMAIL PROTECTED] == make test TEST_VERBOSE=1 == PERL_DL_NONLAZY=1 /usr/bin/perl -Iblib/arch -Iblib/lib -I/usr/local/lib/perl5/5.6.1/i86pc-sola ris -I/usr/local/lib/perl5/5.6.1 -e 'use Test::Harness qw(&runtests $verbose); $verbose=1; runtests @ARGV;' t/*.t t/base..dubious Test returned status 0 (wstat 139, 0x8b) test program seems to have generated a core t/general...1..16 ok 1 ok 2 dubious Test returned status 0 (wstat 139, 0x8b) test program seems to have generated a core DIED. FAILED tests 3-16 Failed 14/16 tests, 12.50% okay t/long..create table dbd_ora__drop_me ( idx integer, lng LONG, dt date ) 1..140 long_data0 length 10240 long_data1 length 81920 long_data2 length 71680 create table dbd_ora__drop_me ( idx integer, lng LONG, dt date ) --- insert some LONG data ok 1 ok 2 ok 3 ok 4 --- fetch LONG data back again -- truncated - LongTruncOk == 1 LongReadLen 20, LongTruncOk 1 ok 5 ok 6 ok 7 ok 8 ok 9 ok 10 --- fetch LONG data back again -- truncated - LongTruncOk == 0 LongReadLen 81910, LongTruncOk ok 11 ok 12 ok 13 ok 14 ok 15 ok 16 --- fetch LONG data back again -- complete - LongTruncOk == 0 LongReadLen 82920, LongTruncOk ok 17 ok 18 ok 19 ok 20 ok 21 ok 22 ok 23 ok 24 --- fetch LONG data back again -- via blob_read Skipped blob_read tests for LONGs with OCI8 - not currently supported. ok 25 ok 26 ok 27 ok 28 ok 29 ok 30 ok 31 ok 32 ok 33 ok 34 ok 35 long_data0 length 20480 long_data1 length 81920 long_data2 length 71680 create table dbd_ora__drop_me ( idx integer, lng LONG RAW, dt date ) --- insert some LONG RAW data ok 36 ok 37 ok 38 ok 39 --- fetch LONG RAW data back again -- truncated - LongTruncOk == 1 LongReadLen 20, LongTruncOk 1 ok 40 ok 41 ok 42 ok 43 ok 44 ok 45 --- fetch LONG RAW data back again -- truncated - LongTruncOk == 0 LongReadLen 40955, LongTruncOk ok 46 ok 47 ok 48 ok 49 ok 50 ok 51 --- fetch LONG RAW data back again -- complete - LongTruncOk == 0 LongReadLen 82920, LongTruncOk ok 52 ok 53 ok 54 ok 55 ok 56 ok 57 ok 58 ok 59 --- fetch LONG RAW data back again -- via blob_read Skipped blob_read tests for LONGs with OCI8 - not currently supported. ok 60 ok 61 ok 62 ok 63 ok 64 ok 65 ok 66 ok 67 ok 68 ok 69 ok 70 long_data0 length 10240 long_data1 length 81920 long_data2 length 71680 create table dbd_ora__drop_me ( idx integer, lng CLOB, dt date ) --- insert some CLOB data ok 71 ok 72 ok 73 ok 74 --- fetch CLOB data back again -- truncated - LongTruncOk == 1 LongReadLen 20, LongTruncOk 1 ok 75 ok 76 ok 77 ok 78 ok 79 ok 80 --- fetch CLOB data back again -- truncated - LongTruncOk == 0 LongReadLen 81910, LongTruncOk ok 81 ok 82 ok 83 ok 84 ok 85 ok 86 --- fetch CLOB data back again -- complete - LongTruncOk == 0 LongReadLen 82920, LongTruncOk ok 87 ok 88 ok 89 ok 90 ok 91 ok 92 ok 93 ok 94 --- fetch CLOB data back again -- via blob_read ok 95 ok 96 ok 97 ok 98 ok 99 ok 100 ok 101 ok 102 ok 103 ok 104 ok 105 long_data0 length 10240 long_data1 length 81920 long_data2 length 71680 create table dbd_ora__drop_me ( idx integer, lng BLOB, dt date ) --- insert some BLOB data ok 106 ok 107 ok 108 ok 109 --- fetch BLOB data back again -- truncated - LongTruncOk == 1 LongReadLen 20, LongTruncOk 1 ok 110 ok 111 ok 112 ok 113 ok 114 ok 115 --- fetch BLOB data back again -- truncated - LongTruncOk == 0 LongReadLen 81910, LongTruncOk ok 116 ok 117 ok 118 ok 119 ok 120 ok 121 --- fetch BLOB data back again -- complete - LongTruncOk == 0 LongReadLen 82920, LongTruncOk ok 122 ok 123 ok 124 ok 125 ok 126 ok 127 ok 128 ok 129 --- fetch BLOB data back again -- via blob_read ok 130 ok 131 ok 132 ok 133 ok 134 ok 135 ok 136 ok 137 ok 138 ok 139 ok 140 ok t/plsql.1..63 ok 1 ok 2 ok 3 ok 4 ok 5 ok 6 ok 7 ok 8 ok 9 ok 10 ok 11 ok 12 ok 13 ok 14 ok 15 ok 16 ok 17 ok 18 ok 19 ok 20 ok 21 ok 22 ok 23 ok 24 ok 25 ok 26 ok 27 ok 28 ok 29 ok 30 ok 31 ok 32 ok 33 ok 34 ok 35 ok 36 ok 37 ok 38 ok 39 ok 40 ok 41 ok 42 ok 43 ok 44 ok 45 ok 46 ok 47 ok 48 ok 49 ok 50 ok 51 ok 52 ok 53 ok 54 dubi
RE: MS ACCESS Date Fields
I'm not positive if your actual statement looks like your model you gave to us, but the main thing I see wrong with your model is how you are using BETWEEN. If you have the Northwind Traders example database, here is an example query to do basically the same thing: SELECT * FROM Orders WHERE RequiredDate BETWEEN '01/01/1996' AND '08/15/1996' See if that syntax works better for you. If it's something more than that, reply back, and I'm sure we can get that working. Steve Howard. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 18, 2001 2:23 PM To: [EMAIL PROTECTED] Subject: MS ACCESS Date Fields Hello, i'm using Perl/DBI/CGI to connect to an MS ACCESS database on the same server. I can use SELECT and fetch data and pass it to the browser, works fine. But now I need to use some kind of BETWEEN sql statement that will let me filter records for a specific period of time. Something like: "SELECT * from table WHERE x=y AND date x BETWEEN y". I don't know how to use the filter with the ACCESS dates records. I am also using the Format Format(tbl1.date, 'mm-dd-yy') command to get ride off the extra 00:00:00 that I would get if I don't use format. Please any ideas? Thanks, Miguel
(Fwd) using perl with oracle 8.1.6
- Forwarded message from Yoel Steinmets - B&H Photo Video <[EMAIL PROTECTED]> - From: Yoel Steinmets - B&H Photo Video <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] Date: Wed, 18 Apr 2001 14:45:42 -0400 Subject: using perl with oracle 8.1.6 Priority: normal Hi Tim maybe you can help me with this i updated my Oracle datebase from 8.1.50 to 8.1.6 and now i cant connect to Oracle i am getting install_driver(Oracle) failed: Can't load '/usr/local/lib/perl5/site_perl/5.005/sun4-solaris/auto/DBD/Oracle/O racle.so' for module DBD::Oracle: ld.so.1: /usr/local/bin/perl: fatal: relocation error: file /usr/local/lib/p erl5/site_perl/5.005/sun4-solaris/auto/DBD/Oracle/Oracle.so: symbol nauzaoss: referenced symbol not found at / usr/local/lib/perl5/5.00503/sun4-solaris/DynaLoader.pm line 169. at (eval 4) line 3 however if my invironment variables is pointing to the old version i have no problaims i appriciate your help my email [EMAIL PROTECTED] phone 212-239-7500 X2167 thank you - End forwarded message -
Re: Error in DBD::Oracle Installation
Prasanna, The error messages : ORA-01034: ORACLE not available ORA-07429: smsgsg: shmget() failed to get segment. SVR4 Error: 2: No such file or directory Usually mean that either your database isn't started or your ORACLE_HOME or ORACLE_SID environment variable is not set correctly. Also: if you are still using Oracle 8.0.3, I strongly advise to upgrade to at least 8.0.6, and better to 8.1.7. 8.0.3 is since long desupported. The upgrade is free if you have a valid support contract. Hope this helps, Mark Prasanna Gopalakrishna wrote: > Thanks Mac, > > I did find 'oraenv' files in two directories: > /home/oracle/app/oracle/product/8.0.3 > /home/oracle > > Initially I tried for /home/oracle now I tried for >/home/oracle/app/oracle/product/8.0.3 > > Sqlplus works from this directory also! But now I got the different error while >'make test'. > > Also I found an symbolic reerence in /home/oracle/app/oracle/product/8.0.3/lib >directory > > lrwxrwxrwx 1 oracle 800 16 Oct 11 2000 libclntsh.so -> >libclntsh.so.1.0 > > Error goes like this... > - > # make test > PERL_DL_NONLAZY=1 /home/iw-home/iw-perl/bin/perl -Iblib/arch -Iblib/lib >-I/home/iw-home/iw-perl/lib/perl5/5.00503/sun4-solaris >-I/home/iw-home/iw-perl/lib/perl5/5.00503 -e 'use Test::Harness qw(&runtests >$verbose); $verbose=0; runtests @ARGV;' t/*.t > t/base..ok > t/general...DBI->connect() failed: ORA-01034: ORACLE not available > ORA-07429: smsgsg: shmget() failed to get segment. > SVR4 Error: 2: No such file or directory (DBD ERROR: OCISessionBegin) at t/general.t >line 20 > Unable to connect to Oracle (ORA-01034: ORACLE not available > ORA-07429: smsgsg: shmget() failed to get segment. > SVR4 Error: 2: No such file or directory (DBD ERROR: OCISessionBegin)) > Tests skiped. > skipping test on this platform > t/long..Unable to connect to Oracle (ORA-01034: ORACLE not available > ORA-07429: smsgsg: shmget() failed to get segment. > SVR4 Error: 2: No such file or directory (DBD ERROR: OCISessionBegin)) > Tests skiped. > skipping test on this platform > t/plsql.Unable to connect to Oracle (ORA-01034: ORACLE not available > ORA-07429: smsgsg: shmget() failed to get segment. > SVR4 Error: 2: No such file or directory (DBD ERROR: OCISessionBegin)) > Tests skiped. > skipping test on this platform > t/reauthskipping test on this platform > All tests successful, 4 tests skipped. > Files=5, Tests=5, 2 wallclock secs ( 1.05 cusr + 0.19 csys = 1.24 CPU) > PERL_DL_NONLAZY=1 /home/iw-home/iw-perl/bin/perl -Iblib/arch -Iblib/lib >-I/home/iw-home/iw-perl/lib/perl5/5.00503/sun4-solaris >-I/home/iw-home/iw-perl/lib/perl5/5.00503 test.pl > Oraperl test application $Revision: 1.2 $ > > Oraperl emulation interface version 1.39 > DBD::Oracle 1.06 using OCI8 by Tim Bunce > DBI 1.15 by Tim Bunce > > Data sources: > dbi:Oracle:CSPET101.WORLD > dbi:Oracle:DEV > dbi:Oracle:mts > dbi:Oracle:pandg1 > dbi:Oracle:pandg2 > dbi:Oracle:pandg2_new > dbi:Oracle:pgdb > dbi:Oracle:pgprod > dbi:Oracle:staging > > Connecting > to '' (from command line, else uses ORACLE_SID or TWO_TASK - recommended) > as 'scott/tiger' (via ORACLE_USERID env var or default - recommend >name/passwd@dbname) > (ORACLE_SID='CSPET101.WORLD', TWO_TASK='') > ora_login: 1034: ORA-01034: ORACLE not available > ORA-07429: smsgsg: shmget() failed to get segment. > SVR4 Error: 2: No such file or directory (DBD ERROR: OCISessionBegin) > > ORACLE_SID or TWO_TASK possibly not right, or server not running. > > Generally set TWO_TASK or ORACLE_SID but not both at the same time. > Try to connect to the database using an oracle tool like sqlplus > only if that works should you suspect problems with DBD::Oracle. > Try leaving dbname value empty and set dbuser to name/passwd@dbname. > > Test aborted. > *** Error code 255 > make: Fatal error: Command failed for target `test_dynamic' > - > > > From: "Michael A. Chase" <[EMAIL PROTECTED]> > > Date: 2001/04/18 Wed AM 11:45:27 EDT > > To: "Prasanna Gopalakrishna" <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]> > > Subject: Re: Re: Error in DBD::Oracle Installation > > > > In UNIX, there should be a script called 'oraenv' you can source to set the > > necessary variables. > > > > In WinXx, the Oracle installer puts ORACLE_HOME directory names in the > > registry. Often software will work better if the environment variable > > ORACLE_HOME is set to the same directory. > > > > Note that the home directory of the OS user "oracle" is not the same thing > > as the directory pointed to by ORACLE_HOME. > > -- > > Mac :}) > > ** I normally forward private database questions to the DBI mail lists. ** > > Give a hobbit a fish and he'll eat fish for a day. > > Give a hobbit a ring and he'll eat fish for an age. > > - Original Message - > > From:
Re: Re: Error in DBD::Oracle Installation
Thanks Mac, I did find 'oraenv' files in two directories: /home/oracle/app/oracle/product/8.0.3 /home/oracle Initially I tried for /home/oracle now I tried for /home/oracle/app/oracle/product/8.0.3 Sqlplus works from this directory also! But now I got the different error while 'make test'. Also I found an symbolic reerence in /home/oracle/app/oracle/product/8.0.3/lib directory lrwxrwxrwx 1 oracle 800 16 Oct 11 2000 libclntsh.so -> libclntsh.so.1.0 Error goes like this... - # make test PERL_DL_NONLAZY=1 /home/iw-home/iw-perl/bin/perl -Iblib/arch -Iblib/lib -I/home/iw-home/iw-perl/lib/perl5/5.00503/sun4-solaris -I/home/iw-home/iw-perl/lib/perl5/5.00503 -e 'use Test::Harness qw(&runtests $verbose); $verbose=0; runtests @ARGV;' t/*.t t/base..ok t/general...DBI->connect() failed: ORA-01034: ORACLE not available ORA-07429: smsgsg: shmget() failed to get segment. SVR4 Error: 2: No such file or directory (DBD ERROR: OCISessionBegin) at t/general.t line 20 Unable to connect to Oracle (ORA-01034: ORACLE not available ORA-07429: smsgsg: shmget() failed to get segment. SVR4 Error: 2: No such file or directory (DBD ERROR: OCISessionBegin)) Tests skiped. skipping test on this platform t/long..Unable to connect to Oracle (ORA-01034: ORACLE not available ORA-07429: smsgsg: shmget() failed to get segment. SVR4 Error: 2: No such file or directory (DBD ERROR: OCISessionBegin)) Tests skiped. skipping test on this platform t/plsql.Unable to connect to Oracle (ORA-01034: ORACLE not available ORA-07429: smsgsg: shmget() failed to get segment. SVR4 Error: 2: No such file or directory (DBD ERROR: OCISessionBegin)) Tests skiped. skipping test on this platform t/reauthskipping test on this platform All tests successful, 4 tests skipped. Files=5, Tests=5, 2 wallclock secs ( 1.05 cusr + 0.19 csys = 1.24 CPU) PERL_DL_NONLAZY=1 /home/iw-home/iw-perl/bin/perl -Iblib/arch -Iblib/lib -I/home/iw-home/iw-perl/lib/perl5/5.00503/sun4-solaris -I/home/iw-home/iw-perl/lib/perl5/5.00503 test.pl Oraperl test application $Revision: 1.2 $ Oraperl emulation interface version 1.39 DBD::Oracle 1.06 using OCI8 by Tim Bunce DBI 1.15 by Tim Bunce Data sources: dbi:Oracle:CSPET101.WORLD dbi:Oracle:DEV dbi:Oracle:mts dbi:Oracle:pandg1 dbi:Oracle:pandg2 dbi:Oracle:pandg2_new dbi:Oracle:pgdb dbi:Oracle:pgprod dbi:Oracle:staging Connecting to '' (from command line, else uses ORACLE_SID or TWO_TASK - recommended) as 'scott/tiger' (via ORACLE_USERID env var or default - recommend name/passwd@dbname) (ORACLE_SID='CSPET101.WORLD', TWO_TASK='') ora_login: 1034: ORA-01034: ORACLE not available ORA-07429: smsgsg: shmget() failed to get segment. SVR4 Error: 2: No such file or directory (DBD ERROR: OCISessionBegin) ORACLE_SID or TWO_TASK possibly not right, or server not running. Generally set TWO_TASK or ORACLE_SID but not both at the same time. Try to connect to the database using an oracle tool like sqlplus only if that works should you suspect problems with DBD::Oracle. Try leaving dbname value empty and set dbuser to name/passwd@dbname. Test aborted. *** Error code 255 make: Fatal error: Command failed for target `test_dynamic' - > From: "Michael A. Chase" <[EMAIL PROTECTED]> > Date: 2001/04/18 Wed AM 11:45:27 EDT > To: "Prasanna Gopalakrishna" <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]> > Subject: Re: Re: Error in DBD::Oracle Installation > > In UNIX, there should be a script called 'oraenv' you can source to set the > necessary variables. > > In WinXx, the Oracle installer puts ORACLE_HOME directory names in the > registry. Often software will work better if the environment variable > ORACLE_HOME is set to the same directory. > > Note that the home directory of the OS user "oracle" is not the same thing > as the directory pointed to by ORACLE_HOME. > -- > Mac :}) > ** I normally forward private database questions to the DBI mail lists. ** > Give a hobbit a fish and he'll eat fish for a day. > Give a hobbit a ring and he'll eat fish for an age. > - Original Message - > From: "Prasanna Gopalakrishna" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> > Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> > Sent: Wednesday, April 18, 2001 8:07 AM > Subject: Re: Re: Error in DBD::Oracle Installation > > > > * How do I find the home directory of the "oracle" user > > * Oracle client installed and I connecting remotely to database using > sqlplus > > * is there any db driver mismatch > > >
MS ACCESS Date Fields
Hello, i'm using Perl/DBI/CGI to connect to an MS ACCESS database on the same server. I can use SELECT and fetch data and pass it to the browser, works fine. But now I need to use some kind of BETWEEN sql statement that will let me filter records for a specific period of time. Something like: "SELECT * from table WHERE x=y AND date x BETWEEN y". I don't know how to use the filter with the ACCESS dates records. I am also using the Format Format(tbl1.date, 'mm-dd-yy') command to get ride off the extra 00:00:00 that I would get if I don't use format. Please any ideas? Thanks, Miguel
InterScan NT Alert
Receiver, InterScan has detected virus(es) in the e-mail attachment. Date: Thu, 19 Apr 2001 05:24:00 +1000 (AUS Eastern Standard Time) Method: Mail From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> File: hpux, osvers=10, archname=s700 uname='hp-ux nrtphcd9 b.10.20 e 9000831 2000300077 8-user license ' hint=recommended, useposix=true, d_sigaction=define bincompat3=n useperlio= d_sfio= Compiler: cc='cc', optimize='-O', gccversion= cppflags='-D_HPUX_SOURCE -Aa' ccflags ='-D_HPUX_SOURCE -Aa' stdchar='unsigned char', d_stdstdio=define, usevfork=false voidflags=15, castflags=0, d_casti32=define, d_castneg=define intsize=4, alignbytes=8, usemymalloc=y, randbits=15 Linker and Libraries: ld='ld' Action: cleaned Virus: Email_Flaw_MIME_Tag_Overflow
Help needed on DBD::Oracle,please
Hi ,
Iam a newbie to DBI/DBD. I face a problem in connecting to a remote Oracle
database ( on a different machine)
thru DBD::Oracle from my machine.
I use perl 5.004 ,DBI 1.15 , DBD 1.06 , Oracle 7.16(local client ) and Oracle7 Server
Release 7.3.4.5.0 (remote Oracle server )
My machine is a B2000 HPUX Box.And iam pretty sure that the remote database is also
on a HPUX box.
Since i dont need a local database in my node , i installed only the Oracle client
(sqlplus,sqlnet v2) in my node.
Here's the list of Oracle components installed locally on my machine:
==
Sqlplus 3.1.3.7.1
Sqlnet V2 2.1.6.1.0
Sqlnet TCP(V1) 1.2.7.8.1
Oracle network manager 2.1.6.0.0
TCP-IP Protocol adaptor V2 2.1.6.1.0
Pro*C 2.0.6.0.0
PL/SQL V2 2.1.6.2.0
==
Here's my piece of code:
#!/usr/bin/perl -w
use DBI;
$ENV{'ORACLE_SID'}='IRDO';
$ENV{'ORACLE_HOME'}='/home/oracle/7.1.6';
print ("check 1\n");
$dbh = DBI->connect('dbi:Oracle:IRDO@bcarhzq0:1521', 'User' , 'Pass') || die
$DBI::errstr;
print ("check 2\n");
$dbh->disconnect;
=
when executed :
mynode $> perl dbi_test.pl
check 1
and then it just hangs and gives no error message.I have to do a to get back
my prompt.
I have attatched oracle installation log (oracle_install.log) , DBI installation log (
DBI_install.log) and
DBD installation log (DBD_install.log) with this mail.
However DBD 'make test' failed ,may be because of the absence of a local database.
I've also created a tnsnames.ora file in $ORACLE_HOME/network/admin and here's the
file contents:
==
IRDO =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = oraottawa.world)
(PROTOCOL = TCP)
(Host = bcarhzq0)
(Port = 1521)
)
)
(CONNECT_DATA =
(SID = IRDO)
(GLOBAL_NAME = irdo.world)
)
)
===
However, I can use sqlplus to connect to the remote database from
my node and execute SQL statements ?
Can you please suggest me what can be done to test my environment extensively ?
I would really appreciate if u could help me in this regard.
Glossary :
===
Here's the Perl -V 's output from my machine:
--
Summary of my perl5 (5.0 patchlevel 4 subversion 0) configuration:
Platform:
osname=hpux, osvers=10, archname=s700
uname='hp-ux nrtphcd9 b.10.20 e 9000831 2000300077 8-user license '
hint=recommended, useposix=true, d_sigaction=define
bincompat3=n useperlio= d_sfio=
Compiler:
cc='cc', optimize='-O', gccversion=
cppflags='-D_HPUX_SOURCE -Aa'
ccflags ='-D_HPUX_SOURCE -Aa'
stdchar='unsigned char', d_stdstdio=define, usevfork=false
voidflags=15, castflags=0, d_casti32=define, d_castneg=define
intsize=4, alignbytes=8, usemymalloc=y, randbits=15
Linker and Libraries:
ld='ld', ldflags =''
libpth=/lib/pa1.1 /lib /usr/lib /usr/ccs/lib
libs=-lnet -lnsl_s -lndbm -ldld -lm -lc -lndir -lcrypt
libc=/lib/libc.sl, so=sl
useshrplib=false, libperl=libperl.a
Dynamic Linking:
dlsrc=dl_hpux.xs, dlext=sl, d_dlsymun=, ccdlflags='-Wl,-E -Wl,-B,deferred '
cccdlflags='+z', lddlflags='-b'
Characteristics of this binary (from libperl):
Built under hpux
Compiled at Oct 3 1997 10:20:34
@INC:
/opt/corp/local/perl-5.004/lib/s700/5.004
/opt/corp/local/perl-5.004/lib
/opt/corp/local/perl-5.004/lib/site_perl/s700
/opt/corp/local/perl-5.004/lib/site_perl
.-
Thanx & Regards,
S Bala
3500 Carling Ave, Ottawa ON, K2H8E9
ESN: 6-398-0247
---
FREE! The World's Best Email Address @email.com
Reserve your name now at http://www.email.com
DBI_install.log
DBD_install.log
oracle_install.log
Re: Re: Error in DBD::Oracle Installation
In UNIX, there should be a script called 'oraenv' you can source to set the necessary variables. In WinXx, the Oracle installer puts ORACLE_HOME directory names in the registry. Often software will work better if the environment variable ORACLE_HOME is set to the same directory. Note that the home directory of the OS user "oracle" is not the same thing as the directory pointed to by ORACLE_HOME. -- Mac :}) ** I normally forward private database questions to the DBI mail lists. ** Give a hobbit a fish and he'll eat fish for a day. Give a hobbit a ring and he'll eat fish for an age. - Original Message - From: "Prasanna Gopalakrishna" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Wednesday, April 18, 2001 8:07 AM Subject: Re: Re: Error in DBD::Oracle Installation > * How do I find the home directory of the "oracle" user > * Oracle client installed and I connecting remotely to database using sqlplus > * is there any db driver mismatch
Re: Problem installing DBI on perl 5.004_02
Unless you have requirements for some modules that ActiveState won't pre-build for you, you should use ActiveState's Perl distribution. Then you can use PPM to install modules that ActiveState has already built for you. Visit http://www.ActiveState.com/ to download it. Perl 5.004_02 is getting a bit old, this would be a good time to upgrade. -- Mac :}) ** I normally forward private database questions to the DBI mail lists. ** Give a hobbit a fish and he'll eat fish for a day. Give a hobbit a ring and he'll eat fish for an age. - Original Message - From: "Brochard, David" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, April 18, 2001 8:21 AM Subject: Problem installing DBI on perl 5.004_02 > I'd like to install DBI on perl 5.004_02 on windows NT 4 but I can't compile > it. > can someone help me find a pre-compiled version for this perl version > or give me any other advise ?
RE: RE: Error in DBD::Oracle Installation
Try it out -Original Message- From: Prasanna Gopalakrishna [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 18, 2001 6:12 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: RE: Error in DBD::Oracle Installation Sensitivity: Confidential I don't have any symbolic links for libclntsh.so->libclntsh.so.8.0 in $ORACLE_HOME/lib Do I need ? > > From: Mohanjit Singh <[EMAIL PROTECTED]> > Date: 2001/04/17 Tue PM 01:42:49 EDT > To: Prasanna Gopalakrishna <[EMAIL PROTECTED]> > Subject: RE: RE: Error in DBD::Oracle Installation > > Do u have following symbolic links under $ORACLE_HOME/lib > > lrwxrwxrwx 1 root monitor 16 Jul 12 2000 libclntsh.so -> > libclntsh.so.8.0 > -rwxr-xr-x 1 root monitor 9828696 Jul 12 2000 libclntsh.so.8.0 > > > > -Original Message- > From: Prasanna Gopalakrishna [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, April 17, 2001 1:32 PM > To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] > Subject: Re: RE: Error in DBD::Oracle Installation > Sensitivity: Confidential > > > Still running around with the same problem. I wonder this could be the > problem! not sure... > > i) Do I need to set ORACLE_USER along with ORACLE_HOME, ORACLE_SID, > LD_LIBRARY_PATH environment before install DBD::Oracle > If yes who? admin or any db-user? > > > ii) also, do need to install any other Oracle client libraries. (Sqlplus > works though!) > > > > > > > > From: "Sterin, Ilya" <[EMAIL PROTECTED]> > > Date: 2001/04/17 Tue AM 10:50:11 EDT > > To: 'Prasanna Gopalakrishna ' <[EMAIL PROTECTED]>, "'[EMAIL PROTECTED] '" > > <[EMAIL PROTECTED]>, "'[EMAIL PROTECTED] '" <[EMAIL PROTECTED]> > > Subject: RE: Error in DBD::Oracle Installation > > > > Make sure your LD_LIBRARY_PATH is set correctly for the username which is > > installing DBD::Oracle > > > > Ilya Sterin > > > > -Original Message- > > From: Prasanna Gopalakrishna > > To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; Sterin, Ilya > > Sent: 04/17/2001 10:29 AM > > Subject: Error in DBD::Oracle Installation > > Sensitivity: Confidential > > > > Hi DBI-USERS, Tim, Ilya, ... > > > > > > I'm trying install DBD::Oracle on Solaris machine and tried all options > > as mentioned in the README.xxx files. Still having same problem when > > running make test. > > SQLPLUS works good on this machine. Any suggestions appreciated. > > > > Thanks > > > > Find an log for 'make' and 'make test' follows... > > > > > > Sun OS 5.7 > > Perl 5.005_03 (provided by Interwoven Teamsite) > > Oracle 8.0.3 > > DBI-1.15 > > DBD-Oracle-1.06 > > > > > > > > > > # make > > mkdir blib > > mkdir blib/lib > > mkdir blib/lib/DBD > > mkdir blib/arch > > mkdir blib/arch/auto > > mkdir blib/arch/auto/DBD > > mkdir blib/arch/auto/DBD/Oracle > > mkdir blib/lib/auto > > mkdir blib/lib/auto/DBD > > mkdir blib/lib/auto/DBD/Oracle > > mkdir blib/man1 > > mkdir blib/man3 > > cp Oraperl.pm blib/lib/Oraperl.pm > > cp Oracle.pm blib/lib/DBD/Oracle.pm > > cp oraperl.ph blib/lib/oraperl.ph > > /home/iw-home/iw-perl/bin/perl -p -e "s/~DRIVER~/Oracle/g" < > > /home/iw-home/iw-perl/lib/perl5/site_perl/5.005/sun4-solaris/auto/DBI/Dr > > iver.xst > Oracle.xsi > > /home/iw-home/iw-perl/bin/perl > > -I/home/iw-home/iw-perl/lib/perl5/5.00503/sun4-solaris > > -I/home/iw-home/iw-perl/lib/perl5/5.00503 > > /home/iw-home/iw-perl/lib/perl5/5.00503/ExtUtils/xsubpp -typemap > > /home/iw-home/iw-perl/lib/perl5/5.00503/ExtUtils/typemap Oracle.xs > > >xstmp.c && mv xstmp.c Oracle.c > > gcc -c -I. -I/home/oracle/precomp/public -I/home/oracle/rdbms/public > > -I/home/oracle/rdbms/demo -I/home/oracle/plsql/public > > -I/home/oracle/network/public -I/home/oracle/rdbms/demo > > -I/home/oracle/rdbms/demo > > -I/home/iw-home/iw-perl/lib/perl5/site_perl/5.005/sun4-solaris/auto/DBI > > -I/usr/local/include -O -DVERSION=\"1.06\" -DXS_VERSION=\"1.06\" > > -fPIC -I/home/iw-home/iw-perl/lib/perl5/5.00503/sun4-solaris/CORE -Wall > > -Wno-comment Oracle.c > > /home/iw-home/iw-perl/lib/perl5/5.00503/sun4-solaris/CORE/patchlevel.h:4 > > 1: warning: `local_patches' defined but not used > > gcc -c -I. -I/home/oracle/precomp/public -I/home/oracle/rdbms/public > > -I/home/oracle/rdbms/demo -I/home/oracle/plsql/public > > -I/home/oracle/network/public -I/home/oracle/rdbms/demo > > -I/home/oracle/rdbms/demo > > -I/home/iw-home/iw-perl/lib/perl5/site_perl/5.005/sun4-solaris/auto/DBI > > -I/usr/local/include -O -DVERSION=\"1.06\" -DXS_VERSION=\"1.06\" > > -fPIC -I/home/iw-home/iw-perl/lib/perl5/5.00503/sun4-solaris/CORE -Wall > > -Wno-comment dbdimp.c > > dbdimp.c: In function `ora_db_login6': > > dbdimp.c:250: warning: unsigned int format, long unsigned int arg (arg > > 5) > > dbdimp.c: In function `ora_st_destroy': > > dbdimp.c:1624: warning: unused variable `imp_dbh' > > dbdimp.c: At top level: > > /home/iw-home/iw-perl/lib/perl5/5.00503/sun4-solaris/CORE/patchlevel.h:4 > > 1: warning: `local_patches' defined but not used > > gcc -c -I. -I/home
Re: Problem installing DBI on perl 5.004_02
If you are using ActiveState's Perl, you should use PPM to install DBI. The current version that PPM will install is probably 1.14. Just go to the DOS prompt and type 'PPM' to start the shell and then 'install DBI' or 'help' for more info. -Jim "Brochard, David" wrote: > Hello > > I'd like to install DBI on perl 5.004_02 on windows NT 4 but I can't compile > it. > can someone help me find a pre-compiled version for this perl version > or give me any other advise ? > > thank you > > David Brochard
Problem installing DBI on perl 5.004_02
Hello I'd like to install DBI on perl 5.004_02 on windows NT 4 but I can't compile it. can someone help me find a pre-compiled version for this perl version or give me any other advise ? thank you David Brochard
Problem installing DBI on perl 5.004_02
Hello I'd like to install DBI on perl 5.004_02 on windows NT 4 but I can't compile it. can someone help me find a pre-compiled version for this perl version or give me any other advise ? thank you David Brochard
Re: Re: Error in DBD::Oracle Installation
* How do I find the home directory of the "oracle" user * Oracle client installed and I connecting remotely to database using sqlplus * is there any db driver mismatch any suggestions? > From: Hardy Merrill <[EMAIL PROTECTED]> > Date: 2001/04/18 Wed AM 10:03:22 EDT > To: Prasanna Gopalakrishna <[EMAIL PROTECTED]> > CC: [EMAIL PROTECTED], [EMAIL PROTECTED] > Subject: Re: Error in DBD::Oracle Installation > > I haven't been following this thread, but here are my thoughts: > > * your environment at the bottom has > ORACLE_BASE=/home/oracle > ORACLE_HOME=/home/oracle > > those environment variables usually contain values relative to > where you *installed* oracle - *NOT* relative to the home directory > of the "oracle" user(which is usually??? /home/oracle). They > usually(?) start with /u01/app/oracle... > > On my machine, these look like this: > ORACLE_BASE=/u01/app/oracle > ORACLE_HOME=/u01/app/oracle/product/8.1.7 > > * I saw a response on the topic of libclntsh.so.8.o a while ago, > and here's what it said to do: > > in /etc/ld.so.conf, add a line for the Oracle library directory > which for me is /u01/app/oracle/product/8.1.7/lib > > and then run "ldconfig". This worked for me when my installation > had trouble finding libclntsh.so.8.o. > > * On the machine where you are installing DBD::Oracle, you DO need > some form of Oracle product software - either the Oracle server > install or an Oracle client install. Actually someone once on > this list went to the trouble of pointing out exactly which files > were needed from an Oracle install, to keep it as small as possible, > but you'll have to find that message if that's what you want to > do. If you have sqlplus installed and working, I think that > indicates you do have Oracle installed - since you didn't say > if sqlplus was connecting locally or to a remote db, I can't say > for sure whether you have the Oracle Server or an Oracle client > install. But if sqlplus works fine, then you should be able to > get DBI with DBD::Oracle to work. > > HTH. > > -- > Hardy Merrill > Mission Critical Linux, Inc. > http://www.missioncriticallinux.com > > > Prasanna Gopalakrishna [[EMAIL PROTECTED]] wrote: > > Yes. I do have following links in $ORACLE_HOME/lib > > any suggestion? > > > > -rwxr-xr-x 1 oracle 800 6721160 Apr 20 2000 libclntsh.so > > -rwxr-xr-x 1 oracle 800 6796000 Mar 29 09:24 libclntsh.so.1.0 > > -rwxr-xr-x 1 root other6721160 Mar 29 09:21 libclntsh.so.1.0.tmp > > -rw-r--r-- 1 oracle staff9255260 Jun 22 2000 libclntsh.so.8.0 > > > > > > > > > > > > From: Mohanjit Singh <[EMAIL PROTECTED]> > > > Date: 2001/04/17 Tue PM 01:42:49 EDT > > > To: Prasanna Gopalakrishna <[EMAIL PROTECTED]> > > > Subject: RE: RE: Error in DBD::Oracle Installation > > > > > > Do u have following symbolic links under $ORACLE_HOME/lib > > > > > > lrwxrwxrwx 1 root monitor 16 Jul 12 2000 libclntsh.so -> > > > libclntsh.so.8.0 > > > -rwxr-xr-x 1 root monitor 9828696 Jul 12 2000 libclntsh.so.8.0 > > > > > > > > > > > > -Original Message- > > > From: Prasanna Gopalakrishna [mailto:[EMAIL PROTECTED]] > > > Sent: Tuesday, April 17, 2001 1:32 PM > > > To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] > > > Subject: Re: RE: Error in DBD::Oracle Installation > > > Sensitivity: Confidential > > > > > > > > > Still running around with the same problem. I wonder this could be the > > > problem! not sure... > > > > > > i) Do I need to set ORACLE_USER along with ORACLE_HOME, ORACLE_SID, > > > LD_LIBRARY_PATH environment before install DBD::Oracle > > > If yes who? admin or any db-user? > > > > > > > > > ii) also, do need to install any other Oracle client libraries. (Sqlplus > > > works though!) > > > > > > > > > > > > > > > > > > > > From: "Sterin, Ilya" <[EMAIL PROTECTED]> > > > > Date: 2001/04/17 Tue AM 10:50:11 EDT > > > > To: 'Prasanna Gopalakrishna ' <[EMAIL PROTECTED]>, "'[EMAIL PROTECTED] '" > > > > <[EMAIL PROTECTED]>, "'[EMAIL PROTECTED] '" <[EMAIL PROTECTED]> > > > > Subject: RE: Error in DBD::Oracle Installation > > > > > > > > Make sure your LD_LIBRARY_PATH is set correctly for the username which is > > > > installing DBD::Oracle > > > > > > > > Ilya Sterin > > > > > > > > -Original Message- > > > > From: Prasanna Gopalakrishna > > > > To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; Sterin, Ilya > > > > Sent: 04/17/2001 10:29 AM > > > > Subject: Error in DBD::Oracle Installation > > > > Sensitivity: Confidential > > > > > > > > Hi DBI-USERS, Tim, Ilya, ... > > > > > > > > > > > > I'm trying install DBD::Oracle on Solaris machine and tried all options > > > > as mentioned in the README.xxx files. Still having same problem when > > > > running make test. > > > > SQLPLUS works good on this machine. Any suggestions appreciated. > > > > > > > > Thanks >
DBI Proxy and SQL Statements
hi there
I'm working with RH 7.0 and Oracle 8.1.5. The installation was no problem and the
Proxy is working
fine. When I try to execute sqls from a script everything works fine. Now I made a
small script and
try to execute sqls which are defined in the proxy.cfg. I get the following message:
err, Unknown SQL query: at
/usr/local/lib/perl5/site_perl/5.6.1/i686-linux/DBI/ProxyServer.pm line
251
the script looks like this:
DBI->trace(4);
use DBI;
$dbh = DBI->connect("dbi:Proxy:hostname=localhost;port=2001;dsn=dbi:Oracle:somewhere",
"***", "***")
|| print "$DBI::errstr";
$sth = $dbh->prepare("test ?") || print "$DBI::errstr";
$sth->execute("90399") || print "$DBI::errstr";
my $hash = $sth->fetchrow_hashref();
my %hash = %{$hash};
$sth->finish;
$dbh->disconnect;
I try to execute the sql "test" which I define in the proxy.cfg
the proxy.cfg looks like this:
require DBD::Oracle;
{
facility => 'daemon',
pidfile => '/var/dbiproxy/dbiproxy.pid',
localport => '2001',
logfile => '/var/log/dbiproxy.log',
mode => 'fork',
clients => [
# Akzeptiere nur die IP-Nummer von * (regexpecs moegl.)
{
mask => '^127\.0\.0\.1$',
accept => 1,
sql => {
'test' => 'SELECT * from TABLE WHERE SOMETHING=(?)'
}
},
]
}
I traced the script:
-> DBI->connect(dbi:Proxy:hostname=localhost;port=2001;dsn=dbi:Oracle:*, ***, ***)
-> DBI->install_driver(Proxy) for perl=5.006001 pid=3875 ruid=0 euid=0
install_driver: DBD::Proxy loaded (version 0.2003)
New DBI::dr (for DBD::Proxy::dr, parent=, id=)
dbih_setup_handle(DBI::dr=HASH(0x8195da0)=>DBI::dr=HASH(0x8344a74),
DBD::Proxy::dr, 0, Null!)
dbih_make_com(Null!, DBD::Proxy::dr, 172)
<- install_driver= DBI::dr=HASH(0x8195da0)
-> connect for DBD::Proxy::dr (DBI::dr=HASH(0x8195da0)~0x8344a74
'hostname=localhost;port=2001;dsn=dbi:Oracle:' '***' HASH(0x824d1f0))
New DBI::db (for DBD::Proxy::db, parent=DBI::dr=HASH(0x8344a74), id=)
dbih_setup_handle(DBI::db=HASH(0x834f980)=>DBI::db=HASH(0x8361afc),
DBD::Proxy::db, 8193210,
Null!)
dbih_make_com(DBI::dr=HASH(0x8344a74), DBD::Proxy::db, 172)
<- connect= DBI::db=HASH(0x834f980) at DBI.pm line 412.
-> STORE for DBD::Proxy::db (DBI::db=HASH(0x8361afc)~INNER 'PrintError' 1)
STORE DBI::db=HASH(0x8361afc) 'PrintError' => 1
<- STORE= 1 at DBI.pm line 437.
-> STORE for DBD::Proxy::db (DBI::db=HASH(0x8361afc)~INNER 'AutoCommit' 1)
<- STORE= '1' at DBI.pm line 437.
<- connect= DBI::db=HASH(0x834f980)
prepare
-> prepare for DBD::Proxy::db (DBI::db=HASH(0x834f980)~0x8361afc 'test ?')
New DBI::st (for DBD::Proxy::st, parent=DBI::db=HASH(0x8361afc), id=)
dbih_setup_handle(DBI::st=HASH(0x8361acc)=>DBI::st=HASH(0x8366e58),
DBD::Proxy::st, 8361ad8,
Null!)
dbih_make_com(DBI::db=HASH(0x8361afc), DBD::Proxy::st, 172)
<- prepare= DBI::st=HASH(0x8361acc) at televn.cgi line 89.
execute
-> execute for DBD::Proxy::st (DBI::st=HASH(0x8361acc)~0x8366e58 '90399')
!! ERROR: 1 'Server returned error: Failed to execute method CallMethod: Unknown
SQL query: at
/usr/local/lib/perl5/site_perl/5.6.1/i686-linux/DBI/ProxyServer.pm line 251.
'
<- execute= undef at televn.cgi line 91.
DBD::Proxy::st execute failed: Server returned error: Failed to execute method
CallMethod:
Unknown SQL query: at
/usr/local/lib/perl5/site_perl/5.6.1/i686-linux/DBI/ProxyServer.pm line 251.
-> $DBI::errstr (&) FETCH from lasth=DBI::st=HASH(0x8366e58)
>> DBD::Proxy::st::errstr
Server returned error: Failed to execute method CallMethod: Unknown SQL query: at
/usr/local/lib/perl5/site_perl/5.6.1/i686-linux/DBI/ProxyServer.pm line 251.
The Oracle_Home Variable is set.
RH 7.0
Oracle Client 8.1.5
Perl 5.6.1
DBI 1.1.15
DBD::Oracle 1.06
Thanks for your help
Jan-Hendrik
--
Mit freundlichem Gruß
i.A. Jan-Hendrik Petersen
+ KomTel Gesellschaft fuer
+ Kommunikations- und
+ Informationsdienste mbH
+
+ Jan-Hendrik Petersen
+ Nordstaße 2, D-24937 Flensburg
+
+ Fon: +49-461-9090-685, Fax: +49-461-9090-071
+ EMail: [EMAIL PROTECTED], Internet: http://www.komtel.net
+ - +
DBD::ODBC with redbrick error
I've compiled v0.28 of DBD::ODBC with the redbrick odbc drivers (after making a few changes to the source), but I get this error when I run the tests. t/02simple..ok 1/14Error in opening config file; unable to continue DBI->connect(ACCRUE) failed: (DBD: db_login/SQLAllocEnv err=-1) at t/02simple.t line 16 Connect failed: (DBD: db_login/SQLAllocEnv err=-1) t/02simple..dubious Test returned status 255 (wstat 65280, 0xff00) DIED. FAILED tests 2-14 Failed 13/14 tests, 7.14% okay It occurs on all tests past 01base. What config file is it referring to? I have an .odbc.ini in my home directory. Thanks. -- Bill Gunter Motorola, Inc. Global Internet Marketing C: 512-826-2891 P: [EMAIL PROTECTED] 800-759-8352, pin 1913746
ODBC and blobs
Hey there, Just wondering, has anyone any experience with blobs in ODBC? I am having a little trouble creating a table via perl and import exporting blobs. If anyone has info or a reference to a site with any info I would be most gratefull. Thanks in Advance. Cliff.
Re: Error in DBD::Oracle Installation
I haven't been following this thread, but here are my thoughts: * your environment at the bottom has ORACLE_BASE=/home/oracle ORACLE_HOME=/home/oracle those environment variables usually contain values relative to where you *installed* oracle - *NOT* relative to the home directory of the "oracle" user(which is usually??? /home/oracle). They usually(?) start with /u01/app/oracle... On my machine, these look like this: ORACLE_BASE=/u01/app/oracle ORACLE_HOME=/u01/app/oracle/product/8.1.7 * I saw a response on the topic of libclntsh.so.8.o a while ago, and here's what it said to do: in /etc/ld.so.conf, add a line for the Oracle library directory which for me is /u01/app/oracle/product/8.1.7/lib and then run "ldconfig". This worked for me when my installation had trouble finding libclntsh.so.8.o. * On the machine where you are installing DBD::Oracle, you DO need some form of Oracle product software - either the Oracle server install or an Oracle client install. Actually someone once on this list went to the trouble of pointing out exactly which files were needed from an Oracle install, to keep it as small as possible, but you'll have to find that message if that's what you want to do. If you have sqlplus installed and working, I think that indicates you do have Oracle installed - since you didn't say if sqlplus was connecting locally or to a remote db, I can't say for sure whether you have the Oracle Server or an Oracle client install. But if sqlplus works fine, then you should be able to get DBI with DBD::Oracle to work. HTH. -- Hardy Merrill Mission Critical Linux, Inc. http://www.missioncriticallinux.com Prasanna Gopalakrishna [[EMAIL PROTECTED]] wrote: > Yes. I do have following links in $ORACLE_HOME/lib > any suggestion? > > -rwxr-xr-x 1 oracle 800 6721160 Apr 20 2000 libclntsh.so > -rwxr-xr-x 1 oracle 800 6796000 Mar 29 09:24 libclntsh.so.1.0 > -rwxr-xr-x 1 root other6721160 Mar 29 09:21 libclntsh.so.1.0.tmp > -rw-r--r-- 1 oracle staff9255260 Jun 22 2000 libclntsh.so.8.0 > > > > > > > From: Mohanjit Singh <[EMAIL PROTECTED]> > > Date: 2001/04/17 Tue PM 01:42:49 EDT > > To: Prasanna Gopalakrishna <[EMAIL PROTECTED]> > > Subject: RE: RE: Error in DBD::Oracle Installation > > > > Do u have following symbolic links under $ORACLE_HOME/lib > > > > lrwxrwxrwx 1 root monitor 16 Jul 12 2000 libclntsh.so -> > > libclntsh.so.8.0 > > -rwxr-xr-x 1 root monitor 9828696 Jul 12 2000 libclntsh.so.8.0 > > > > > > > > -Original Message- > > From: Prasanna Gopalakrishna [mailto:[EMAIL PROTECTED]] > > Sent: Tuesday, April 17, 2001 1:32 PM > > To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] > > Subject: Re: RE: Error in DBD::Oracle Installation > > Sensitivity: Confidential > > > > > > Still running around with the same problem. I wonder this could be the > > problem! not sure... > > > > i) Do I need to set ORACLE_USER along with ORACLE_HOME, ORACLE_SID, > > LD_LIBRARY_PATH environment before install DBD::Oracle > > If yes who? admin or any db-user? > > > > > > ii) also, do need to install any other Oracle client libraries. (Sqlplus > > works though!) > > > > > > > > > > > > > > From: "Sterin, Ilya" <[EMAIL PROTECTED]> > > > Date: 2001/04/17 Tue AM 10:50:11 EDT > > > To: 'Prasanna Gopalakrishna ' <[EMAIL PROTECTED]>, "'[EMAIL PROTECTED] '" > > ><[EMAIL PROTECTED]>, "'[EMAIL PROTECTED] '" <[EMAIL PROTECTED]> > > > Subject: RE: Error in DBD::Oracle Installation > > > > > > Make sure your LD_LIBRARY_PATH is set correctly for the username which is > > > installing DBD::Oracle > > > > > > Ilya Sterin > > > > > > -Original Message- > > > From: Prasanna Gopalakrishna > > > To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; Sterin, Ilya > > > Sent: 04/17/2001 10:29 AM > > > Subject: Error in DBD::Oracle Installation > > > Sensitivity: Confidential > > > > > > Hi DBI-USERS, Tim, Ilya, ... > > > > > > > > > I'm trying install DBD::Oracle on Solaris machine and tried all options > > > as mentioned in the README.xxx files. Still having same problem when > > > running make test. > > > SQLPLUS works good on this machine. Any suggestions appreciated. > > > > > > Thanks > > > > > > Find an log for 'make' and 'make test' follows... > > > > > > > > > Sun OS 5.7 > > > Perl 5.005_03 (provided by Interwoven Teamsite) > > > Oracle 8.0.3 > > > DBI-1.15 > > > DBD-Oracle-1.06 > > > > > > > > > > > > > > > # make > > > mkdir blib > > > mkdir blib/lib > > > mkdir blib/lib/DBD > > > mkdir blib/arch > > > mkdir blib/arch/auto > > > mkdir blib/arch/auto/DBD > > > mkdir blib/arch/auto/DBD/Oracle > > > mkdir blib/lib/auto > > > mkdir blib/lib/auto/DBD > > > mkdir blib/lib/auto/DBD/Oracle > > > mkdir blib/man1 > > > mkdir blib/man3 > > > cp Oraperl.pm blib/lib/Oraperl.pm > > > cp Oracle.pm blib/lib/DBD/Oracle.pm > > > cp oraperl
RE: uninitialized value in concatenation?
Hi there,
Aye, if you get an uninit concat error that means that a variable you are
using is not defined. Just print each of the variables seperately to check
which one is not defined.
Cliff.
-Original Message-
From: Ian Macdonald [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 18, 2001 2:57 PM
To: David Humpherys
Cc: [EMAIL PROTECTED]
Subject: Re: uninitialized value in concatenation?
Your syntax looks fine, but the warning probably indicates that the
variable ( $sth_display->{NAME}->[$c] ) is undefined. Check it with
defined() and print out ' ' or something if it isn't defined.
i.e. ( using trinary conditional operator )
defined( $sth_display->{NAME}->[$c] ) ? print
"$sth_display->{NAME}->[$c]" : print " ";
should get rid of the warning;
Ian.
Ian Macdonald
On Tue, 17 Apr 2001, David Humpherys wrote:
> when i run a script that has the following bit of code I get an warning:
> use of uninitialized value in concatenation (.) at
> I get it for the line: if (($sth_display->{NAME}->[$c]) !~ /id/i)
>
>
> Is my syntax correct here.? The program runs (occasionally) and i get
> appropriate results...I just want to get rid of my warnings.
>
>
> &ConnectDB;
> $sth_display = $dbh->prepare_cached("$mystatement") || print "Can't
prepare
> statement.\n";
> $sth_display->execute;
>
> for ($c=0; $c < $sth_display->{NUM_OF_FIELDS}; $c++){
> if (($sth_display->{NAME}->[$c]) !~ /id/i) { #if it isn't an id_field
> print <<"HERE";
> $sth_display->{NAME}->[$c]
> HERE
> }
> }
>
>
> thanks
> david
>
Re: uninitialized value in concatenation?
Your syntax looks fine, but the warning probably indicates that the
variable ( $sth_display->{NAME}->[$c] ) is undefined. Check it with
defined() and print out ' ' or something if it isn't defined.
i.e. ( using trinary conditional operator )
defined( $sth_display->{NAME}->[$c] ) ? print
"$sth_display->{NAME}->[$c]" : print " ";
should get rid of the warning;
Ian.
Ian Macdonald
On Tue, 17 Apr 2001, David Humpherys wrote:
> when i run a script that has the following bit of code I get an warning:
> use of uninitialized value in concatenation (.) at
> I get it for the line: if (($sth_display->{NAME}->[$c]) !~ /id/i)
>
>
> Is my syntax correct here.? The program runs (occasionally) and i get
> appropriate results...I just want to get rid of my warnings.
>
>
> &ConnectDB;
> $sth_display = $dbh->prepare_cached("$mystatement") || print "Can't prepare
> statement.\n";
> $sth_display->execute;
>
> for ($c=0; $c < $sth_display->{NUM_OF_FIELDS}; $c++){
> if (($sth_display->{NAME}->[$c]) !~ /id/i) { #if it isn't an id_field
> print <<"HERE";
> $sth_display->{NAME}->[$c]
> HERE
> }
> }
>
>
> thanks
> david
>
DBI users in the Republic of Ireland?
I'd like to get in touch with any DBI users in the Republic of Ireland. Please send me an email. Tim.
RE: RE: Error in DBD::Oracle Installation
I don't have any symbolic links for libclntsh.so->libclntsh.so.8.0 in $ORACLE_HOME/lib Do I need ? > > From: Mohanjit Singh <[EMAIL PROTECTED]> > Date: 2001/04/17 Tue PM 01:42:49 EDT > To: Prasanna Gopalakrishna <[EMAIL PROTECTED]> > Subject: RE: RE: Error in DBD::Oracle Installation > > Do u have following symbolic links under $ORACLE_HOME/lib > > lrwxrwxrwx 1 root monitor 16 Jul 12 2000 libclntsh.so -> > libclntsh.so.8.0 > -rwxr-xr-x 1 root monitor 9828696 Jul 12 2000 libclntsh.so.8.0 > > > > -Original Message- > From: Prasanna Gopalakrishna [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, April 17, 2001 1:32 PM > To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] > Subject: Re: RE: Error in DBD::Oracle Installation > Sensitivity: Confidential > > > Still running around with the same problem. I wonder this could be the > problem! not sure... > > i) Do I need to set ORACLE_USER along with ORACLE_HOME, ORACLE_SID, > LD_LIBRARY_PATH environment before install DBD::Oracle > If yes who? admin or any db-user? > > > ii) also, do need to install any other Oracle client libraries. (Sqlplus > works though!) > > > > > > > > From: "Sterin, Ilya" <[EMAIL PROTECTED]> > > Date: 2001/04/17 Tue AM 10:50:11 EDT > > To: 'Prasanna Gopalakrishna ' <[EMAIL PROTECTED]>, "'[EMAIL PROTECTED] '" > > <[EMAIL PROTECTED]>, "'[EMAIL PROTECTED] '" <[EMAIL PROTECTED]> > > Subject: RE: Error in DBD::Oracle Installation > > > > Make sure your LD_LIBRARY_PATH is set correctly for the username which is > > installing DBD::Oracle > > > > Ilya Sterin > > > > -Original Message- > > From: Prasanna Gopalakrishna > > To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; Sterin, Ilya > > Sent: 04/17/2001 10:29 AM > > Subject: Error in DBD::Oracle Installation > > Sensitivity: Confidential > > > > Hi DBI-USERS, Tim, Ilya, ... > > > > > > I'm trying install DBD::Oracle on Solaris machine and tried all options > > as mentioned in the README.xxx files. Still having same problem when > > running make test. > > SQLPLUS works good on this machine. Any suggestions appreciated. > > > > Thanks > > > > Find an log for 'make' and 'make test' follows... > > > > > > Sun OS 5.7 > > Perl 5.005_03 (provided by Interwoven Teamsite) > > Oracle 8.0.3 > > DBI-1.15 > > DBD-Oracle-1.06 > > > > > > > > > > # make > > mkdir blib > > mkdir blib/lib > > mkdir blib/lib/DBD > > mkdir blib/arch > > mkdir blib/arch/auto > > mkdir blib/arch/auto/DBD > > mkdir blib/arch/auto/DBD/Oracle > > mkdir blib/lib/auto > > mkdir blib/lib/auto/DBD > > mkdir blib/lib/auto/DBD/Oracle > > mkdir blib/man1 > > mkdir blib/man3 > > cp Oraperl.pm blib/lib/Oraperl.pm > > cp Oracle.pm blib/lib/DBD/Oracle.pm > > cp oraperl.ph blib/lib/oraperl.ph > > /home/iw-home/iw-perl/bin/perl -p -e "s/~DRIVER~/Oracle/g" < > > /home/iw-home/iw-perl/lib/perl5/site_perl/5.005/sun4-solaris/auto/DBI/Dr > > iver.xst > Oracle.xsi > > /home/iw-home/iw-perl/bin/perl > > -I/home/iw-home/iw-perl/lib/perl5/5.00503/sun4-solaris > > -I/home/iw-home/iw-perl/lib/perl5/5.00503 > > /home/iw-home/iw-perl/lib/perl5/5.00503/ExtUtils/xsubpp -typemap > > /home/iw-home/iw-perl/lib/perl5/5.00503/ExtUtils/typemap Oracle.xs > > >xstmp.c && mv xstmp.c Oracle.c > > gcc -c -I. -I/home/oracle/precomp/public -I/home/oracle/rdbms/public > > -I/home/oracle/rdbms/demo -I/home/oracle/plsql/public > > -I/home/oracle/network/public -I/home/oracle/rdbms/demo > > -I/home/oracle/rdbms/demo > > -I/home/iw-home/iw-perl/lib/perl5/site_perl/5.005/sun4-solaris/auto/DBI > > -I/usr/local/include -O -DVERSION=\"1.06\" -DXS_VERSION=\"1.06\" > > -fPIC -I/home/iw-home/iw-perl/lib/perl5/5.00503/sun4-solaris/CORE -Wall > > -Wno-comment Oracle.c > > /home/iw-home/iw-perl/lib/perl5/5.00503/sun4-solaris/CORE/patchlevel.h:4 > > 1: warning: `local_patches' defined but not used > > gcc -c -I. -I/home/oracle/precomp/public -I/home/oracle/rdbms/public > > -I/home/oracle/rdbms/demo -I/home/oracle/plsql/public > > -I/home/oracle/network/public -I/home/oracle/rdbms/demo > > -I/home/oracle/rdbms/demo > > -I/home/iw-home/iw-perl/lib/perl5/site_perl/5.005/sun4-solaris/auto/DBI > > -I/usr/local/include -O -DVERSION=\"1.06\" -DXS_VERSION=\"1.06\" > > -fPIC -I/home/iw-home/iw-perl/lib/perl5/5.00503/sun4-solaris/CORE -Wall > > -Wno-comment dbdimp.c > > dbdimp.c: In function `ora_db_login6': > > dbdimp.c:250: warning: unsigned int format, long unsigned int arg (arg > > 5) > > dbdimp.c: In function `ora_st_destroy': > > dbdimp.c:1624: warning: unused variable `imp_dbh' > > dbdimp.c: At top level: > > /home/iw-home/iw-perl/lib/perl5/5.00503/sun4-solaris/CORE/patchlevel.h:4 > > 1: warning: `local_patches' defined but not used > > gcc -c -I. -I/home/oracle/precomp/public -I/home/oracle/rdbms/public > > -I/home/oracle/rdbms/demo -I/home/oracle/plsql/public > > -I/home/oracle/network/public -I/home/oracle/rdbms/demo > > -I/home/oracle/rdbms/demo > > -I/home/iw-home/iw-perl/lib/perl5/site_perl/5.005/su
DB and Access - hanging script
Hi all, Don't know if anyone else has encountered this I'm using DBI and Access, I insert a number of rows into a table, and then at the end call prepare and execute an Insert that calls a query for it's values. If I run the two with seperate processes, this is no problem. If I try to perform the second insert directly after, the query executes ok, but on the return from the function the script hangs as if something is going out of scope. I can trace into OLE.pm, and in the FETCH method it hangs. Can help with this, I'm kinda at a loss. Regards, Jeff Butler > -Original Message- > From: Prasanna Gopalakrishna [SMTP:[EMAIL PROTECTED]] > Sent: Wednesday, April 18, 2001 1:47 PM > To: [EMAIL PROTECTED]; [EMAIL PROTECTED] > Subject: RE: RE: Error in DBD::Oracle Installation > Sensitivity: Confidential > > Yes. I do have following links in $ORACLE_HOME/lib > any suggestion? > > -rwxr-xr-x 1 oracle 800 6721160 Apr 20 2000 libclntsh.so > -rwxr-xr-x 1 oracle 800 6796000 Mar 29 09:24 libclntsh.so.1.0 > -rwxr-xr-x 1 root other6721160 Mar 29 09:21 libclntsh.so.1.0.tmp > -rw-r--r-- 1 oracle staff9255260 Jun 22 2000 libclntsh.so.8.0 > > > > > > > From: Mohanjit Singh <[EMAIL PROTECTED]> > > Date: 2001/04/17 Tue PM 01:42:49 EDT > > To: Prasanna Gopalakrishna <[EMAIL PROTECTED]> > > Subject: RE: RE: Error in DBD::Oracle Installation > > > > Do u have following symbolic links under $ORACLE_HOME/lib > > > > lrwxrwxrwx 1 root monitor 16 Jul 12 2000 libclntsh.so -> > > libclntsh.so.8.0 > > -rwxr-xr-x 1 root monitor 9828696 Jul 12 2000 libclntsh.so.8.0 > > > > > > > > -Original Message- > > From: Prasanna Gopalakrishna [mailto:[EMAIL PROTECTED]] > > Sent: Tuesday, April 17, 2001 1:32 PM > > To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] > > Subject: Re: RE: Error in DBD::Oracle Installation > > Sensitivity: Confidential > > > > > > Still running around with the same problem. I wonder this could be the > > problem! not sure... > > > > i) Do I need to set ORACLE_USER along with ORACLE_HOME, ORACLE_SID, > > LD_LIBRARY_PATH environment before install DBD::Oracle > > If yes who? admin or any db-user? > > > > > > ii) also, do need to install any other Oracle client libraries. (Sqlplus > > works though!) > > > > > > > > > > > > > > From: "Sterin, Ilya" <[EMAIL PROTECTED]> > > > Date: 2001/04/17 Tue AM 10:50:11 EDT > > > To: 'Prasanna Gopalakrishna ' <[EMAIL PROTECTED]>, > "'[EMAIL PROTECTED] '" > > ><[EMAIL PROTECTED]>, "'[EMAIL PROTECTED] '" <[EMAIL PROTECTED]> > > > Subject: RE: Error in DBD::Oracle Installation > > > > > > Make sure your LD_LIBRARY_PATH is set correctly for the username which > is > > > installing DBD::Oracle > > > > > > Ilya Sterin > > > > > > -Original Message- > > > From: Prasanna Gopalakrishna > > > To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; Sterin, Ilya > > > Sent: 04/17/2001 10:29 AM > > > Subject: Error in DBD::Oracle Installation > > > Sensitivity: Confidential > > > > > > Hi DBI-USERS, Tim, Ilya, ... > > > > > > > > > I'm trying install DBD::Oracle on Solaris machine and tried all > options > > > as mentioned in the README.xxx files. Still having same problem when > > > running make test. > > > SQLPLUS works good on this machine. Any suggestions appreciated. > > > > > > Thanks > > > > > > Find an log for 'make' and 'make test' follows... > > > > > > > > > Sun OS 5.7 > > > Perl 5.005_03 (provided by Interwoven Teamsite) > > > Oracle 8.0.3 > > > DBI-1.15 > > > DBD-Oracle-1.06 > > > > > > > > > > > > > > > # make > > > mkdir blib > > > mkdir blib/lib > > > mkdir blib/lib/DBD > > > mkdir blib/arch > > > mkdir blib/arch/auto > > > mkdir blib/arch/auto/DBD > > > mkdir blib/arch/auto/DBD/Oracle > > > mkdir blib/lib/auto > > > mkdir blib/lib/auto/DBD > > > mkdir blib/lib/auto/DBD/Oracle > > > mkdir blib/man1 > > > mkdir blib/man3 > > > cp Oraperl.pm blib/lib/Oraperl.pm > > > cp Oracle.pm blib/lib/DBD/Oracle.pm > > > cp oraperl.ph blib/lib/oraperl.ph > > > /home/iw-home/iw-perl/bin/perl -p -e "s/~DRIVER~/Oracle/g" < > > > > /home/iw-home/iw-perl/lib/perl5/site_perl/5.005/sun4-solaris/auto/DBI/Dr > > > iver.xst > Oracle.xsi > > > /home/iw-home/iw-perl/bin/perl > > > -I/home/iw-home/iw-perl/lib/perl5/5.00503/sun4-solaris > > > -I/home/iw-home/iw-perl/lib/perl5/5.00503 > > > /home/iw-home/iw-perl/lib/perl5/5.00503/ExtUtils/xsubpp -typemap > > > /home/iw-home/iw-perl/lib/perl5/5.00503/ExtUtils/typemap Oracle.xs > > > >xstmp.c && mv xstmp.c Oracle.c > > > gcc -c -I. -I/home/oracle/precomp/public -I/home/oracle/rdbms/public > > > -I/home/oracle/rdbms/demo -I/home/oracle/plsql/public > > > -I/home/oracle/network/public -I/home/oracle/rdbms/demo > > > -I/home/oracle/rdbms/demo > > > > -I/home/iw-home/iw-perl/lib/perl5/site_perl/5.005/sun4-solaris/auto/DBI > > > -I/usr/local/include -O -DVERSION=\"1.06\" -DXS_VERSION=\"1.06\" > > > -fPIC -I/home/iw-home/i
RE: RE: Error in DBD::Oracle Installation
Yes. I do have following links in $ORACLE_HOME/lib any suggestion? -rwxr-xr-x 1 oracle 800 6721160 Apr 20 2000 libclntsh.so -rwxr-xr-x 1 oracle 800 6796000 Mar 29 09:24 libclntsh.so.1.0 -rwxr-xr-x 1 root other6721160 Mar 29 09:21 libclntsh.so.1.0.tmp -rw-r--r-- 1 oracle staff9255260 Jun 22 2000 libclntsh.so.8.0 > > From: Mohanjit Singh <[EMAIL PROTECTED]> > Date: 2001/04/17 Tue PM 01:42:49 EDT > To: Prasanna Gopalakrishna <[EMAIL PROTECTED]> > Subject: RE: RE: Error in DBD::Oracle Installation > > Do u have following symbolic links under $ORACLE_HOME/lib > > lrwxrwxrwx 1 root monitor 16 Jul 12 2000 libclntsh.so -> > libclntsh.so.8.0 > -rwxr-xr-x 1 root monitor 9828696 Jul 12 2000 libclntsh.so.8.0 > > > > -Original Message- > From: Prasanna Gopalakrishna [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, April 17, 2001 1:32 PM > To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] > Subject: Re: RE: Error in DBD::Oracle Installation > Sensitivity: Confidential > > > Still running around with the same problem. I wonder this could be the > problem! not sure... > > i) Do I need to set ORACLE_USER along with ORACLE_HOME, ORACLE_SID, > LD_LIBRARY_PATH environment before install DBD::Oracle > If yes who? admin or any db-user? > > > ii) also, do need to install any other Oracle client libraries. (Sqlplus > works though!) > > > > > > > > From: "Sterin, Ilya" <[EMAIL PROTECTED]> > > Date: 2001/04/17 Tue AM 10:50:11 EDT > > To: 'Prasanna Gopalakrishna ' <[EMAIL PROTECTED]>, "'[EMAIL PROTECTED] '" > > <[EMAIL PROTECTED]>, "'[EMAIL PROTECTED] '" <[EMAIL PROTECTED]> > > Subject: RE: Error in DBD::Oracle Installation > > > > Make sure your LD_LIBRARY_PATH is set correctly for the username which is > > installing DBD::Oracle > > > > Ilya Sterin > > > > -Original Message- > > From: Prasanna Gopalakrishna > > To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; Sterin, Ilya > > Sent: 04/17/2001 10:29 AM > > Subject: Error in DBD::Oracle Installation > > Sensitivity: Confidential > > > > Hi DBI-USERS, Tim, Ilya, ... > > > > > > I'm trying install DBD::Oracle on Solaris machine and tried all options > > as mentioned in the README.xxx files. Still having same problem when > > running make test. > > SQLPLUS works good on this machine. Any suggestions appreciated. > > > > Thanks > > > > Find an log for 'make' and 'make test' follows... > > > > > > Sun OS 5.7 > > Perl 5.005_03 (provided by Interwoven Teamsite) > > Oracle 8.0.3 > > DBI-1.15 > > DBD-Oracle-1.06 > > > > > > > > > > # make > > mkdir blib > > mkdir blib/lib > > mkdir blib/lib/DBD > > mkdir blib/arch > > mkdir blib/arch/auto > > mkdir blib/arch/auto/DBD > > mkdir blib/arch/auto/DBD/Oracle > > mkdir blib/lib/auto > > mkdir blib/lib/auto/DBD > > mkdir blib/lib/auto/DBD/Oracle > > mkdir blib/man1 > > mkdir blib/man3 > > cp Oraperl.pm blib/lib/Oraperl.pm > > cp Oracle.pm blib/lib/DBD/Oracle.pm > > cp oraperl.ph blib/lib/oraperl.ph > > /home/iw-home/iw-perl/bin/perl -p -e "s/~DRIVER~/Oracle/g" < > > /home/iw-home/iw-perl/lib/perl5/site_perl/5.005/sun4-solaris/auto/DBI/Dr > > iver.xst > Oracle.xsi > > /home/iw-home/iw-perl/bin/perl > > -I/home/iw-home/iw-perl/lib/perl5/5.00503/sun4-solaris > > -I/home/iw-home/iw-perl/lib/perl5/5.00503 > > /home/iw-home/iw-perl/lib/perl5/5.00503/ExtUtils/xsubpp -typemap > > /home/iw-home/iw-perl/lib/perl5/5.00503/ExtUtils/typemap Oracle.xs > > >xstmp.c && mv xstmp.c Oracle.c > > gcc -c -I. -I/home/oracle/precomp/public -I/home/oracle/rdbms/public > > -I/home/oracle/rdbms/demo -I/home/oracle/plsql/public > > -I/home/oracle/network/public -I/home/oracle/rdbms/demo > > -I/home/oracle/rdbms/demo > > -I/home/iw-home/iw-perl/lib/perl5/site_perl/5.005/sun4-solaris/auto/DBI > > -I/usr/local/include -O -DVERSION=\"1.06\" -DXS_VERSION=\"1.06\" > > -fPIC -I/home/iw-home/iw-perl/lib/perl5/5.00503/sun4-solaris/CORE -Wall > > -Wno-comment Oracle.c > > /home/iw-home/iw-perl/lib/perl5/5.00503/sun4-solaris/CORE/patchlevel.h:4 > > 1: warning: `local_patches' defined but not used > > gcc -c -I. -I/home/oracle/precomp/public -I/home/oracle/rdbms/public > > -I/home/oracle/rdbms/demo -I/home/oracle/plsql/public > > -I/home/oracle/network/public -I/home/oracle/rdbms/demo > > -I/home/oracle/rdbms/demo > > -I/home/iw-home/iw-perl/lib/perl5/site_perl/5.005/sun4-solaris/auto/DBI > > -I/usr/local/include -O -DVERSION=\"1.06\" -DXS_VERSION=\"1.06\" > > -fPIC -I/home/iw-home/iw-perl/lib/perl5/5.00503/sun4-solaris/CORE -Wall > > -Wno-comment dbdimp.c > > dbdimp.c: In function `ora_db_login6': > > dbdimp.c:250: warning: unsigned int format, long unsigned int arg (arg > > 5) > > dbdimp.c: In function `ora_st_destroy': > > dbdimp.c:1624: warning: unused variable `imp_dbh' > > dbdimp.c: At top level: > > /home/iw-home/iw-perl/lib/perl5/5.00503/sun4-solaris/CORE/patchlevel.h:4 > > 1: warning: `local_patches' defined but not used > > gcc -c -I. -I/home/or
Re: DBD-ODBC error: undefined symbol
Karen Ellrick wrote: > > What does the > > ldd /usr/lib/perl5/site_perl/5.005/i386-linux/auto/DBD/ODBC/ODBC.so > > print? Are the correct libraries loaded? > > Well, I don't know what the correct libraries are (or even what the ldd > command does), but the output is as follows: > libodbcinst.so.1 => /usr/local/easysoft/unixODBC/lib/libodbcinst.so.1 > (0x4000f000) > libc.so.6 => /lib/libc.so.6 (0x40021000) > libm.so.6 => /lib/libm.so.6 (0x40114000) > libdl.so.2 => /lib/libdl.so.2 (0x4013) > /lib/ld-linux.so.2 => /lib/ld-linux.so.2 (0x8000) Is it the complete output of ldd? I don't see the client libraries. Here is what I have (but I use Solaris, not Linux): maas34: ldd /opt/local/perl-5.6.0/lib/site_perl/5.6.0/sun4-solaris/auto/DBD/ODBC/ODBC.so libesoobclient.so => /home/eedalf/easysoft/oob/client/libesoobclient.so libc.so.1 => /usr/lib/libc.so.1 libesrpc.so => /home/eedalf/easysoft/lib/libesrpc.so libessupp.so => /home/eedalf/easysoft/lib/libessupp.so libesextra.so => /home/eedalf/easysoft/lib/libesextra.so libdl.so.1 =>/usr/lib/libdl.so.1 libm.so.1 => /usr/lib/libm.so.1 nss_files.so.1 =>/usr/lib/nss_files.so.1 libsocket.so.1 =>/usr/lib/libsocket.so.1 libnsl.so.1 => /usr/lib/libnsl.so.1 libmp.so.2 =>/usr/lib/libmp.so.2 /usr/platform/SUNW,Ultra-5_10/lib/libc_psr.so.1 > Does that tell you anything? I'd double check that all libraries are found (also from the point of view of your (CGI-)skript, and that you don't have 2 different versions of Easysoft OOB installed...
RE: DBD-ODBC error: undefined symbol
Thanks for responding, Alex. > What does the > ldd /usr/lib/perl5/site_perl/5.005/i386-linux/auto/DBD/ODBC/ODBC.so > print? Are the correct libraries loaded? Well, I don't know what the correct libraries are (or even what the ldd command does), but the output is as follows: libodbcinst.so.1 => /usr/local/easysoft/unixODBC/lib/libodbcinst.so.1 (0x4000f000) libc.so.6 => /lib/libc.so.6 (0x40021000) libm.so.6 => /lib/libm.so.6 (0x40114000) libdl.so.2 => /lib/libdl.so.2 (0x4013) /lib/ld-linux.so.2 => /lib/ld-linux.so.2 (0x8000) Does that tell you anything?
Re: DBD-ODBC error: undefined symbol
Karen Ellrick wrote: > Once upon a time, I successfully compiled and installed the DBI and > DBD::ODBC modules to use with EasySoft's ODBC-ODBC-Bridge. But now I have a > new Linux box, and although I tried to do everything the same way as before > (within the limits of my memory), I get the following error when I try to > use the new installation: > > perl: error in loading shared libraries: > /usr/lib/perl5/site_perl/5.005/i386-linux/auto/DBD/ODBC/ODBC.so: undefined > symbol: SQLAllocEnv > > For versions, I have odbc-odbc-bridge-1.0.0.25, DBI-1.14, and DBD-ODBC-0.28. This combination works fine for me (on Solaris, against Window NT 4 and SQLBase). What does the ldd /usr/lib/perl5/site_perl/5.005/i386-linux/auto/DBD/ODBC/ODBC.so print? Are the correct libraries loaded? > Does anyone know what I might be missing, or can give me some guidance in > how to troubleshoot it? Easysoft has been very responsive for me. Regards Alex
DBD-ODBC error: undefined symbol
Once upon a time, I successfully compiled and installed the DBI and DBD::ODBC modules to use with EasySoft's ODBC-ODBC-Bridge. But now I have a new Linux box, and although I tried to do everything the same way as before (within the limits of my memory), I get the following error when I try to use the new installation: perl: error in loading shared libraries: /usr/lib/perl5/site_perl/5.005/i386-linux/auto/DBD/ODBC/ODBC.so: undefined symbol: SQLAllocEnv For versions, I have odbc-odbc-bridge-1.0.0.25, DBI-1.14, and DBD-ODBC-0.28. Does anyone know what I might be missing, or can give me some guidance in how to troubleshoot it? Karen Ellrick S & C Technology, Inc. 1-21-35 Kusatsu-shinmachi Hiroshima 733-0834 Japan (from U.S. 011-81, from Japan 0) 82-293-2838
