Thannk you very much for your patience. But after hours I finally found
the answer myself. It's as stunningly silly as always: Never put an
"open" db handler on a cache - and never try to revive it later... -:D
Michael A Chase wrote:
>
> On Thu, 29 Aug 2002 15:31:03 +0200 THC Soft <[EMAIL PROTEC
I'm trying make DBD::Oracle on Macintosh OS X.
DBI-1.30 compiled and tested cleanly.
I'm attaching the entire output of:
perl Makefile.PL for DBD::Oracle 1.12
Other than minor errors like:
Multiple copies of Driver.xst found in: /Library/Perl/darwin/auto/DBI
/Library/Perl/darwin/auto/DBI at
On Thu, 29 Aug 2002 16:11:17 -0700 Jared Still <[EMAIL PROTECTED]> wrote:
>
> This is the essentials of what worked for me after
> studying subclass.t:
>
>
> package PDBA::CM;
> require DBI;
> @ISA=qw(DBI);
>
> __PACKAGE__->init_rootclass;
>
> use Carp;
>
This is the essentials of what worked for me after
studying subclass.t:
package PDBA::CM;
require DBI;
@ISA=qw(DBI);
__PACKAGE__->init_rootclass;
use Carp;
use strict;
use warnings;
use diagnostics;
sub new {
# bunch of code goes here
}
package PDBA:
Hello,
In an attempt to add some custom logging into DBI calls, I have over-ridden
the execute method of DBI with a custom execute method. The project I have
includes writing out the SQL statement that is at fault if execute blows
up. This needs to be transparent to the user, and must work with
I have a script that connects to a Sybase database, but I'm getting a
relocation error:
DBUTIL:
LD_LIB=/usr/sybase/OCS-12_5/lib:/usr/sybase/OCS-12_5/lib3p:/usr/sybase/O
CS-12_0/lib:
Can't load
'/usr/local/lib/perl5/site_perl/5.6.1/sun4-solaris/auto/DBD/Sybase/Sy
base.so' for module DBD::Sybase:
Hi,
I have a simple perl script as a test of getting data from a CLOB field.
My database is Oracle 8.1.7, and it has a charset UTF8. The client is also
on UTF8.
The trace shows that everything up to the 'fetch' step goes correctly.
But during OCILobRead only part of the data is received (161 bite
> "Joe" == Joe Slagel <[EMAIL PROTECTED]> writes:
Joe> We're seeing some very odd behavior with using alarm() around the
Joe> DBI->connect() call only on Solaris platforms. It appears that
Joe> even though we clear the alarm after a successful connection, for
Joe> some reason the alarm signa
Each entry in @tuple_status returns the
equivalent return-code (aka rowcount)
that would be returned by a single execute()
using that entry's associated parameter tuple,
ie,
if $sth->execute() with parameter tuple
1 would return a rowcount of 1, then
@tuplestatus[1] == 1;
if $sth->execute() wit
The problem is the way you pass in tuple status
array. It needs to be provided as an attribute
hash,e.g.,
$sth->execute_array({ ArrayTupleStatus => \@tuple_status });
Regards,
Dean Arnold
On Thu, 29 Aug 2002 12:07:14 -0500 J & C Parker <[EMAIL PROTECTED]> wrote:
I trying to figure out how to u
All,
Despite verbiage implying that the DBD::Proxy client inherits option
handling from its base classes, this doesn't seem to be the case. By
applying this patch, one can add arbitrary RPC attributes by prefixing
keywords with 'rpc_' and appending them to the usual DSN string, e.g.
export D
I trying to figure out how to use bind_param_array and execute_array.
The documentation is sketchy. I have tried putting each row in an array
and putting each column in an array. The basic idea is to generate 1
rows of data and insert them. the error message I am getting is "Can't
coerce array
Give great thanks to all of you.
The problem is solved by specifying the Oracle datatype CHAR (96) to tell
PERL not to strip the trailing spaces.
Thanks a lot.
Queyon
-Original Message-
From: Jan Matejka [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 29, 2002 12:14
To: 'Queyon Zeng'
S
On Thu, 29 Aug 2002 10:45:22 -0400 Queyon Zeng <[EMAIL PROTECTED]> wrote:
> Would you mind letting me know how to check the DBI and DBD::Oracle
> version?
http://xmlproj.dyndns.org/faqomatic/cache/34.html
> From: H.Merijn Brand [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, August 29, 2002 10:30
On Thu, 29 Aug 2002 15:31:03 +0200 THC Soft <[EMAIL PROTECTED]> wrote:
> The system I use is Linux 2.4.17, Perl 5.6.1, DBI 1.28.
>
> I'm working on a web application consisting mainly of a CMS. Now
> consider the following simple test script:
>
> use Content::Category;
> use DBD::mysql;
That s
This is perl, v5.8.0 built for aix
Copyright 1987-2002, Larry Wall
Perl may be copied only under the terms of either the Artistic License or
the
GNU General Public License, which may be found in the Perl 5 source kit.
Complete documentati
On 29 Aug, Queyon Zeng wrote:
> Would you mind letting me know how to check the DBI and DBD::Oracle version?
> Thanks.
perl -MDBI -le 'print $DBI::VERSION'
perl -MDBD::Oracle -le 'print $DBD::Oracle::VERSION'
Would you mind letting me know how to check the DBI and DBD::Oracle version?
Thanks.
Queyon
-Original Message-
From: H.Merijn Brand [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 29, 2002 10:30
To: Queyon Zeng
Cc: [EMAIL PROTECTED]
Subject: Re: Perl 5.8.0 Problem
On Thu 29 Aug 2002
On Thu 29 Aug 2002 15:49, Queyon Zeng <[EMAIL PROTECTED]> wrote:
> Dear sir,
>
> We downloaded PERL 5.8.0 and compiled in AIX 5.1.0.0
> It seemed to works fine, but we have a problem which I think might be
> related to PERL interpreter.
Are you sure? This is default Oracle behaviour, and does no
Hi all,
I'm new to this list, so my apoligies if the problem of which I'm going
to tell isn't that thrilling to you any more. :)
The system I use is Linux 2.4.17, Perl 5.6.1, DBI 1.28.
I'm working on a web application consisting mainly of a CMS. Now
consider the following simple test script:
u
Is there such a thing? I want to use perl/DBI from unix to pull data from
a pervasive server that is running on NT. The ODBC DBD driver looks like
the right thing but I believe I still need an ODBC driver that will
connect to pervasive sql.
thanks!
-=hugh
On Thu, 2002-08-29 at 05:53, Roger Perttu wrote:
> Michael Peppler wrote:
>
> >On Thu, 2002-08-29 at 02:31, Michael Dalziel wrote:
> >
> >
> >First of all you should print out any potential error messages, both for
> >the prepare() and the execute() calls.
> >
> >Second, I believe that to get
Michael Peppler wrote:
>On Thu, 2002-08-29 at 02:31, Michael Dalziel wrote:
>
>
>>All,
>>
>>Having difficulty with an error message "no statement executing" against the
>>following
>>
>>my $dbh = DBI->connect($DATA_SOURCE,$USER,$PASSWORD,{AutoCommit => 0,
>>RaiseError => 0, PrintError => 0 })
mrtlc wrote:
>I want to pull some data down from a Teradata database to a Win2k/NT server.
>I use DBI or Win32::ODBC, a system DSN (teradata1) is created.
>
>use DBI;
>use DBD::ODBC;
>my $dbh = DBI->connect("DBI:ODBC:teradata1", "uname", "moo");
>...
>
>or
>
>use Win32::ODBC;
>$data = new Win32::
On Thu, 2002-08-29 at 02:31, Michael Dalziel wrote:
>
> All,
>
> Having difficulty with an error message "no statement executing" against the
> following
>
> my $dbh = DBI->connect($DATA_SOURCE,$USER,$PASSWORD,{AutoCommit => 0,
> RaiseError => 0, PrintError => 0 }) or error("Can`t connect t
>
> Having difficulty with an error message "no statement executing"
> against the
> following
>
> my $dbh = DBI->connect($DATA_SOURCE,$USER,$PASSWORD,{AutoCommit => 0,
> RaiseError => 0, PrintError => 0 }) or error("Can`t connect to db:
> DBI::errstr", 1,2);
>
> # DBI->trace(2);
>
>
> my $sth =
Paul,
Make sure it's a system DSN. This is somewhat covered in the DBD::ODBC pod
docs and some related documentation regarding, web server environments in
the DBI FAQ too.
>
>
> I am having a problem moving a perl script I am using on the command line
> into apache due to an error connecting to
All,
Having difficulty with an error message "no statement executing" against the
following
my $dbh = DBI->connect($DATA_SOURCE,$USER,$PASSWORD,{AutoCommit => 0,
RaiseError => 0, PrintError => 0 }) or error("Can`t connect to db:
DBI::errstr", 1,2);
# DBI->trace(2);
my $sth = $dbh->prepa
I seem to have found my own answer
Thanks all the same
For those of you who might be interested, the problem was the way I had
defined my ODBC connection in Windows. I had configured a User connection
which works just peachy for command line perl. This is because command line
perl is executed a
I am having a problem moving a perl script I am using on the command line
into apache due to an error connecting to MS SQL.
My Environment:
Windows 2K professional
SQL Server 2000
Apache 2
Perl 5.6.1
DBD::ODBC v 0.28
Here is the problem:
When run on the command line I am able to connect to the
Dan Muey wrote:
>>I think you will need to show us more of your code. Where are the ids
>>coming from?
>>
>>
>
>First the html generated by the script :
>
>
>
>I get this html by doing :
>
> while(@row = $sth->fetchrow_array) {
>
>if($t
31 matches
Mail list logo
