On Oct 26, 2009, at 10:57 AM, Charles Jardine wrote:
And the env vars are Properly set:
imap:/home/oracle/scripts # set | grep ORA
ORACLE_HOME=/usr/local/lib/oracle/instantclient
ORACLE_SID=phmweb
imap:/home/oracle/scripts # set | grep LD_LIB
LD_LIBRARY_PATH=/usr/local/lib/oracle/instantclient/
Check you environment settings. It looks like DBD::Oracle can no longer
find the ORACLE_HOME directory.
This means one of two things
1) the ORACLE_HOME is no longer set in the environment or
2) someone has removed/moved/changed files in said directory
cheers
John Scoles
Bruce Johnson wrote:
On 26/10/09 17:39, Bruce Johnson wrote:
New script I'm working on gets this error when I try to connect:
imap:/home/oracle/scripts # ./process_vacnotices.pl
install_driver(Oracle) failed: Can't load
'/usr/lib/perl5/site_perl/5.8.8/i586-linux-thread-multi/auto/DBD/Oracle/Oracle.so'
for module D
New script I'm working on gets this error when I try to connect:
imap:/home/oracle/scripts # ./process_vacnotices.pl
install_driver(Oracle) failed: Can't load '/usr/lib/perl5/site_perl/
5.8.8/i586-linux-thread-multi/auto/DBD/Oracle/Oracle.so' for module
DBD::Oracle: libnnz11.so: cannot open sh
ith the incompatible libc.
>
> Michael
>
>
>
> On Tue, 4 Nov 2008, Raphael Morlec wrote:
>
> Date: Tue, 4 Nov 2008 11:37:45 +0100
>> From: Raphael Morlec <[EMAIL PROTECTED]>
>> To: Jonathan Leffler <[EMAIL PROTECTED]>, dbi-users@perl.org
>> Sub
.
I think that should fix the compilation issue with the incompatible libc.
Michael
On Tue, 4 Nov 2008, Raphael Morlec wrote:
Date: Tue, 4 Nov 2008 11:37:45 +0100
From: Raphael Morlec <[EMAIL PROTECTED]>
To: Jonathan Leffler <[EMAIL PROTECTED]>, dbi-users@perl.org
Subject
Thank you for your answer.
You must be right when you say that my "crash" is a C compilation failure.
The problem is that I am not experienced in C language, and I don't really
know how to resolve the compilation error.
I looked on the web to find information about the GCC compiler, I downloaded
t
On Mon, Nov 3, 2008 at 8:06 AM, Raphael Morlec <[EMAIL PROTECTED]>wrote:
> Hello everybody,
>
> I'm trying without success to install DBI for nearly two days now.
>
> I use a x86_64-linux Mandriva 2007 distribution, with perl 5.8.8 (the shell
> 'perl -V' output is attached).
>
> I tried several wa
Hello everybody,
I'm trying without success to install DBI for nearly two days now.
I use a x86_64-linux Mandriva 2007 distribution, with perl 5.8.8 (the shell
'perl -V' output is attached).
I tried several ways to install DBI :
1. With the CPAN :
I tried 'perl -MCPAN -e shell', then 'install D
Federico Giannici wrote:
Patrick Galbraith wrote:
Sam Smith wrote:
Sam,
Thanks for the trace. I need to talk to someone about getting an
OpenBSD box to test out potential solutions.
I'm available to test a prerelease version of the DBD driver.
Thanks!
It's my intent to roll up a relea
A Standard Problem. OCIW32.DLL is not properly installed. See attached file.
Alexander
On 14.09.2006 01:45, [EMAIL PROTECTED] wrote:
I'm attempting to connect to an Oracle (9.0.1) database and have an Oracle9
client installed on a Windows XP machine. I installed ActivePerl 5.8.8 (build
819)
I'm attempting to connect to an Oracle (9.0.1) database and have an Oracle9
client installed on a Windows XP machine. I installed ActivePerl 5.8.8 (build
819) which came with DBI 1.5.2 pre-installed. Then I used the perl package
manager to install DBD::Oracle 1.1.7. The installations complet
Patrick Galbraith wrote:
Sam Smith wrote:
Sam,
Thanks for the trace. I need to talk to someone about getting an OpenBSD
box to test out potential solutions.
I'm available to test a prerelease version of the DBD driver.
Bye.
--
___
__
f it's memory management that cause the program to
segfault if try to access a non allocated memory. In other
operating systems, a random value is get for
"imp_dbh->bind_type_guessing", which is almost irrelevant.
Federico Giannici wrote:
It seems to me that there is some ki
s.
P.S.
I want to repeat that the problem manifest itself only under
OpenBSD because of it's memory management that cause the program
to segfault if try to access a non allocated memory. In other
operating systems, a random value is get for
"imp_dbh->bind_type_guessing", which
a non allocated memory. In other
operating systems, a random value is get for
"imp_dbh->bind_type_guessing", which is almost irrelevant.
Federico Giannici wrote:
It seems to me that there is some kind of memory access problem
with DBI or DBD-Mysql.
I'm using OpenBSD 3.9-stable am
h) obtained from this is not a valid one!
Anybody can confirm (or negate) this wild hypothesis?
Thanks.
P.S.
I want to repeat that the problem manifest itself only under OpenBSD
because of it's memory management that cause the program to segfault if
try to access a non allocated memory. I
or "imp_dbh->bind_type_guessing", which is
almost irrelevant.
Federico Giannici wrote:
It seems to me that there is some kind of memory access problem with
DBI or DBD-Mysql.
I'm using OpenBSD 3.9-stable amd64. On OpenBSD 3.3 i386 the problem
didn't appeared. As you m
most
irrelevant.
Federico Giannici wrote:
It seems to me that there is some kind of memory access problem with
DBI or DBD-Mysql.
I'm using OpenBSD 3.9-stable amd64. On OpenBSD 3.3 i386 the problem
didn't appeared. As you may know, recent version of OpenBSD have a
new kind of memory han
d_type_guessing", which is almost
irrelevant.
Federico Giannici wrote:
It seems to me that there is some kind of memory access problem with
DBI or DBD-Mysql.
I'm using OpenBSD 3.9-stable amd64. On OpenBSD 3.3 i386 the problem
didn't appeared. As you may know, recent version
which does the statement parsing). It lets the
server do this work.
Thanks!
Patrick
Federico Giannici wrote:
It seems to me that there is some kind of memory access problem with
DBI or DBD-Mysql.
I'm using OpenBSD 3.9-stable amd64. On OpenBSD 3.3 i386 the problem
didn't appea
On 9/4/06, John Gallagher <[EMAIL PROTECTED]> wrote:
I've just run make again and included the output
The system I'm trying to install DBI on is a hp-ux 11.11
And the version of perl installed is 5.8.7
(Bundled) cc: warning 480: The -A option is available only with the
C/ANSI C product; igno
Title: RE: Problem with DBI make
Hi Tim,
I've just run make again and included the output
The system I'm trying to install DBI on is a hp-ux 11.11
And the version of perl installed is 5.8.7
John
-Original Message-
From: Tim Bunce [mailto:[EMAIL PROTECTED]]
On Mon, Sep 04, 2006 at 09:43:11AM +0100, John Gallagher wrote:
>Hi Tim,
>
>I've just run make again and included the output
>The system I'm trying to install DBI on is a hp-ux 11.11
>And the version of perl installed is 5.8.7
> cc -c-D_POSIX_C_SOURCE=199506L -D_REENTR
On Fri, Sep 01, 2006 at 01:06:54PM +0100, John Gallagher wrote:
>
> Hi
>
> I've encountered the below error when running a make for the DBI module;
>
> Make runs up to a certain point but then just bombs with the below message
>
> Perl.c: In function `XS_DBD__Perl__st_DESTROY':
> Perl.c:1054:
Hi
I've encountered the below error when running a make for the DBI module;
Make runs up to a certain point but then just bombs with the below message
Perl.c: In function `XS_DBD__Perl__st_DESTROY':
Perl.c:1054: warning: unused parameter `cv'
Perl.c: In function `boot_DBD__Perl':
Perl.c:1106:
random value is get for "imp_dbh->bind_type_guessing", which is almost
irrelevant.
Federico Giannici wrote:
It seems to me that there is some kind of memory access problem with DBI
or DBD-Mysql.
I'm using OpenBSD 3.9-stable amd64. On OpenBSD 3.3 i386 the problem
didn't
It seems to me that there is some kind of memory access problem with DBI
or DBD-Mysql.
I'm using OpenBSD 3.9-stable amd64. On OpenBSD 3.3 i386 the problem
didn't appeared. As you may know, recent version of OpenBSD have a new
kind of memory handling that make the programs segfault
On Thursday 10 August 2006 16:50, you wrote:
> > #Retrieve data enter for verification
> > $sth = $dbh->prepare (qq {SELECT First_Name, Last_Name, Spouse, email,
> > Home_Phone, Business_Phone, Cell_phone, Occupation_Employer, Status_Key
> > FROM Moses_Lake_Lions WHERE Last_Name = $Last_Name}) or
On 10/08/06, Russbucket <[EMAIL PROTECTED]> wrote:
DBD::mysql::st execute failed: You have an error in your SQL syntax; check the
manual that corresponds to your MySQL server version for the right syntax to
use near '' at line 1 at insertmember.cgi line 56.
Code:
#Insert data
$sth = $dbh->prep
Fairly new o using Perl and DBI.
Have mysql database on SUSE 10.0, perl-5.8.7-5.3, mysql-4.1.13-3.6. I am able
to insert the data from an html form but I want to print the last data
entered for verification. I keep getting the following errors (code shown
below):
/usr/bin/perl insertmember.cgi
On Tue, 2006-07-25 at 09:44 -0400, Garrett, Philip (MAN-Corporate)
wrote:
> This part of DBIx::ContextualFetch is just a statement handle subclass.
> It's trying to call $sth->SUPER::execute() which is where the error is
> occurring. I suppose it could be something about DBI instead of
> DBD::Syba
tt, Philip (MAN-Corporate)
> [mailto:[EMAIL PROTECTED]
> Sent: Monday, July 24, 2006 8:17 PM
> To: Palisetti, Krishna_Mohan; dbi-users@perl.org
> Subject: RE: Problem with DBI
>
>
> Palisetti, Krishna_Mohan wrote:
>>>
>>>> Hi, I'm seeing the following war
thing else entirely...
Michael
Extranet
[EMAIL PROTECTED] - 24/07/2006 17:27
To:Philip.Garrett, dbi-users
cc:mpeppler
Subject: RE: Problem with DBI
We are using, DBD::Sybase v1.02_01. The latest one seems to be v1.07. We
could try the upgrade but it would be difficult to con
-Original Message-
From: Garrett, Philip (MAN-Corporate)
[mailto:[EMAIL PROTECTED]
Sent: Monday, July 24, 2006 8:17 PM
To: Palisetti, Krishna_Mohan; dbi-users@perl.org
Subject: RE: Problem with DBI
Palisetti, Krishna_Mohan wrote:
>>
>>> Hi, I'm seeing the following
Palisetti, Krishna_Mohan; dbi-users@perl.org
Subject: RE: Problem with DBI
Palisetti, Krishna_Mohan wrote:
> Hi, I'm seeing the following warning message from
> DBIx::ContextualFetch intermittently. Use of uninitialized value in
> null operation at
> /usr/local/lib
Palisetti, Krishna_Mohan wrote:
> Hi, I'm seeing the following warning message from
> DBIx::ContextualFetch intermittently. Use of uninitialized value
> in null operation at
> /usr/local/lib/perl5/site_perl/5.8.6/DBIx/ContextualFetch.pm line
> 51.
>
> What does it mean?
Palisetti, Krishna_Mohan wrote:
>>
>>> Hi, I'm seeing the following warning message from
>>> DBIx::ContextualFetch intermittently. Use of uninitialized value in
>>> null operation at
>>> /usr/local/lib/perl5/site_perl/5.8.6/DBIx/ContextualFetch.pm line
>>> 51.
>>>
>>> What does it mean? Sorry, I
Palisetti, Krishna_Mohan wrote:
> Hi, I'm seeing the following warning message from
> DBIx::ContextualFetch intermittently.
> Use of uninitialized value in null operation at
> /usr/local/lib/perl5/site_perl/5.8.6/DBIx/ContextualFetch.pm line 51.
>
> What does it mean? Sorry, I am not in a position
Hi, I'm seeing the following warning message from DBIx::ContextualFetch
intermittently.
Use of uninitialized value in null operation at
/usr/local/lib/perl5/site_perl/5.8.6/DBIx/ContextualFetch.pm line 51.
What does it mean? Sorry, I am not in a position to provide a simple
test case as I still c
er Halliday
> Cc: 'Tim Bunce'; dbi-users@perl.org; [EMAIL PROTECTED]
> Subject: Re: Problem with DBI::Multiplex
>
> On Thu, May 25, 2006 at 04:03:39PM -0400, Peter Halliday wrote:
> > Tim and Thomas,
> >
> > Not sure why this is the case, but I noticed that doin
> So $sth->execute(@_); "didn't work",
> but
> my @tmp = @_;
> $sth->execute(@tmp);
> did?
It was more like this
$sth->execute(@_) didn't work
$sth->execute() did.
Peter Halliday
Excelsior Systems
http://www.excelsiorsystems.net
(Phone:) 607-936-2172
(Support:) 607-329
> -Original Message-
> From: Tim Bunce [mailto:[EMAIL PROTECTED]
> Sent: Friday, May 26, 2006 3:52 AM
> To: Peter Halliday
> Cc: 'Tim Bunce'; dbi-users@perl.org; [EMAIL PROTECTED]
> Subject: Re: Problem with DBI::Multiplex
>
> On Thu, May 25, 2006 at 04:0
> (Phone:) 607-936-2172
> (Support:) 607-329-6905
> (Fax:) 607-398-7928
>
> > -Original Message-
> > From: Tim Bunce [mailto:[EMAIL PROTECTED]
> > Sent: Thursday, May 11, 2006 7:44 AM
> > To: Peter Halliday
> > Cc: dbi-users@perl.org
> > Subject: Re: P
May 11, 2006 7:44 AM
> To: Peter Halliday
> Cc: dbi-users@perl.org
> Subject: Re: Problem with DBI::Multiplex
>
> On Tue, May 09, 2006 at 11:07:38AM -0400, Peter Halliday wrote:
> > I'm trying to load balance reads across two MySQL database that have
> replication. The
How did you download and install?
-Original Message-
From: David Andre [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 23, 2006 1:51 AM
To: dbi-users@perl.org
Subject: problem with dbi module.
Hi,
I'm David ANDRE from caterpillar in Belgium.
i try to use the DBI module with perl 5.8
Hi,
I'm David ANDRE from caterpillar in Belgium.
i try to use the DBI module with perl 5.8.3 on Itanium.
I receive the following message :
naboo:/Upload# ./testperl
Can't locate loadable object for module DBI in @INC (@INC contains:
/opt/perl/lib/5.8.3/IA64.ARCHREV_0-thread-multi /opt/perl/lib/
alliday
> Cc: dbi-users@perl.org
> Subject: Re: Problem with DBI::Multiplex
>
> On Tue, May 09, 2006 at 11:07:38AM -0400, Peter Halliday wrote:
> > I'm trying to load balance reads across two MySQL database
> that have replication. The reads are working wonderful
On Tue, May 09, 2006 at 11:07:38AM -0400, Peter Halliday wrote:
> I'm trying to load balance reads across two MySQL database that have
> replication. The reads are working wonderfully. The inserts actually do
> insert. However, there are some table that use auto increment primary keys.
> I c
I'm trying to load balance reads across two MySQL database that have
replication. The reads are working wonderfully. The inserts actually do
insert. However, there are some table that use auto increment primary keys. I
can't figure out how to actually get those particular keys now.
Peter Ha
Hi,
let me resend my request hoping there is the one who can point at the
solution of the problem.
There are two machines: computer1 and computer2.
Parameters of computer1:
perl 5.6.1
sname=solaris, osvers=2.8, archname=sun4-solaris-thread-64int-ld
DBI 1.41
DBI::ProxyServer 0.3005
DBD::Oracle 1
Hello,
there are two machines: computer1 and computer2.
Parameters of computer1:
perl 5.6.1
sname=solaris, osvers=2.8, archname=sun4-solaris-thread-64int-ld
DBI 1.41
DBI::ProxyServer 0.3005
DBD::Oracle 1.16
DBD::Proxy 0.2004
RPC::PlServer 0.2018
RPC::PlClient 0.2018
Storable 2.11
Parameters of
Hi, DBI group:
I had problem with installing DBI module.
When make, make test, make install, it complained
of c-compiler not found in a non-existent directory.
How can I make DBI generate a Makefile with correct
C compiler path location.
(see errorlog below)
My C-compiler is: /usr/ucb/cc
thanks
There appears to be a problem evaluating the contents of scalars values
which changed between perl 5.005.03 and 5.8.0. If perl evaluates the
contents of a scalar as an integer, even though it is a decimal, DBI/DBD
will later truncate the value of the scalar.
Here's a small example:
#!/usr/local/
On Fri, 11 Jul 2003, Chris Faust wrote:
> I'm having a strange problem when trying to delete a row out of a table using DBI
> (version 1.35 under RH 8) and MySQL 4.01x
>
snip.
>
> Any Ideas?
Try doing a DBI->trace(9) to see what is going on with DBI / DBD::mysql.
Also, it might be helpful to
I'm having a strange problem when trying to delete a row out of a table using DBI
(version 1.35 under RH 8) and MySQL 4.01x
The Table:
create table SiteContact
(
Priority INT(11) auto_increment PRIMARY KEY,
Location VARCHAR(80),
ContactHeader VARCHAR(255),
ContactName VARCHAR(255),
EmailAddress V
hi , i was trying to setup DBI so that it can connect to mysql .
when i tried to install DBD-mysql from that location , it keeps
giving me this responce , is there anything wrong ?
or if you can provide me a better link to install DBD-mysql ?
Hi all,
I have simple perl script which sets the env variables for oracle and then
tries a dbi->connect. From bash it connects without problems but through
apache2 and mod_perl2 it fails with ora-12154. All simple solutions failed :(
The user running the scripts in both cases is the same, env v
- Forwarded message from Vivek Kukrety <[EMAIL PROTECTED]> -
Delivered-To: [EMAIL PROTECTED]
Date: Thu, 3 Oct 2002 23:13:16 -0700 (PDT)
From: Vivek Kukrety <[EMAIL PROTECTED]>
Subject: Problem with DBI
To: [EMAIL PROTECTED]
Hi Tim,
I have a problem with DBI on Windows. I am
r 03, 2002 3:31 PM
To: Beadles, John-Thomas [RICH1:2795:EXCH]
Cc: [EMAIL PROTECTED]
Subject: RE: Performance problem with DBI, DBD-Oracle8
Have him update your DBI & DBD::Oracle to the latest versions.
(1.30) & (1.12)
On 03-Oct-2002 John-Thomas Beadles wro
Have him update your DBI & DBD::Oracle to the latest versions.
(1.30) & (1.12)
On 03-Oct-2002 John-Thomas Beadles wrote:
> It's definite. I implemented it all through my code and dropped the
> execution time from 40+ minutes to approximately 4.5 minutes. I've notified
> t
It's definite. I implemented it all through my code and dropped the
execution time from 40+ minutes to approximately 4.5 minutes. I've notified
the sys admin to the problem, see if we can implement a global solution.
Thanks a bunch, guys!
-Original Message-
From: Beadles, John-Thomas [R
ED]]
Sent: Thursday, October 03, 2002 12:23 PM
To: 'Tim Bunce '; Beadles, John-Thomas [RICH1:2795:EXCH]
Cc: '[EMAIL PROTECTED] '
Subject: RE: Performance problem with DBI, DBD-Oracle8
Why can't you access the DBI FAQ? www.xmlproj.com/cgi/fom.cgi
Ilya
-Origina
Why can't you access the DBI FAQ? www.xmlproj.com/cgi/fom.cgi
Ilya
-Original Message-
From: Tim Bunce
To: John-Thomas Beadles
Cc: [EMAIL PROTECTED]
Sent: 10/3/02 3:31 AM
Subject: Re: Performance problem with DBI, DBD-Oracle8
Make sure you're using the latest DBD::Oracle.
Se
Make sure you're using the latest DBD::Oracle.
Send a trace(8) log - just the part from prepare thru execute.
Tim.
On Wed, Oct 02, 2002 at 05:45:01PM -0500, John-Thomas Beadles wrote:
> Help! I'm having a severe performance problem with a Perl program talking
> to a remote Oracle database. I'v
Bingo, we have a winner! I've alternated including this statement, and it
definitely appears to be the key, at least for this test code. Now I have
to go modify my production code. I'll let you know if it works the same
way.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PRO
[mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 03, 2002 11:13 AM
To: Beadles, John-Thomas [RICH1:2795:EXCH]
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: RE: Performance problem with DBI, DBD-Oracle8
I'm sure you are aware of this, but the DBI/DBD::Oracle are very old on that
server.
O
Thursday, October 03, 2002 11:02 AM
> To: Beadles, John-Thomas [RICH1:2795:EXCH]
> Cc: [EMAIL PROTECTED]
> Subject: RE: Performance problem with DBI, DBD-Oracle8
>
>
>
> perl -MDBD::Oracle -e 'print $DBD::Oracle::VERSION, "\n"'
>
> On 03-Oct-2002 John
Thanks. v1.03 on the Unix side, v1.8 on the PC.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 03, 2002 11:02 AM
To: Beadles, John-Thomas [RICH1:2795:EXCH]
Cc: [EMAIL PROTECTED]
Subject: RE: Performance problem with DBI, DBD-Oracle8
perl
perl -MDBD::Oracle -e 'print $DBD::Oracle::VERSION, "\n"'
On 03-Oct-2002 John-Thomas Beadles wrote:
> Hm, I'll try that. However, the listener appears to be down now, so I can't
> try it just yet.
>
> Not sure about the DBD Oracle version, not sure how to find the physical
> module. Is ther
Hm, I'll try that. However, the listener appears to be down now, so I can't
try it just yet.
Not sure about the DBD Oracle version, not sure how to find the physical
module. Is there another way to tell?
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Ah yes,
Ah yes, there was a bug in DBD::Oracle. I forget which version numbers, you can add my
$foo =
$sth->{NAME} before the $sth->execute which will start the caching. Which version
of DBD::Oracle are you using?
.. Not that this affects performance, but you can set your sql by,
my
homas [RICH1:2795:EXCH]; [EMAIL PROTECTED]
Subject: RE: Performance problem with DBI, DBD-Oracle8
If you're still running HPUX 10.x, I'm guessing that it's also an older
machine? It's probably not a memory issue, since SQL*Plus won't store the
38K rows in memory. The
IL PROTECTED]]
Sent: Thursday, October 03, 2002 10:09 AM
To: Beadles, John-Thomas [RICH1:2795:EXCH]; [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: RE: Performance problem with DBI, DBD-Oracle8
Then I don't believe this is a dbi issue; most likely a difference in
configuration at the Ora
, WI USA
> -Original Message-
> From: John-Thomas Beadles [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, October 03, 2002 10:11 AM
> To: [EMAIL PROTECTED]
> Subject: FW: Performance problem with DBI, DBD-Oracle8
>
>
> Forgot to copy my response to the list...
>
&g
ess to the module
-Original Message-
From: Joe Raube [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 03, 2002 8:41 AM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: RE: Performance problem with DBI, DBD-Oracle8
Are the versions of perl, dbi, dbd, and the Oracle client the sa
te target DB). The same query ran in
> under 1 min
> on the PC.
>
> -Original Message-
> From: Joe Raube [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, October 03, 2002 8:44 AM
> To: [EMAIL PROTECTED]
> Cc: [EMAIL PROTECTED]
> Subject: RE: Performance problem with
: [EMAIL PROTECTED]
Subject: RE: Performance problem with DBI, DBD-Oracle8
Also, did you execute the query using SQL*Plus on each machine and note the
performance?
-Joe
--- Joe Raube <[EMAIL PROTECTED]> wrote:
> Are the versions of perl, dbi, dbd, and the Oracle client the same on
> b
Also, did you execute the query using SQL*Plus on each machine and
note the performance?
-Joe
--- Joe Raube <[EMAIL PROTECTED]> wrote:
> Are the versions of perl, dbi, dbd, and the Oracle client the same
> on
> both machines?
>
> What OS is running on each machine?
>
> -Joe
>
> --- [EMAIL PRO
Are the versions of perl, dbi, dbd, and the Oracle client the same on
both machines?
What OS is running on each machine?
-Joe
--- [EMAIL PROTECTED] wrote:
>
> If you are doing selects, you can set the $dbh->RowCacheSize,
> perldoc DBI will tell you what you need to know.
>
> On 02-Oct-2002 J
If you are doing selects, you can set the $dbh->RowCacheSize,
perldoc DBI will tell you what you need to know.
On 02-Oct-2002 John-Thomas Beadles wrote:
> Help! I'm having a severe performance problem with a Perl program talking
> to a remote Oracle database. I've read the DBI & DBM perldocs,
Help! I'm having a severe performance problem with a Perl program talking
to a remote Oracle database. I've read the DBI & DBM perldocs, the O'Reilly
book and can't access the DBI faq.
To characterize the problem, I've created a small, transportable program
that will run on my PC and on the UNI
Oops, yes, now everything works fine, thanks a lot! (embarassing ...)
Uli
[EMAIL PROTECTED] wrote:
>But don't you have an invalid count? 3 parameters in the SQL (3 question marks)
>and onlt 2 bound parameters (two calls to bind_param for params 1 and 2).
>
>Martin
>
>On 18-Sep-2002 Ulrike Schm
But don't you have an invalid count? 3 parameters in the SQL (3 question marks)
and onlt 2 bound parameters (two calls to bind_param for params 1 and 2).
Martin
On 18-Sep-2002 Ulrike Schmidt wrote:
> Hello,
>
> I have a similar problem to Brad some days ago, but the solution that
> worked fo
cc:
Subject: RE: Quirky problem with
DBI
18-0
Ulrike Schmidt wrote:
> The error message I get is:
>
> [Microsoft][ODBC Microsoft Access Driver]COUNT-Feld ungültig.
> (SQL-07001)(DBD: st_execute/SQLExecute err=-1) at
> PerlModule/Database.pm line 110.
This probalby translates to "invalid COUNT-field".
Uli
Hello,
I have a similar problem to Brad some days ago, but the solution that
worked for him leads to new error messages for me. I am trying to insert
values into an Access database, "conc_name" and "definition" are of type
"Memo". The error message I get is:
[Microsoft][ODBC Microsoft Acces
?.
> > > > I.e.
> > > >
> > > > $sth = $dbh->prepare("insert into foo (a, b) values (?, ?)");
> > > > while (get_my_data) {
> > > > $sth->bind_param(1, $a_value, SQL_LONGVARCHAR);
> > > > $sth->bind_param
at pattern and see if that works for you.
Jeff
> -Original Message-
> From: Brad Smith [mailto:[EMAIL PROTECTED]]
> Sent: Monday, September 09, 2002 8:14 PM
> To: Jeff Urlwin
> Subject: RE: Quirky problem with DBI
>
>
> Jeff:
>
> Still, no luck. I have alt
Yes, access is sometimes quirky about longs/memos. Try doing this (in
pseudo code) (warning, may wrap long lines):
#!perl -w
# above line makes sure perl is running with warnings.
use strict; # make sure we have strict on to check for dumb typos
use DBI qw(:sql_typ
Brad,
What version of DBD::ODBC are you using? If you are using DBD::ODBC 0.28
from ActiveState, then I suggest upgrading to the latest (which has a PPM
file at ftp://ftp.esoftmatic.com/pub/outgoing/DBI
Please upgrade your DBI too, as you must use the version I have uploaded
there.
Regards,
J
Scenario:
I am using the following code to update an Access database. The fields
case_notes1...case_notes4 are MEMO fields. Sometimes, I have no
problem whatsoever. Other times, I get the following error:
DBD::ODBC::st execute failed: [Microsoft][ODBC Microsoft Access
Driver]Invalid precis
[EMAIL PROTECTED] wrote:
> mysql returns all the rows by default, if large could eat up all the memory.
> Do a perldoc DBD::mysql and look for "use_result", I forget the syntax. This
> will return the rows...here I will paste the docs,
>
>
>Note, that most attributes are valid only aft
mysql returns all the rows by default, if large could eat up all the memory.
Do a perldoc DBD::mysql and look for "use_result", I forget the syntax. This
will return the rows...here I will paste the docs,
Note, that most attributes are valid only after a
successfull execute. An
On Mon, 17 Jun 2002 00:30:52 -0400 Roger Patrick <[EMAIL PROTECTED]> wrote:
> I have a novice cgi script that connects to a database and retrieves
> some data. When I run the script from the command line, I receive the
> correct results. However, from the web I receive the following error:
>
>
I have a novice cgi script that connects to a database and retrieves some data. When
I run the script from the command line, I receive the correct results. However, from
the web I receive the following error:
DBI->connect(ORACLE) failed: Error while trying to retrieve text for error ORA-12154
On Wed, Jun 05, 2002 at 10:07:55AM +, Ian Crowley wrote:
> Hi
>
> Trying to build DBI-1.24 but it dies and give the following error... using
> activestate latest build on win 2000. DBI-1.23 built fine last week. Any
> help would be great.
>
> cl -c -nologo -O1 -MD -DNDEBUG -DWIN32
Hi
Trying to build DBI-1.24 but it dies and give the following error... using
activestate latest build on win 2000. DBI-1.23 built fine last week. Any
help would be great.
cl -c -nologo -O1 -MD -DNDEBUG -DWIN32 -D_CONSOLE -DNO_STRICT
-DHAVE_DE
S_FCRYPT -DPERL_IMPLICIT_CONTEXT -DPERL_
> Hi,
>
> We installed the DBI modul and DBD::ORACLE modul on a sun server 2.6. They
> permit us to connect to our Oracle 7.3.4. database. Everything works fine
> like this. We again install these moduls on sun server 2.8 using the same
> version of perl (5.005_03) to connect to our Oracle 7.3.4
Hi,
I have installed DBI and the DBD for MySql. I can't remember it very well, but I
think I got some error messages when doing 'make test' during the installation
of DBD.
Now, I can use DBI and when asking it for the available drivers, the driver for
my sql appears in the list.
However, w
1 - 100 of 134 matches
Mail list logo
