DBD::Informix

2023-06-23 Thread Ajay Sishodia via dbi-users
Hi, I am trying to install DBD::Informix on Solaris 11.3 that has Informix14.10 database installed. It can build Makefile but than make just hangs. root@plum:~# env |sort _=/usr/bin/env A__z="*SHLVL DBD_INFORMIX_NO_RESOURCE=yes DBD_INFORMIX_USERNAME=sysadmin DISPLAY=localhost:10.0 EDIT

Re: Issue with build/test of DBD::Informix - implicit function declaration: MIN

2016-01-26 Thread Jonathan Leffler
sage. - > > "dbdimp.ec", line 285: warning: implicit function declaration: MIN > > > > Then most all tests fail with following message. - > > install_driver(Informix) failed: Can't load > '/home/dzepp/.cpan/build/DBD-Informix-2015.1101-RpDmke/blib/a

Re: DBD::Informix

2014-07-09 Thread Helmut
Hi Martin, i tried both, no change/success.. ..also copying the libdl.so to the Informix-Lib-Dir Helmut Am 09.07.2014 18:22, schrieb Martin J. Evans: On 09/07/14 15:58, Helmut wrote: Hi all, i have problems building DBD::Informix. Running Makefile.pl ends up with .. /opt/IBM/informix/lib

Re: DBD::Informix

2014-07-09 Thread Helmut
does not show a linking operation, but it is a linking operation which is failing, which is very puzzling. I'll see what I can do to reproduce it. On Wed, Jul 9, 2014 at 7:58 AM, Helmut mailto:h...@hzlabs.de>> wrote: Hi all, i have problems building DBD::Informix. Runnin

Re: DBD::Informix

2014-07-09 Thread Jonathan Leffler
l 9, 2014 at 7:58 AM, Helmut wrote: > Hi all, > > i have problems building DBD::Informix. > > Running Makefile.pl ends up with > > .. > /opt/IBM/informix/lib/libifasf.so: undefined reference to `dlopen' > /opt/IBM/informix/lib/esql/libifos.so: undefined refe

Re: DBD::Informix

2014-07-09 Thread Martin J. Evans
On 09/07/14 15:58, Helmut wrote: Hi all, i have problems building DBD::Informix. Running Makefile.pl ends up with .. /opt/IBM/informix/lib/libifasf.so: undefined reference to `dlopen' /opt/IBM/informix/lib/esql/libifos.so: undefined reference to `crypt' /opt/IBM/informix/lib/l

DBD::Informix

2014-07-09 Thread Helmut
Hi all, i have problems building DBD::Informix. Running Makefile.pl ends up with .. /opt/IBM/informix/lib/libifasf.so: undefined reference to `dlopen' /opt/IBM/informix/lib/esql/libifos.so: undefined reference to `crypt' /opt/IBM/informix/lib/libifasf.so: undefined reference to `dlc

Re: DBD::Informix test failures

2013-11-12 Thread Jonathan Leffler
NOLOG. If set, the test that relies on being able to rollback changes in a temporary table will fail because the configuration parameter removes the ability to rollback changes in temporary tables. The test will be updated and a new DBD::Informix released, probably before Christmas; the build is worki

Re: DBD::Informix test failures

2013-11-12 Thread John Beranek
On 12/11/2013 08:59, John Beranek wrote: I'm trying to compile DBD::Informix on a Linux server (or alternatively on a Solaris 10 server, but this shows the same problems) but I'm getting failures in the test suite. Firstly, I've fixed the subject, that is the subject I had init

DBD::Informix

