Re: question for DBD-Oracle driver

2008-04-10 Thread Peter J. Holzer
On 2008-04-09 13:07:55 -0500, James H. McCullars wrote: At 10:47 AM 4/9/2008, pgodfrin wrote: This will obviate the need to use LD_LIBRARY_PATH, which has some controversy surrounding it's use. I also found a strangeness for the install of DBD. If I remember correctly, the install document

Re: question for DBD-Oracle driver

2008-04-10 Thread pgodfrin
On Apr 9, 1:07 pm, [EMAIL PROTECTED] (James H. McCullars) wrote: At 10:47 AM 4/9/2008, pgodfrin wrote: This will obviate the need to use LD_LIBRARY_PATH, which has some controversy surrounding it's use. I also found a strangeness for the install of DBD. If I remember correctly, the install

Re: question for DBD-Oracle driver

2008-04-10 Thread James H. McCullars
At 02:17 AM 4/10/2008, Peter J. Holzer wrote: I've just been through an install of DBD::Oracle on a Solaris 10 machine and this was my experience as well. My needs were complicated by the fact that I was running it as a CGI script and thus did not have a way to easily set an

Re: question for DBD-Oracle driver

2008-04-10 Thread Peter J. Holzer
On 2008-04-10 08:27:06 -0500, James H. McCullars wrote: At 02:17 AM 4/10/2008, Peter J. Holzer wrote: I've just been through an install of DBD::Oracle on a Solaris 10 machine and this was my experience as well. My needs were complicated by the fact that I was running it as a CGI script and

Re: question for DBD-Oracle driver

2008-04-10 Thread Ulisses Reina Montenegro de Albuquerque
On Thu, 2008-04-10 at 16:08 +0200, Peter J. Holzer wrote: On 2008-04-10 08:27:06 -0500, James H. McCullars wrote: At 02:17 AM 4/10/2008, Peter J. Holzer wrote: I've just been through an install of DBD::Oracle on a Solaris 10 machine and this was my experience as well. My needs were

Re: question for DBD-Oracle driver

2008-04-10 Thread James H. McCullars
At 09:08 AM 4/10/2008, Peter J. Holzer wrote: Why shouldn't it work with a CGI script? I can think of reasons why it wouldn't work with mod_perl, but none for a CGI script. Setting the environment variable worked for me from the command line but never from a CGI script. The best

Re: question for DBD-Oracle driver

2008-04-10 Thread Peter J. Holzer
On 2008-04-10 10:26:50 -0500, James H. McCullars wrote: At 09:08 AM 4/10/2008, Peter J. Holzer wrote: Why shouldn't it work with a CGI script? I can think of reasons why it wouldn't work with mod_perl, but none for a CGI script. Setting the environment variable worked for me from the

RE: question for DBD-Oracle driver

2008-04-09 Thread Capacio, Paula J
On March 28, Icheng said: After I try the command you provide, I got the following error Can't load '/opt/perl5/lib/site_perl/5.8.0/PARISC2.0/auto/DBD/Oracle/Oracle.sl' for module DBD::Oracle: No such file or directory at /opt/perl5/lib/5.8.0/PA-RISC2.0/DynaLoader.pm line 229. at test_dbd_ver.pl

RE: question for DBD-Oracle driver

2008-04-09 Thread Capacio, Paula J
On March 28, Fred Vachon said: I have DBI and DBD::Oracle installed on a Solaris 10 machine. When I run either of the 2 commands that were posted I error out with: perl -MDBD::Oracle -le 'print $DBD::Oracle::VERSION;' Can't load

Re: question for DBD-Oracle driver

2008-04-09 Thread pgodfrin
On Apr 9, 10:04 am, [EMAIL PROTECTED] (Paula J Capacio) wrote: On March 28, Fred Vachon said: I have DBI and DBD::Oracle installed on a Solaris 10 machine. When I run either of the 2 commands that were posted I error out with: perl -MDBD::Oracle -le 'print $DBD::Oracle::VERSION;' Can't load

