looking for Perl DBD/DBI for Informix at AIX

2002-05-14 Thread Avi Veinshtein
I'm looking for Perl DBD/DBI for Informix at AIX. Any information on the subject is appreciated. Please, answer to my email since i'm not subscribed (yet) to the DBI mailing list. Regards, Avi Vainshtein, PNR, Telrad Networks * *

Re: Oracle 9i ?

2002-05-14 Thread Hasanuddin Tamir
On Tue, 14 May 2002, Kipp, James <[EMAIL PROTECTED]> wrote, > Does the latest version of DBI work with ORacle 9i? We developed application with Oracle client 8.1.7 and server 8.0.5 (or something). Once the server was upgraded to 9i and the application couldn't connect anymore. It wasn't the prob

Re: DBD:CSV

2002-05-14 Thread Jeff Zucker
Gaul, Ken wrote: > OK now I am getting > > DBD::CSV::st execute failed: Missing first row at .CSV.pm line 171, > line 1. > > My CSV contains column headings in the first row, is there something I have > to do to handle this? The docs say that that is default behaviour. Yes, the

RE: Get the version in code

2002-05-14 Thread Kipp, James
how about a begin statement near the top of your program something like BEGIN { unshift @INC, "/old_perl/lib/site_perl/5.6.1/sun4-solaris/auto/DBD/Oracle" } or even set the env variable with BEGIN > -Original Message- > From: Jeff Hunter [mailto:[EMAIL PROTECTED]] > Sent: Tue

Re: slow CONNECT to Oracle

2002-05-14 Thread Jeff Hunter
How long does it take to connect via sqlplus? [EMAIL PROTECTED] wrote: >I tried solve it by myself, and I am out of my wits. >Please point me where to look/what to read (RTMF is fine - just what page). > >Problem: >I am running IIS on Win2000 (%.00.2192), + Servce pack 2 >ActiveState Perl 5.6.1

Get the version in code

2002-05-14 Thread Jeff Hunter
We are testing a new version of the Perl DBD linked with the new Oracle 9i client libraries. I have two Oracle.so files, one in ~/old_perl/lib/site_perl/5.6.1/sun4-solaris/auto/DBD/Oracle/Oracle.so and one in ~/new_perl/lib/site_perl/5.6.1/sun4-solaris/auto/DBD/Oracle/Oracle.so. I can swit

RE: Oracle 9i ?

2002-05-14 Thread Kipp, James
I am using DBI 1.21 and DBD::Oracle 1.12 > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, May 14, 2002 4:34 PM > To: Tompkins, Creigh > Cc: DBI Users; 'Fannin, David P.'; [EMAIL PROTECTED] > Subject: RE: Oracle 9i ? > > > > What is the latest

RE: Oracle 9i ?

2002-05-14 Thread dvredeveld
What is the latest DBI version that you have running? I'm trying to use 1.14 in a Perl program against an Oracle 9.0.1.3 database on SunOS 5.7 and am not able to connect. Error message is: DBI->connect(DUMY) failed: ERROR OCIEnvInit However, when running the "perl Makefile.PL -p" and "ma

RE: Oracle 9i ?