2013-11-12 Thread John Beranek
[Posted this on the newsgroup previously, but then realised that's only an archive...] I'm trying to compile DBD::Informix on a Linux server (or alternatively on a Solaris 10 server, but this shows the same problems) but I'm getting failures in the test suite. OS: CentOS 6.

Re: DBD::Informix

2013-07-21 Thread Francois Le Hir
I ran into the exact same issue as detailed below. I am unable to build DBD:: Informix on a Linux system. Was a solution identified for this issue ? Thanks Francois Le Hir From:*Jonathan Leffler* Date: June 30, 2013 17:55 Subject: Re: DBD::Informix Message ID: CAH+RLGHj

Re: DBD::Informix

2013-06-30 Thread Jonathan Leffler
On Sun, Jun 30, 2013 at 2:38 AM, Dr. Helmut Zeilinger wrote: > I have Problems to build DBD::Informix (DBD-Informix-2013.0521). > > The output of "bug_report ('B')" is attached.. > I'm sorry you've run into problems. Thank you for using the bug repor

DBD::Informix

2013-06-30 Thread Dr. Helmut Zeilinger
Hi all, i have Problems to build DBD::Informix (DBD-Informix-2013.0521). The output of "bug_report ('B')" is attached.. (compressed with gzip) Thank You ! Helmut bug_report.gz Description: application/gzip

DBD::Informix

2012-08-27 Thread Roy Fulbright
I am having trouble installing DBD::Informix on Windows 7 with Activestate Perl 5.8.9. I am using MS Visual C++ Express to compile the C code. You can see all the details in my question on Perlmonks: http://perlmonks.org/?node_id=987922 I'm down to linker errors for unresolved ext

Re: strawberry perl dbd-informix build

2012-03-12 Thread BeGooden-IT Vercelletto
fine for what I > > use it for... > > > ** ** > > > To use copy the attached to the same directory as the dbd-informix > > distribution: > > > ** ** > > > set INFORMIXDIR to the correct place (ie > > c:\progra~1\ibm\informix\client-sdk) &

Re: strawberry perl dbd-informix build

2012-02-06 Thread Jonathan Leffler
Congratulations, Crispin, and thank you for sharing this. On Mon, Feb 6, 2012 at 09:15, Boylan, Crispin wrote: > I’ve managed to build dbd-informix 2011.0612 on Win32 with Strawberry Perl > 5.12.3 and Informix CSDK 3.50.TC8 > > ** ** > > I’m attaching the changes I had to

strawberry perl dbd-informix build

2012-02-06 Thread Boylan, Crispin
Hi all, I've managed to build dbd-informix 2011.0612 on Win32 with Strawberry Perl 5.12.3 and Informix CSDK 3.50.TC8 I'm attaching the changes I had to make here, in case anyone finds it useful. Any pointers or improvements welcome! it seems to work fine for what I use it for... T

Re: Apache:DBI DBD::Informix and dbping

2011-09-01 Thread Jonathan Leffler
On Thu, Sep 1, 2011 at 02:10, Clive Eisen wrote: > I'm using mod_perl and Informix, and therefore Apache::DBI and > DBD::Informix > It seems I am running into stale database handles > That is to say a connect in my code 'works' but any operation on the dbh > fa

Re: Apache:DBI DBD::Informix and dbping

2011-09-01 Thread Clive Eisen
On 01/09/2011 12:16, John R Pierce wrote: On 09/01/11 2:10 AM, Clive Eisen wrote: What 'simple' piece of sql do the team suggest? select 1 from systables where tabid =1 why not just SELECT TRUE; ? because that is not valid sql unless you are using a toy database

Re: Apache:DBI DBD::Informix and dbping

2011-09-01 Thread John R Pierce
On 09/01/11 2:10 AM, Clive Eisen wrote: What 'simple' piece of sql do the team suggest? select 1 from systables where tabid =1 why not just SELECT TRUE; ? -- john r pierceN 37, W 122 santa cruz ca mid-left coast

Apache:DBI DBD::Informix and dbping

2011-09-01 Thread Clive Eisen
I'm using mod_perl and Informix, and therefore Apache::DBI and DBD::Informix It seems I am running into stale database handles That is to say a connect in my code 'works' but any operation on the dbh fails with a can't call method 'blah' on an undefined value

Re: DBD::Informix 2 test failures attempting to install AIX 5.3

2011-07-26 Thread Martin J. Evans
On 26/07/11 01:36, Oborn, Gary wrote: Attempting to install DBD::Informix via cpan on AIX 5.3 TL11 SP 07 with Informix DS 11.50 FC6. Perl is the AIX LPP version 5.8.8 in /usr/opt/perl5. C compiler is IBM vac, looks like version 7. While this is a 64 bit environment, the perl by default is 32

DBD::Informix 2 test failures attempting to install AIX 5.3

2011-07-26 Thread Oborn, Gary
Attempting to install DBD::Informix via cpan on AIX 5.3 TL11 SP 07 with Informix DS 11.50 FC6. Perl is the AIX LPP version 5.8.8 in /usr/opt/perl5. C compiler is IBM vac, looks like version 7. While this is a 64 bit environment, the perl by default is 32 bit and so I installed CSDK 11.70 UC3 in

DBD::Informix -1820

2010-12-24 Thread Clive Eisen
I'm using DBD::Informix and mod_perl and was having a problem with a -1820 error (-1820: Host variable type has been changed between fetches or puts) hitting a particular query on a second or subsequent execute of a prepared statement. So I decided to check the DBD build and running the

Re: DBD::Informix -- Failure with make test

2010-07-22 Thread Julie Bouillon
t; > I'm trying to build DBD::Informix on AIX but when I'm executing a make test, it fails at every test with an unresolved symbol error (ifx_checkAPI). This comes from checkapi.o - or should do. What's puzzling is that the 'library' list correctly includes the obje

Fwd: DBD::Informix -- Failure with make test

2010-07-21 Thread Jonathan Leffler
> =A0 =A0config_args=3D'-d -Dcc=3Dcc_r -Duseshrpli= b -Dusethreads -Duse64bitall -Dprefix=3D/usr/opt/perl5_64' ] -- Forwarded message -- From: Jonathan Leffler Date: Wed, Jul 21, 2010 at 7:21 AM Subject: Re: DBD::Informix -- Failure with make test To: Julie Bouillon C

