Re: DBD::Informix, perl 5.8.5 and Solaris build problem

2004-10-08 Thread Tim Bunce
On Fri, Oct 08, 2004 at 04:45:44PM +0100, Tielman De Villiers wrote: > > But now I get > make: Fatal error: Command failed for target `test_dynamic' > during make test. It would be useful to know what it said just before that. Tim.

Re: :ODBC with DB2

2004-10-08 Thread Dan Scott
Ben: DB2 automatically takes the user ID you logged in with and uses that as your default schema. You can issue the "SET SCHEMA" statement to change your default schema if you want it to be different from your DSN user ID. For example "SET SCHEMA rick" would automatically prepend 'rick.' to all o

Re: Help needed - DBD::Oracle 1.15

2004-10-08 Thread Tim Bunce
On Fri, Oct 08, 2004 at 09:42:18PM +0530, Mahadevan, Arun wrote: > Hi, > > Recently we upgraded from DBD::Oracle v1.12 to DBD v1.15 as we had to > upgrade to Oracle 9i. > > But there is some functionality difference I observerd in ora_open() > function. (We are using Oraperl emulation of Perl DBI

Re: Math-GMP 2.04 Solaris 9 and Net::SSH

2004-10-08 Thread Tim Bunce
On Fri, Oct 08, 2004 at 01:52:11PM -0400, LY, Michelle wrote: > Hi, > > I have been trying to get Net::SSH for Perl loaded on all of our > machines for use by the developers. dbi-users is the wrong mailing list for this. Read the docs to find out where to get help, or try www.perlmonks.org. Tim.

Re: DBD::Informix, perl 5.8.5 and Solaris build problem

2004-10-08 Thread Tielman De Villiers
"Tielman de Villiers" <[EMAIL PROTECTED]> wrote in message news:<[EMAIL PROTECTED]>... > I get the following error when trying to build DBD::Informix with perl > 5.8.5 on Solaris 9 12/03 s9s_u5wos_08b SPARC with INFORMIX-ESQL Version > 9.51.UC3. I've built it successfully before on the same versi

Math-GMP 2.04 Solaris 9 and Net::SSH

2004-10-08 Thread LY, Michelle
Hi, I have been trying to get Net::SSH for Perl loaded on all of our machines for use by the developers. I am getting the following on Math-GMP when I try to compile cp lib/Math/GMP.pm blib/lib/Math/GMP.pm AutoSplitting blib/lib/Math/GMP.pm (blib/lib/auto/Math/GMP) /usr/bin/perl -I/usr/perl5/5.6

Re: DBD::Oracle & Oracle10g on MacOS X [PATCH]

2004-10-08 Thread Tim Bunce
On Fri, Oct 08, 2004 at 03:55:35PM +0300, Marko Asplund wrote: > hi > > i've had problems with the Oracle version detection in DBD::Oracle 1.15 > on MacOS X. for some reason the detection fails for Oracle10g. here's a > patch which makes it possible to manually set Oracle version in case > auto

Re: DBI-1.43 bug

2004-10-08 Thread Tim Bunce
On Fri, Oct 08, 2004 at 11:31:56AM +0100, Gordon Lack wrote: >Probably only a minor one, but the SGI/Irix compiler throws up this > warning: Thanks. Fixed. Tim.

Re: DBD::Oracle 1.15 core dump if RETURNING clause is used with LOB

2004-10-08 Thread Tim Bunce
On Fri, Oct 08, 2004 at 01:33:22PM +0200, Silvio Wanka wrote: > Hi, > > according the Oracle documantation: > >INSERT INTO a_table values (empty_blob()); > > Even better is to use the RETURNING clause (thereby eliminating a round > trip that is necessary for the subsequent SELECT), > > I

RE: Trouble with Update and Placeholders...

2004-10-08 Thread Jeff Urlwin
Doh. Thanks Tim. Jeff > -Original Message- > From: Tim Bunce [mailto:[EMAIL PROTECTED] > Sent: Friday, October 08, 2004 5:30 AM > To: Jeff Urlwin > Cc: 'Chris Gehring'; [EMAIL PROTECTED] > Subject: Re: Trouble with Update and Placeholders... > > > On Thu, Oct 07, 2004 at 06:47:29PM -

RE: :ODBC with DB2

2004-10-08 Thread Jeff Urlwin
Ben, Please post these types of questions to the dbi-users list, rather than to me directly. There are a lot of other people with more experience than me with the various databases who can help. I believe that is standard behaviour for most ODBC drivers/logins, that if you l do not provide the

DBI::Shell 11.93 AIX 5.6.1

2004-10-08 Thread ODELL, TODD E \(SWBT\)
I'm seeing some odd behavior after installing the DBI::Shell v.11.93. It seems to work ok, except the prompt is only @> , when I run it as I have been with 10.11. That is different from the old version where I'd see dbi:Informix:[EMAIL PROTECTED] However if I run dbish as: ./dbish dbi:Informix:[EM

RE: Help needed - DBD::Oracle 1.15

2004-10-08 Thread Mahadevan, Arun
I am using $lda = &ora_login("", "$user", "$password"); My concern here is that the error message is thrown even though the &ora_open() is inside eval{} block. Usually the error message should be available in $@ and wont be displayed in the console. Correct me if I am wrong. Regards, Arun

RE: Help needed - DBD::Oracle 1.15

2004-10-08 Thread Reidy, Ron
Are you setting 'PrintError => 0' in your connect() call? The error is correct (from Oracle's view). - Ron Reidy Lead DBA Array BioPharma, Inc. -Original Message- From: Mahadevan, Arun [mailto:[EMAIL PROTECTED] Sent: Friday, October 08, 2004 10:12 AM To: [EMAIL PROTECTE

Help needed - DBD::Oracle 1.15

2004-10-08 Thread Mahadevan, Arun
Hi, Recently we upgraded from DBD::Oracle v1.12 to DBD v1.15 as we had to upgrade to Oracle 9i. But there is some functionality difference I observerd in ora_open() function. (We are using Oraperl emulation of Perl DBI). CODE $date="xx-yy"; $query = "select to_date('".$date."','DD-

DBD::Informix, perl 5.8.5 and Solaris build problem

2004-10-08 Thread Tielman de Villiers
I get the following error when trying to build DBD::Informix with perl 5.8.5 on Solaris 9 12/03 s9s_u5wos_08b SPARC with INFORMIX-ESQL Version 9.51.UC3. I've built it successfully before on the same version of Solaris and esql, so I suspect it must be something else ? bash-2.05$ perl Makefile.PL

RE: DBD::Informix 2003.04 AIX4.3.3 SELECTIVE TEST ERRORS

2004-10-08 Thread ODELL, TODD E \(SWBT\)
Jeff, Thanks for the quick reply. I was thinking I was probably ok. I see about an upgrade to the database as I run into other small issues concerning other tools and the UDTS as well. Thanks again! Todd -Original Message- From: Jonathan Leffler [mailto:[EMAIL PROTECTED] Sent: Thursday,

DBD::Oracle & Oracle10g on MacOS X [PATCH]

2004-10-08 Thread Marko Asplund
hi i've had problems with the Oracle version detection in DBD::Oracle 1.15 on MacOS X. for some reason the detection fails for Oracle10g. here's a patch which makes it possible to manually set Oracle version in case automatic detection fails. this patch also disables symbol table editing on Mac

DBD::Oracle 1.15 core dump if RETURNING clause is used with LOB

2004-10-08 Thread Silvio Wanka
Hi, according the Oracle documantation: INSERT INTO a_table values (empty_blob()); Even better is to use the RETURNING clause (thereby eliminating a round trip that is necessary for the subsequent SELECT), I have tried the following: my $id = shift; my $sql = << 'SQL'; INSERT

DBI-1.43 bug

2004-10-08 Thread Gordon Lack
Probably only a minor one, but the SGI/Irix compiler throws up this warning: cc-1548 cc: WARNING File = DBI.xs, Line = 2336 The transfer of control bypasses... ... the initialization of variable "h_perl" (declared at line 2384) . goto is_DE

Re: Problem with t/general.t test 5 with DBD::Oracle

2004-10-08 Thread Tim Bunce
On Thu, Oct 07, 2004 at 04:06:12PM -0500, Rafael Caceres wrote: > While trying to make test DBD::Oracle 1.15 (with DBI 1.45), t/general.t > test #5 fails. > > >From reading the test, my understanding is that excercising: > eval { $p1=$sth->{NUM_OFFIELDS_typo} }; > ok(0, $@ =~ /attribute/); > > sh

Re: Trouble with Update and Placeholders...

2004-10-08 Thread Tim Bunce
On Thu, Oct 07, 2004 at 06:47:29PM -0400, Jeff Urlwin wrote: > 3) You can try forcing the bound variable to a specific type by > $sth->bind_param(index, SQL_INTEGER, value) or $sth->bind_param(index, SQL_VARCHAR, > value) Typo, swap the last two args in each example. The type comes last. T

Re: Had to create DBD::mysql::dr::imp_data_size unexpectedly

2004-10-08 Thread Tim Bunce
On Fri, Oct 08, 2004 at 09:06:28AM +0530, Karthik Krishnamurthy wrote: > Hi Tim, >I seem to have solved the problem. DBI seems to have an issue with > PERL_DL_NONLAZY=1. Once I commented this in runtests script, everything > seems to work well. Could you give me an idea of why this is so ? I h

Re: DBI problem fetching Oracle Clob data (intermittent) on HP-UX

2004-10-08 Thread Tim Bunce
On Thu, Oct 07, 2004 at 10:33:26AM -0400, Sean McMillan wrote: > >It would only happen if the ora_auto_lob attribute has been explicitly set > >false. > >See the docs. > Neither of these sets ora_auto_lob at all. Unfortunately, this > doesn't happen on my test machines, only on my cl

DBD::Informix A configuration failure

2004-10-08 Thread Marco Avvisano
I have problem to install DBD Informix module on Red Hat Enterprise Linux ES release 3 # perl Makefile.PL Configuring IBM Informix Database Driver for Perl Version 2003.04 (2003-03-05) (aka DBD::Informix) You are using DBI version 1.45 and Perl version 5.008 Remember to actually