Re: question for DBD-Oracle driver

2008-04-09 Thread James H. McCullars
At 10:47 AM 4/9/2008, pgodfrin wrote: This will obviate the need to use LD_LIBRARY_PATH, which has some controversy surrounding it's use. I also found a strangeness for the install of DBD. If I remember correctly, the install document states that LD_LIBRARY_PATH should be set during the module

Re: question for DBD-Oracle driver

2008-04-08 Thread pgodfrin
what version it is ? perl -MDBD::Oracle -le 'print $DBD::Oracle::VERSION;' will show DBD::Oracle version. -Original Message- From: Ian Harisay [mailto:[EMAIL PROTECTED] Sent: Friday, March 28, 2008 12:36 PM To: [EMAIL PROTECTED] Subject: RE: question for DBD-Oracle driver perl -e

Re: question for DBD-Oracle driver

2008-04-08 Thread pgodfrin
what version it is ? perl -MDBD::Oracle -le 'print $DBD::Oracle::VERSION;' will show DBD::Oracle version. -Original Message- From: Ian Harisay [mailto:[EMAIL PROTECTED] Sent: Friday, March 28, 2008 12:36 PM To: [EMAIL PROTECTED] Subject: RE: question for DBD-Oracle driver perl -e

question for DBD-Oracle driver

2008-03-28 Thread ili
Dear sir/madam, How can we tell that we have already install DBD-Oracle drive for DBI ? If we have already install DBD-Oracle, how can we check what version it is ? We have the unix (HP-UX houux14 B.11.11 U 9000/800 196921507 unlimited-user license) installed, and perl version ( v5.8.0

Re: question for DBD-Oracle driver

2008-03-28 Thread John Scoles
give this a try #!perl -w use DBI; use DBD::Oracle qw(:ora_types); print DBD::Oracle::ORA_OCI().\n; if you dbi is 1.47 you can use up to DBD::Oracle 1.19 cheers John Scoles [EMAIL PROTECTED] wrote: Dear sir/madam, How can we tell that we have already install DBD-Oracle drive for

Re: question for DBD-Oracle driver

2008-03-28 Thread John Scoles
[EMAIL PROTECTED] wrote: Thank you so much for providing me this information. After I try the command you provide, I got the following error message. Can't load '/opt/perl5/lib/site_perl/5.8.0/PARISC2.0/auto/DBD/Oracle/Oracle.sl' for module DBD::Oracle: No such file or directory at

Re: question for DBD-Oracle driver

2008-03-28 Thread Martin Evans
[EMAIL PROTECTED] wrote: Dear sir/madam, How can we tell that we have already install DBD-Oracle drive for DBI ? perl -MDBD::Oracle -le 'print $DBD::Oracle::VERSION;' which will error with Can't locate DBD::Oracle... if you haven't got it. If we have already install DBD-Oracle, how

RE: question for DBD-Oracle driver

2008-03-28 Thread Ian Harisay
[mailto:[EMAIL PROTECTED] Sent: Friday, March 28, 2008 9:52 AM To: [EMAIL PROTECTED] Cc: dbi-users@perl.org Subject: Re: question for DBD-Oracle driver give this a try #!perl -w use DBI; use DBD::Oracle qw(:ora_types); print DBD::Oracle::ORA_OCI().\n; if you dbi is 1.47 you can use up to DBD

RE: question for DBD-Oracle driver

2008-03-28 Thread Vachon, Frederick P (Fred) A5IT
version. -Original Message- From: Ian Harisay [mailto:[EMAIL PROTECTED] Sent: Friday, March 28, 2008 12:36 PM To: dbi-users@perl.org Subject: RE: question for DBD-Oracle driver perl -e 'use DBD::Oracle 42' This will tell you what version is currently installed. Generally, I always