DBD::Informix -- Failure with make test

2010-07-20 Thread Julie Bouillon
Hello all, I'm trying to build DBD::Informix on AIX but when I'm executing a make test, it fails at every test with an unresolved symbol error (ifx_checkAPI). Any help on that would be greatly apreciated, I'm banging my head on the wall with this problem... The details are

DBD::Informix compile problem solved

2009-11-18 Thread m. allan noah
I had some problem installing DBD::Informix on a particular HPUX 11.31 host, though it worked on other supposedly identical machines. I would document the solution for the archives/google: The driver builds, but most tests fail. The error message is interesting, the linker is complaining about

Re: DBD::Informix on OSX

2008-10-29 Thread Clive Eisen
ake test If anyone has the magic incantation to build a 64bit perl so I can build DBD::Informix against the 64bit SDK that would be great. TIA -- Clive Sorry to reply to my own post, but I have solved the problem - so for anyone else here goes #First download perl source - I used 5.10.0 #unt

DBD::Informix on OSX

2008-10-27 Thread Clive Eisen
s the magic incantation to build a 64bit perl so I can build DBD::Informix against the 64bit SDK that would be great. TIA -- Clive

Re: Install DBD-Informix on 64bit RHEL

2008-10-09 Thread Jonathan Leffler
32bit software will > run. > > Everything goes fine until we got this DBD-Informix problem. Because the > > perl is a 64bit version (5.10.0), but the esql is a 32bit. We got error > > messages as following, > > You cannot link a 32 bit library to a 64 bit program (or vice versa). >

Re: Install DBD-Informix on 64bit RHEL

