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
*
*
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
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
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
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
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
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
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
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 ?
>
>
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
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
>
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
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
Does the latest version of DBI work with ORacle 9i?
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
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
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
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
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
_/ _/ _/_/_/
_/ _/ _/
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
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
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
> 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
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-
24 matches
Mail list logo