Re: Date Format for INFORMIX using DBI

2005-05-17 Thread Jonathan Leffler
On 5/16/05, Nitin Nair [EMAIL PROTECTED] wrote: I am using the DBI to extract some data from the underlying Informix Database. Even after doing the following when I am printing the value for $start_date, it is in the format 'dd/mm/' instead of the expected '/mm/dd'. Can any of you

RE: [dbi] Segmentation fault on RHEL4

2005-05-17 Thread Martin J. Evans
Search this list for similar issue I previously replied to. You are probably getting this because you have mixed Perl, unixODBC, MySQL where some were built with -pthread and some were not. What seems to happen is that some internal structure used by dlopen/dlclose is different when built

Re: DBD::Oracle on MacOSX using Instant Client

2005-05-17 Thread Tim Bunce
On Tue, May 17, 2005 at 08:59:04AM +0300, Marko Asplund wrote: On 2005-05-16, at 12.41, Tim Bunce wrote: Great. Applied. Thanks Hilmar! great to hear Instant Client will be supported. It's getting better but I wouldn't call it supported yet. Ideally it should just work out of the box and

nonblocking OCI in DBD::Oracle?

2005-05-17 Thread Eric Rybski
Tim, I'm curious: have you ever experimented with nonblocking OCI in your DBD::Oracle driver? I've been using Perl Object Environment (POE) for some time now, and some projects I'd like to start require database access. As far as I'm concerned, the non-blocking workaround all existing

upgrading dbi

2005-05-17 Thread April Blumenstiel
Hello, I have a pretty old version of DBI on a production server. I'd like to upgrade (partly so that the version up there will be closer to the development environment). I've been looking around for info on upgrading DBI in the faqs and docs but haven't found anything. There are a couple of

Re: upgrading dbi

2005-05-17 Thread William R. Mussatto
April Blumenstiel said: Hello, I have a pretty old version of DBI on a production server. I'd like to upgrade (partly so that the version up there will be closer to the development environment). I've been looking around for info on upgrading DBI in the faqs and docs but haven't found

Re: upgrading dbi

2005-05-17 Thread April Blumenstiel
The database is SQL Server and the current perl revision on the production machine is 5.006 and the DBD.pm version is 10.7, wheras in the development environment the perl version is 5.006001 and the DBD.pm version is 11.16 . So I guess the bigger difference is in the DBI. Thanks On 5/17/05,

Re: [dbi] Segmentation fault on RHEL4

2005-05-17 Thread Stephen More
You are probably getting this because you have mixed Perl, unixODBC, MySQL where some were built with -pthread and some were not. Can this be proven with ldd ? It looks like all are linked with libpthread.so.0 $ ldd /usr/bin/perl | grep -i pthread libpthread.so.0 =

DBD::Informix and SIGBUS in perl

2005-05-17 Thread Konstantin Solodovnikov
Hi, I'm having a problem with DBD::Informix when using it's functions via a 'goto $sub' mechanism. My program is a CGI script in perl, which provides web-access to a database in Informix. The problem happens in the situation when the program dies from a 'HandleError' handler, assigned to a

RE: SQL -25507 error trying to build DBD::Informix on linux

2005-05-17 Thread Bruce Lysik
Thanks for the response. Sorry it's been so long since I replied. (Too many projects, too little time.) I'm running into a problem trying to build DBD::Informix on a Redhat ES3 host, with a database on a Solaris 9 host. Client: RedHat ES3, 2.4.21-15.0.4.ELsmp, perl v5.8.0,

Re: DBD::Informix and SIGBUS in perl

2005-05-17 Thread Jonathan Leffler
Dear Tim, There's a question for you at the bottom, which I've repeated here, more or less. What's the possible difference between: use DBI; and use DBI; use DBD::Informix; in the context of this code? Also, the example code used $dbh-can() as if it returns some sort of subroutine

Re: upgrading dbi

2005-05-17 Thread Jonathan Leffler
Please try reporting the actual versions as found by the software - DBD.pmis a documentation module (perldoc DBI::DBD), and the version found in DBI.pm would be of more relevance. perl -MDBI -e 'print $DBI::VERSION\n' And Perl 5.006001 is hardly the most recent version of Perl. On 5/17/05,

Re: nonblocking OCI in DBD::Oracle?

2005-05-17 Thread Tim Bunce
My best advice is to just do it while working hard to keep the changes limited in scope (so the diffs are easy to read, else it won't get integrated back). http://search.cpan.org/~timb/DBD-Oracle/Oracle.pm#How_to_create_a_patch_using_Subversion Use dbi-dev@perl.org for discussions on API issues,

Re: DBD::Informix and SIGBUS in perl

2005-05-17 Thread Tim Bunce
On Tue, May 17, 2005 at 04:17:15PM -0700, Jonathan Leffler wrote: Also, the example code used $dbh-can() as if it returns some sort of subroutine reference - whereas the manual only says it returns true or false. Is the DBI manual inaccurate or just incomplete and it actually returns