2008-10-09 Thread Peter J. Holzer
On 2008-10-09 10:58:01 +1000, Changcheng Zou wrote: > I got a 64bit RHEL running 32bit IDS11(we don't have 32bit IDS). The > processor is a Xeon 3000, therefore I believe that 32bit software will run. > Everything goes fine until we got this DBD-Informix problem. Because the >

Install DBD-Informix on 64bit RHEL

2008-10-08 Thread Changcheng Zou
Dear Everyone, I got a 64bit RHEL running 32bit IDS11(we don't have 32bit IDS). The processor is a Xeon 3000, therefore I believe that 32bit software will run. Everything goes fine until we got this DBD-Informix problem. Because the perl is a 64bit version (5.10.0), but the esql is a 32bit. W

RE: A Question about DBD-Informix

2008-07-31 Thread Curtis Leach
Thanks for your insight. We'll see how things go. Curtis From: Jonathan Leffler [mailto:[EMAIL PROTECTED] Sent: Thursday, July 31, 2008 2:42 PM To: Curtis Leach Cc: dbi-users@perl.org Subject: Re: A Question about DBD-Informix On Thu, Jul 31, 2008

Re: A Question about DBD-Informix

2008-07-31 Thread Jonathan Leffler
On Thu, Jul 31, 2008 at 8:16 AM, Curtis Leach <[EMAIL PROTECTED]> wrote: > I'm running into a problem installing DBD-Informix. > > I'm running Perl version 5.8.2 on AIX against Informix 10 with the > current DBI. > Well, given what you say below, I shouldn&#x

A Question about DBD-Informix

2008-07-31 Thread Curtis Leach
I'm running into a problem installing DBD-Informix. I'm running Perl version 5.8.2 on AIX against Informix 10 with the current DBI. The version of the Informix SDK is 2.01, with no option to upgrade since later releases enforce XA compliance and regrettably a lot of our other non-perl

RE: DBI::Informix and DBD::Informix

2007-09-10 Thread CAMPBELL, BRIAN D \(BRIAN\)
rs Mailing List Subject: Re: DBI::Informix and DBD::Informix Hi Brian Is there a URL where I can download the driver? for some reason I could'nt get ahold of any of the other supposedly working DLLs.. Thanks! Martin This email message and any files transmitted with it contain confidential

Re: DBI::Informix and DBD::Informix

2007-08-31 Thread Martin Gainty
ED]> To: "Jonathan Leffler" <[EMAIL PROTECTED]>; "DBI Users Mailing List" Sent: Wednesday, August 29, 2007 3:38 PM Subject: RE: DBI::Informix and DBD::Informix FYI... While Jonathan doesn't support DBD::Informix on Windows, I have been able to take hi

RE: DBI::Informix and DBD::Informix

2007-08-29 Thread CAMPBELL, BRIAN D \(BRIAN\)
FYI... While Jonathan doesn't support DBD::Informix on Windows, I have been able to take his source and build a Windows version that works with ActiveState Perl. For two different versions if DBD::Informix, the most recent version being 200502. So it is possible, but requires the proper wi

Re: DBI::Informix and DBD::Informix

2007-08-27 Thread Jonathan Leffler
; > > >On 8/27/07, Martin Gainty <[EMAIL PROTECTED]> wrote: > > > Anyone know where the DBD::Informix and DBI::Informix packages are > >located? > > > >DBD::Informix is located on CPAN, as usual. > > > >There is no DBI::Informix package that I kno

Fwd: DBI::Informix and DBD::Informix

2007-08-27 Thread Jonathan Leffler
Oops - omitted dbi-users; sorry. -- Forwarded message -- From: Jonathan Leffler <[EMAIL PROTECTED]> Date: Aug 27, 2007 6:43 PM Subject: Re: DBI::Informix and DBD::Informix To: Martin Gainty <[EMAIL PROTECTED]> On 8/27/07, Martin Gainty <[EMAIL PROTECTED]> wr

DBI::Informix and DBD::Informix

2007-08-27 Thread Martin Gainty
Evening All Anyone know where the DBD::Informix and DBI::Informix packages are located? Thanks! Martin-- This email message and any files transmitted with it contain confidential information intended only for the person(s) to whom this email message is addressed. If you have received this

Re: DBD::Informix

2007-08-24 Thread Martin Gainty
; Sent: Friday, August 24, 2007 10:04 AM Subject: DBD::Informix Hello! I have problem with compiling DBD::Informix. Could anybody help me ? Piotr Poloczek -- Mobilne wiadomości w Twojej komórce http://link.interia.pl/f1b71

Re: DBD::Informix

2007-08-24 Thread Jonathan Leffler
On 24 Aug 2007 16:04:06 +0200, Piotr Poloczek <[EMAIL PROTECTED]> wrote: > Hello! > > I have problem with compiling DBD::Informix. > Could anybody help me ? Note the part of the diagnostic output that says: ===QUOTE=== Using INFORMIXDIR=/u/informix and ESQL/C compiler esql U

DBD::Informix

2007-08-24 Thread Piotr Poloczek
Hello! I have problem with compiling DBD::Informix. Could anybody help me ? Piotr Poloczek -- Mobilne wiadomości w Twojej komórce >>> http://link.interia.pl/f1b71 bugreport.out Description: Binary data

Re: DBD::Informix test failure for lvarchar - bug found!

2007-06-14 Thread Mark Abajian
Dear Mr. Leffler, When I saw this Tuesday night, I thought... wow. Thanks so much for pursuing this bug report. I will feel more confident in using DBD::Informix, now that you have verified that this bug will not bite us in our present configuration (no lvarchar not null columns). I&#

DBD::Informix test failure for lvarchar - bug found!

2007-06-12 Thread Jonathan Leffler
e IBM/Informix CQ database. Sadly, as yet, I do not have a workaround or fix for this -- that comes next. The reproduction code follows: /* ** @(#)$Id: bug-lvcnn.ec,v 1.3 2007/06/13 05:35:27 jleffler Exp $ ** ** Demonstration of bug originally reported in DBD::Informix ** as RT#13708 at http://rt.cpa

Re: DBD::Informix test failure for lvarchar

2007-06-04 Thread John Siracusa
exact differences. I'll post more when I have more information. In the meantime, I just wanted to add my basic "we can't use LVARCHAR columns with DBD::Informix either" report. Here's the info on machines where selecting a row with an lvarchar column causes a segfault: uname

Re: DBD::Informix test failure for lvarchar

2007-06-03 Thread Jonathan Leffler
ppen on a third. We have yet to narrow down > the exact differences. I'll post more when I have more information. In the > meantime, I just wanted to add my basic "we can't use LVARCHAR columns with > DBD::Informix either" report. Sorry, this is using the latest

Re: DBD::Informix test failure for lvarchar

2007-06-02 Thread John Siracusa
differences. I'll post more when I have more information. In the > meantime, I just wanted to add my basic "we can't use LVARCHAR columns with > DBD::Informix either" report. Sorry, this is using the latest DBD::Informix form CPAN, in case that wasn't clear. We'

Re: DBD::Informix test failure for lvarchar

2007-06-02 Thread John Siracusa
. In the meantime, I just wanted to add my basic "we can't use LVARCHAR columns with DBD::Informix either" report. -John

Re: DBD::Informix test failure for lvarchar

2007-06-02 Thread Jonathan Leffler
On 6/1/07, Mark Abajian <[EMAIL PROTECTED]> wrote: In reply to a recent inquiry about my post... I have not resolved the issue. There is no resolution yet from the Guardian of DBD::Informix. Still true - but I will proffer the information that I too have problems now which I clearly

Re: DBD::Informix test failure for lvarchar

2007-06-01 Thread Mark Abajian
In reply to a recent inquiry about my post... I have not resolved the issue. There is no resolution yet from the Guardian of DBD::Informix. Here is what I have learned on my own... (in all cases, this is using Informix IDS 10.00 on a remote host, and the client is on Solaris 8, DBI is

DBD::Informix test failure for lvarchar

2007-05-14 Thread Mark Abajian
[This is my second attempt to post. First was refused for overly- long attachment.] Hello. I hope I have enough information here for someone to assist with a DBD::Informix problem. I am installing DBD::Informix on a Solaris 8 host. We have a 32-bit Perl 5.8.6, compiled with gcc 3.4.3

DBD::Informix Test Error On 64bit Linux (RHEL4.4)

2007-02-22 Thread Jim Kenedy
rying to install this module using Bundle::DBD::Informix but the t/t20error.t test is failing. I've narrowed it down to the fact that in t/t20error.t the ISAM error number in $msg is incorrect (here it's 4294967196 when it should be 100): DBD::Informix::st execute failed: SQL: -239: Could

Re: DBD::Informix Test Error On 64bit Linux (RHEL4.4)

2007-02-22 Thread Guardian of DBD::Informix
output. -- I'm trying to install this module using Bundle::DBD::Informix but the t/t20error.t test is failing. I've narrowed it down to the fact that in t/t20error.t the ISAM error number in $msg is incorrect (here it's 4294967196 when it should b

AW: DBD::Informix Make test Problem

2007-02-16 Thread Govinda.Pfister
d faulty data not ok 15 # Test: do('DELETE FROM DBD_IX_Trans01'): ok 16 ok 17 # Warning Message: # <> # SQLSTATE = # InTransaction = 1 # Row 1: Got unexpected value <<12/25/2096>> for col03 (key value = 4) when <<12/25/1996>> expected! # Row 2: Got unexpected value

Re: DBD::Informix and SELECT from MULTISET column

2007-02-15 Thread Jonathan Leffler
est data (eg, "1, {2,3}" etc) > > When I use this test script: > > _BEGIN_ > use DBI; > use DBD::Informix qw(:ix_types); > my $dbh = DBI->connect(...); > my $sth = $dbh->prepare('SELECT col2 FROM test'); > $sth->execute(); > my $col2; > $sth-

Re: DBD::Informix and SELECT from MULTISET column

2007-02-15 Thread tvilliers
d insert a couple of rows of test data (eg, "1, {2,3}" etc) > > When I use this test script: > > _BEGIN_ > use DBI; > use DBD::Informix qw(:ix_types); > my $dbh = DBI->connect(...); > my $sth = $dbh->prepare('SELECT col2 FROM test'); > $sth->ex

WG: DBD::Informix Make test Problem

2007-02-14 Thread Govinda.Pfister
for your pleasure... -Ursprüngliche Nachricht- Von: Pfister, Govinda Gesendet: Mittwoch, 14. Februar 2007 19:05 An: 'Jonathan Leffler' Betreff: AW: DBD::Informix Make test Problem Hello Jonathan, Here comes the output of esql -V IBM Informix CSDK Version 2.90, IBM Inf

Re: DBD::Informix Make test Problem

2007-02-14 Thread Jonathan Leffler
On 2/14/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: I do have a problem with "make test" run for the DBD::Informix module. The error is shown below. What is the problem? Is it safe to proceed to "make install"? Not comfortable - I wouldn't r

DBD::Informix Make test Problem

2007-02-14 Thread Govinda.Pfister
Hello List, I do have a problem with "make test" run for the DBD::Informix module. The error is shown below. What is the problem? Is it safe to proceed to "make install"? Thanks for your help in advance! Govinda uname -a -- SunOS ds68001a

Re: installing DBD-Informix on fedora 6

2007-01-31 Thread Oliver Howe
; perl -MCPAN -e 'install Bundle::DBI' >> > groupadd -g 300 informix >> > useradd -u 200 -g 300 informix >> > source /etc/profile.d/informix.sh - see below for this files content >> > vi /etc/services - i add "sqlexec 1526/tcp informix" at t

Re: installing DBD-Informix on fedora 6

2007-01-30 Thread Jonathan Leffler
ix > source /etc/profile.d/informix.sh - see below for this files content > vi /etc/services - i add "sqlexec 1526/tcp informix" at the bottom > mkdir /opt/informix > chown informix.informix /opt/informix/ > cd /opt/informix/ > tar xvf clientsdk.2.90.UC2.LINUX.tar > cd cl

Re: installing DBD-Informix on fedora 6

2007-01-30 Thread Oliver Howe
followed your installation procedure. >Though I got the same warnings from esqlc, I did get a Makefile, it >compiled, and works in a test script. > >I therefore suspect the problem is on your database side, ie, user >permissions, etc. > > >[EMAIL PROTECTED] DBD-Informix-2005.02]# p

Re: installing DBD-Informix on fedora 6

2007-01-30 Thread Tielman de Villiers
s from esqlc, I did get a Makefile, it compiled, and works in a test script. I therefore suspect the problem is on your database side, ie, user permissions, etc. [EMAIL PROTECTED] DBD-Informix-2005.02]# perl rmautoinst.pl Makefile.PL | perl - Configuring IBM Informix Database Driver for Perl DBI V

Re: installing DBD-Informix on fedora 6

2007-01-30 Thread Oliver Howe
gt; cd clientsdk.2.90.UC2.LINUX.tar > ./install_rpm > cd > tar xvzf DBD-Informix-2005.02.tar.gz > cp /opt/informix/etc/sqlhosts.std /opt/informix/etc/sqlhosts > vi /opt/informix/etc/sqlhosts - i add the db server here > perl rmautoinst.pl Makefile.PL | perl - > make >

Re: installing DBD-Informix on fedora 6

2007-01-30 Thread Peter J. Holzer
On 2007-01-29 21:20:26 -0800, Jonathan Leffler wrote: > This is a key issue (connecting with DB-Access on the server machine). The > error 107 (discussed in previous emails in this thread) has me a bit > puzzled. Does Fedora Core 6 have an error value (from errno.h) for 107? Don't know about Cor

Re: installing DBD-Informix on fedora 6

2007-01-29 Thread Jonathan Leffler
do neither. Treat them both with extreme caution - they are just about equally powerful with respect to IDS. I never do things like building DBD::Informix as either informix or root; I'd find (or create) another user to do the work as. If I actually needed to install DBD::Informix as root,

Re: installing DBD-Informix on fedora 6

2007-01-29 Thread Oliver Howe
>> no i dont see anything from that server when running the esqltest. but on >> the client i can telnet to the server on port 1526 as the user informix. i >> have stopped iptables and ip6tables on the client > >can you snoop on the server to see if any packets reach the interface >at all when ru

Re: installing DBD-Informix on fedora 6

2007-01-29 Thread Oliver Howe
o connect to database server (pmuk2) failed. ISAM: 107: ISAM error: record is locked. so then I tried setting DBD_INFORMIX_USERNAME to root and the password to the root password on the db server but still got the same error. here is the full output :- [EMAIL PROTECTED] DBD-Informix-2005.02]

Re: installing DBD-Informix on fedora 6

2007-01-29 Thread Oliver Howe
esqlbasic? yes, but i get the same output as before [EMAIL PROTECTED] DBD-Informix-2005.02]# esql -o ./esqlbasic esqlbasic.ec && ./esqlb asic esqlc: "esqlbasic.ec", line 93: Warning -33036: This line does not conform to AN

Re: installing DBD-Informix on fedora 6

2007-01-29 Thread Tielman de Villiers
hen running esqltest? >Can you compile and run esqlbasic? yes, but i get the same output as before these are the lines it is complaining about [EMAIL PROTECTED] DBD-Informix-2005.02]# cat -n esqlbasic.ec | grep 93 93 EXEC SQL CREATE TABLE dbd_ix_esqltest (Col01 INTEGER NOT N

Re: installing DBD-Informix on fedora 6

2007-01-29 Thread Tielman de Villiers
On 29/01/07, Oliver Howe <[EMAIL PROTECTED]> wrote: i am having some problems installing DBD-Informix-2005.02 on fedora6. i get stuck at "perl rmautoinst.pl Makefile.PL | perl -" when the esqltest program tries to contact my stores database and times out. this is what

installing DBD-Informix on fedora 6

2007-01-29 Thread Oliver Howe
hi, i am having some problems installing DBD-Informix-2005.02 on fedora6. i get stuck at "perl rmautoinst.pl Makefile.PL | perl -" when the esqltest program tries to contact my stores database and times out. but i'm pretty sure i am following the right steps as it works fine on

Re: FW: DBD::Informix & $SIG{ALRM} & /etc/services

2006-11-11 Thread Lincoln A. Baxter
On Tue, 2006-11-07 at 15:17 +, Tielman de Villiers wrote: > Oracle has a similar issue with timing out, see perldoc DBI "Signal > Handling and Canceling Operations" and also > http://search.cpan.org/~lbaxter/Sys-SigAction/dbd-oracle-timeout.POD. > > The recommended solution for Oracle works fi

FW: DBD::Informix & $SIG{ALRM} & /etc/services

2006-11-07 Thread Tielman de Villiers
-Original Message- From: Jonathan Leffler [mailto:[EMAIL PROTECTED] Sent: 03 November 2006 22:30 On 11/3/06, Jay Hannah <[EMAIL PROTECTED]> wrote: > Oops. I noticed my versions were behind. I upgraded DBI and DBD::Informix. > > I'm still getting the same behavior (

Re: DBD::Informix & $SIG{ALRM} & /etc/services

2006-11-03 Thread Jonathan Leffler
On 11/3/06, Jay Hannah <[EMAIL PROTECTED]> wrote: Oops. I noticed my versions were behind. I upgraded DBI and DBD::Informix. I'm still getting the same behavior (14.3 seconds to time out), so I'm still curious about what might be going on. CSDK probably uses alarm itself

RE: DBD::Informix & $SIG{ALRM} & /etc/services

2006-11-03 Thread Jay Hannah
Oops. I noticed my versions were behind. I upgraded DBI and DBD::Informix. I'm still getting the same behavior (14.3 seconds to time out), so I'm still curious about what might be going on. Thanks, j $ perl -MDBI -e'DBI->installed_versions' Perl: 5.0080

DBD::Informix & $SIG{ALRM} & /etc/services

2006-11-03 Thread Jay Hannah
Weird. My alarm(2) takes 14 seconds? Is DBD::Informix or something else overriding my $SIG{ALRM}? If I substitute the connect() call with a sleep 10, then my alarm(2) takes 2 seconds, as I expected. :) Thanks, j $ cat j.t use strict; use DBI; my $dbh; eval { local $SIG{ALRM} = sub { die

RE: make error: 127 for DBI module on AIX 5.2 (DBD::Informix)

2006-07-21 Thread Jordan Smith
That is basically what I feared. Thanks, though. From: Jonathan Leffler [mailto:[EMAIL PROTECTED] Sent: Thursday, July 20, 2006 5:26 PM To: Jordan Smith Cc: dbi-users@perl.org Subject: Re: make error: 127 for DBI module on AIX 5.2 (DBD::Informix) On 7/20/06

Re: make error: 127 for DBI module on AIX 5.2 (DBD::Informix)

2006-07-20 Thread Jonathan Leffler
l using that compiler, and then you can build and install DBI and DBD::Informix. -- Jonathan Leffler <[EMAIL PROTECTED]> #include Guardian of DBD::Informix - v2005.02 - http://dbi.perl.org "I don't suffer from insanity - I enjoy every minute of it."

Re: DBD::Informix on Solaris

2006-07-06 Thread Jonathan Leffler
to SERIAL - effectively SERIAL4) value. There is a separate function in ESQL/C for retrieving the last allocated SERIAL8 value. Offhand, I don't recall whether DBD::Informix exposes that function. If it doesn't, it probably should. And DBI provides hooks for it to do that - but DBD::I

AW: DBD::Informix on Solaris

2006-07-05 Thread Govinda . Pfister
u may need to do that as the 'root' user.) *** ExtUtils::AutoInstall configuration finished. Subroutine main::WriteMakefile redefined at /usr/local/lib/perl5/site_perl/5.8.7/ExtUtils/AutoInstall.pm line 491. Configuring IBM Informix Database Driver for Perl DBI Version 2005.02 (

Re: DBD::Informix on Solaris

2006-07-04 Thread Jonathan Leffler
On 7/4/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: I have a working informix environment with DBI and DBD::Informix. (see details for version, configuration below). I do have the problem that I cannot get the serial after a insert statement is executed. I always get '0&#x

Re: DBD::Informix on Solaris

2006-07-04 Thread Jonathan Leffler
On 7/4/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: Hello List, I have a working informix environment with DBI and DBD::Informix. (see details for version, configuration below). I do have the problem that I cannot get the serial after a insert statement is executed. I always get &#

Re: DBD::Informix on Solaris

2006-07-04 Thread Tielman de Villiers
Can you post the schema for the stammdatenkundeninfo table please? On 04/07/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: Hello List, I have a working informix environment with DBI and DBD::Informix. (see details for version, configuration below). I do have the problem that I cann

DBD::Informix on Solaris

2006-07-04 Thread Govinda . Pfister
Hello List, I have a working informix environment with DBI and DBD::Informix. (see details for version, configuration below). I do have the problem that I cannot get the serial after a insert statement is executed. I always get '0' back. In the database each inserted record get

AW: DBD::Informix FAILURE CLASS A gcc: language arch=v9 not recog nize d

2006-06-22 Thread Govinda . Pfister
, Govinda Cc: dbi-users@perl.org; [EMAIL PROTECTED] Betreff: Re: DBD::Informix FAILURE CLASS A gcc: language arch=v9 not recognize d On 6/22/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > I do have a big problem with a configuration failure (perl Makefile.PLdoes > not work). > I

Re: DBD::Informix FAILURE CLASS A gcc: language arch=v9 not recognize d

2006-06-22 Thread Jonathan Leffler
in my experience. If you decide to go ahead with a 64-bit Perl, then you have another preparatory step to do when you are ready to install DBD::Informix again. You'll need to modify the esql script to remove the -xarch=v9 directive that is specific to the Sun C compiler and replace it with t

DBD::Informix FAILURE CLASS A gcc: language arch=v9 not recognize d

2006-06-22 Thread Govinda . Pfister
srssa/bin:/opt/SUNWsrsvp/bin:/opt/SUNWstade/bin:/opt/VRTS/bin:/opt/VRTSob/bin:/opt/VRTSvlic/bin:/opt/VRTSvmsa/bin:/opt/sun/bin:/opt/tools/bin:/bin:/users/es7601a/user1/aradmin:/opt/gnu/bin:/usr/sbin:/appl/local/informix/bin:/appl/local/informix/ARSPROD/scripts:/appl/local/informix/bin:/appl/local

Re: How many rows can be fetched using DBD::Informix?

2006-01-10 Thread Tim Bunce
On Tue, Jan 10, 2006 at 01:14:35PM -0500, Jeffrey Seger wrote: > I can attest that there is no max number of rows set, or at least if there > is, it's way higher than 35k. I have pulled hundreds of thousands of rows > from an informix database using DBI with no limit found yet. However, what > yo

Re: How many rows can be fetched using DBD::Informix?

2006-01-10 Thread Jeffrey Seger
I can attest that there is no max number of rows set, or at least if there is, it's way higher than 35k. I have pulled hundreds of thousands of rows from an informix database using DBI with no limit found yet. However, what you are doing with those rows matters greatly. If you are throwing them

Re: How many rows can be fetched using DBD::Informix?

2006-01-10 Thread John Scoles
I do not think there is any maximum # of rows. As I have have use queries with it well over 35k rows. It would be dependant on the size of fields in each row and the amount of memory you have. In this case I think you query is simply running out of memory. Try using a cursor in your SQL or use

Re: How many rows can be fetched using DBD::Informix?

2006-01-10 Thread Jonathan Leffler
done > Running 'fetch' Out of memory! > Issuing rollback() for database handle being DESTROY'd without > explicit disconnect(). > > I am running perl 5.8.7 on a Sun Ultra 60 with 2Gb of Ram, using > Solaris 8. I am using DBI-1.50 and DBD-Informix-2005-02.

How many rows can be fetched using DBD::Informix?

2006-01-10 Thread Elton Hughes
ack() for database handle being DESTROY'd without explicit disconnect(). I am running perl 5.8.7 on a Sun Ultra 60 with 2Gb of Ram, using Solaris 8. I am using DBI-1.50 and DBD-Informix-2005-02. Did I forget anything? It looks like that during fetchall_arrayref the system is running o

Re: Installing DBI on Solaris for DBD::informix

2005-12-07 Thread Jonathan Leffler
#x27;install Bundle::CPAN' OK - I thought that should work. Sorry for a bum steer. Run cpan (or 'perl -MCPAN -e shell') and follow its directions. It'll suggest installing Bundle::CPAN. When I try that, the system responds with "don't know what it is" > message

RE: Installing DBI on Solaris for DBD::informix

2005-12-07 Thread Rutherdale, Will
ughes [mailto:[EMAIL PROTECTED] Sent: Wednesday 07 December 2005 12:41 To: Jonathan Leffler Cc: DBI Users Subject: Re: Installing DBI on Solaris for DBD::informix Hello Jonathan, Thank you for your email and your time. I really appreciate it. I recognize your name and know your expertise is

Re: Installing DBI on Solaris for DBD::informix

2005-12-07 Thread Elton Hughes
ng (or CPANPLUS). That's not too hard: perl -MCPAN -e 'install Bundle::CPAN' When I try that, the system responds with "don't know what it is" message, followed by "Try the command i /Bundle::CPAN/" to find objects with matching identifiers. Before

Re: Installing DBI on Solaris for DBD::informix

2005-12-06 Thread Jonathan Leffler
had to install anything in a long time. So bear with me, I am > rusty at this. > > Can I use the CPAN module to do this? If so, would 'install DBI' be > the proper command? Followed by 'install DBD::Informix'? Yes, with caveats. Presumably you're using

  1   2   3   4   5   >