2002-05-14 Thread Kipp, James
Thanks Think I have it figured out. I have to reinstall DBD::ORacle and customize the makefile a bit for our environment > -Original Message- > From: Kuo, David [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, May 14, 2002 4:08 PM > To: 'Kipp, James'; DBI Users > Subject: RE: Oracle 9i ? > >

RE: Oracle 9i ?

2002-05-14 Thread Tompkins, Creigh
FYI: The latest DBI does work under Oracle 9i. We have it running on HPUX11i (no fun) and Linux 7.2 64bit. Creigh Tompkins -Original Message- From: Fannin, David P. [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 14, 2002 3:50 PM To: Kipp, James; DBI Users Subject: RE: Oracle 9i ? We ha

RE: Oracle 9i ?

2002-05-14 Thread Kuo, David
We got a 9i server running on a sun box and have no problem. David -Original Message- From: Kipp, James [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 14, 2002 4:01 PM To: DBI Users Subject: RE: Oracle 9i ? Thanks Just wanted to see. Having some trouble with it on SunOS box. thanks >

RE: Oracle 9i ?

2002-05-14 Thread Kipp, James
Thanks Just wanted to see. Having some trouble with it on SunOS box. thanks > -Original Message- > From: Fannin, David P. [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, May 14, 2002 3:50 PM > To: Kipp, James; DBI Users > Subject: RE: Oracle 9i ? > > > We have not compiled DBD::Oracle with

RE: Oracle 9i ?

2002-05-14 Thread Fannin, David P.
We have not compiled DBD::Oracle with the 9i client code, but we have used our existing code (compiled against the 8.0.5 libraries) to connect to 9i servers. There have been no problems except on HPUX 10. -dpf- --- David P. Fannin Database Administrator

Oracle 9i ?

2002-05-14 Thread Kipp, James
Does the latest version of DBI work with ORacle 9i?

DBD 1.12 on Oracle 9i on IBM AIX 4.3

2002-05-14 Thread DeeDee Anders
I am having problems doing make test on our new 9i installation. The DBI installed fine. I can get the DBD to perl Makefile.PL -p (I have to use the -p for it to work) and then make works. However, the make test bombs with the following. Does anyone have any pointers for fixing this in 9i under

RE: Potential Memory Leak

2002-05-14 Thread Job Miller
As Jon said it is a waste of time to prepare the same statement over and over. prepare it outside the loop. In Oracle that would be a waste of CPU resources for the database, not a memory leak for a perl script. Oracle would soft parse the statement each time, which isn't as bad as a hard parse

Re: Potential Memory Leak

2002-05-14 Thread Shawn W. Devlin
Christopher G Tantalo wrote: >>My understanding was that since the $hSql was declared local to the >>while loop, it would be released at the end of the loop. If this is not >>the case, or not the case with DBI/DB2 then that would certainly explain >>my error. >> >>Shawn >> >> > >You are right

Re: Potential Memory Leak

2002-05-14 Thread Shawn W. Devlin
PARLEY,JON (HP-MountainView,ex1) wrote: >I believe that you only need to prepare the statement once (do it before the >infinite loop). My guess is that DB2 is storing identical prepared >statements. > Jon, Thanks for your response. Further analysis... The following code: my $sql = 'select S

RE: Potential Memory Leak

2002-05-14 Thread PARLEY,JON (HP-MountainView,ex1)
I believe that you only need to prepare the statement once (do it before the infinite loop). My guess is that DB2 is storing identical prepared statements. _/ Thunder Jon Parley _/ Software Engineer _/_/_/ _/_/_/ ISSO - Software Mastering _/ _/ _/_/_/ _/ _/ _/

Potential Memory Leak

2002-05-14 Thread Shawn W. Devlin
Hello, The following code leaks 4k of RAM every 10-20 iterations. I can't see anything wrong in my code but that does not mean I have not done something wrong. :-) Can anyone see a problem with the following code? I am running on a Linux box with Perl 5.6.1, DBI version 1.21, and DBD:DB2 vers

Re: slow CONNECT to Oracle

2002-05-14 Thread Felix Geerinckx
on Tue, 14 May 2002 16:58:50 GMT, [EMAIL PROTECTED] (Peter Masiar) wrote: > Problem: > I am running IIS on Win2000 (%.00.2192), + Servce pack 2 > ActiveState Perl 5.6.1 build 631 > DBI 1.14 > Oracle 8.0.5.0.0 for NT > connecting via Oracle ODBC (file has date from 1998) Why ODBC and not DBD::Or

slow CONNECT to Oracle

2002-05-14 Thread peter . masiar
I tried solve it by myself, and I am out of my wits. Please point me where to look/what to read (RTMF is fine - just what page). Problem: I am running IIS on Win2000 (%.00.2192), + Servce pack 2 ActiveState Perl 5.6.1 build 631 DBI 1.14 Oracle 8.0.5.0.0 for NT connecting via Oracle ODBC (file has

Re: DBD::Informix on HPUX 11.00

2002-05-14 Thread Waldemar Zurowski
> I am having problems with the building of DBD::Informix on HPUX 11 > using gcc 3.0.4, the Makefile does not complete. I get the following > output : > gcc: +Ofastaccess: No such file or directory > gcc: +DS2.0: No such file or directory > gcc: +DA1.1: No such file or directory > cc1: Unrecogniz

Re: DBD::Informix on HPUX 11.00

2002-05-14 Thread Jas Grewal
Hi all, I am having problems with the building of DBD::Informix on HPUX 11 using gcc 3.0.4, the Makefile does not complete. I get the following output : ** Configuring IBM Informix Database Driver for Perl Version 1.00.PC2 (2002-02-