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
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 =
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 MS
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 =
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 to db:
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 OUTPUT
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:
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: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 should be
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'
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
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 use
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::ODBC(DSN =
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() with
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 signal is still
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
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:
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
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
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;
use strict;
20 matches
Mail list logo