On 24/06/06, Jonathan Leffler <[EMAIL PROTECTED]> wrote:
On 6/23/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]>
wrote:
>
If you have a pre-compiled module, then I think your problem is the absence
of DB2 Connect (IIRC) or its equivalent.
The basic connectivity requirement for DBD::DB2 on all
WAG here: will the DBD::DB2 driver implicitly finish the resources if
you try calling $sth->fetchrow_array() again?
I don't know if DBD::DB2 can know whether there are more rows left in
the result set until you try fetching the next row, ergo it keeps the
statement handle active.
Dan
On 09/06/0
Hi Martin:
You'll need the Application Development Client, which is a free
download from http://ibm.com/db2/udb/support/downloadv8.html.
The clients are installed as RPMs on Linux using the db2setup program
(part of the client); you might want to check out the DB2 HOWTO
(http://tldp.org/HOWTO/DB
This is a nice thought, but the latest release of DBD::DB2 is actually
0.78 (released a long time ago), but ActiveState wasn't interested in
updating their version of the package because DBD::DB2 prereqs the DB2
Runtime Client.
Apparently ActiveState has made it a policy to avoid offering packages
Hi:
Since you're running on a 64-bit platform, is there any chance that
you are trying to link 32-bit Perl libraries against 64-bit DB2
libraries?
"file /home/db2inst1/sqllib/lib/libdb2.so.1" will tell you the DB2
library bitness.
Dan
On 2/7/06, Jason S. Friedman <[EMAIL PROTECTED]> wrote:
> Hi
Seems to be working now for me: http://ftp.esoftmatic.com/outgoing/DBI/
Dan
On 31-Jan-2006 10:09:34 CET, [EMAIL PROTECTED]
<[EMAIL PROTECTED]> wrote:
> Hello,
>
> I need DBI and DBD-DB2 packages for Activeperl, but esoftmatic server is
> unreachable.
>
> Can anybody help me with this problem or s
B2 home directory on
> windows box or?
>
> Thanks in advance
>
>
> On 1/5/06, Dan Scott <[EMAIL PROTECTED]> wrote:
> > Hi Vincent:
> >
> > You just need to install the DB2 development headers and libraries
> > (available with the free to download and u
Hi Vincent:
You just need to install the DB2 development headers and libraries
(available with the free to download and use DB2 Application
Development Client) on your Linux box and set DB2_HOME before
compiling DBD::DB2; that will enable you to connect from your Linux
box to a DB2 server running
On 11/16/05, Rob Craig <[EMAIL PROTECTED]> wrote:
> I am using DBD::mysql and I can get the number of rows by assigning the
> result of the execute to a scalar:
>
> my $rows = $sth->execute or die "Couldn't execute statement: " .
> DBI->errstr;
>
> maybe this doesn't work with DBD::Oracle?
>
>
Strange -- just tried the exact same commands here and they worked as
expected. Maybe there was a temporary FTP server glitch.
Are you able to see the ftp.esoftmatic.com site?
Dan
On 11/3/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> Hello.
>
> I just installed perl 5.8.7 from active state.
Hi Darren:
I think an update about the recommended minimum database version
levels for your access modules is on-topic for this mailing list, but
suspect that product advertisements are probably off-topic -- personal
opinion, maybe, but I don't want to see this list become a dumping
ground for the
DBD::DB2 (http://search.cpan.org/dist/DBD-DB2/DB2.pod) supports
bind_param_inout,
but it would require you to use the DB2 Connect Personal Edition or DB2 Connect
Unlimited for iSeries to access iSeries from your Linux, UNIX, or Windows box.
Dan
On 10/12/05, Stephen More <[EMAIL PROTECTED]> wrote:
If you're willing to upgrade to Perl 5.8.x, then you can use the
latest available version of DBD-DB2 from
http://ftp.esoftmatic.com/DBI/ (it's okay to install the 5.8.4 version
of DBD-DB2 on Perl 5.8.7).
Dan
On 10/7/05, Trent Ohannessian <[EMAIL PROTECTED]> wrote:
> Hello,
>
> I currently have Pe
[EMAIL PROTECTED] wrote:
> Hello,
>
> I'm now using Perl 5.005, DBI-1.15, DBD-DB2-0.75 on AIX 4.3.
> And like to upgrade them to Perl 5.8, DBI-1.48, DBD-DB2-0.78.
>
> Installation may be ok, but when I INSERT double bytes characters,
> I get the following error.
> [IBM][CLI Driver] CLI0109E Strin
s running! Not pretty but it works. Thanks so much. -Alec
Dan Scott wrote:
Alec Brecher wrote:
My DBD-DB2 installation on Fedora Core 3 is failing because it cannot
find libdb2.so.1.
The Application Dev client is installed and works fine. The
DB2_HOME=/home/db2inst1/sqllib
I saw so
Alec Brecher wrote:
My DBD-DB2 installation on Fedora Core 3 is failing because it cannot
find libdb2.so.1.
The Application Dev client is installed and works fine. The
DB2_HOME=/home/db2inst1/sqllib
I saw some post from Owen Berry on another list regarding this issue.
His fix: add -Wl,-rpa
Tim Bunce wrote:
On Fri, Sep 02, 2005 at 05:37:57PM -0500, johnn wrote:
Capacio, Paula J wrote:
my $stmt = 'select count(*) from sysibm.badTblnm ';
my $sth = $dbh->prepare($stmt) or die "Prepare Failed\n";
DBD::DB2 doesn't seem to return false values for failures.
If that's true the
On 7/19/05, Keith Jackson <[EMAIL PROTECTED]> wrote:
> I have a project that I need to connect to a DB2 database on an AS400
> from a perl application on a Linux box. I've been reading as much as I
> can but have a few questions for those with experience in a similar
> task.
>
> My options appear
Chris:
This sounds very much like the problem noted under "Hints" at
http://www-306.ibm.com/software/data/db2/perl/:
Having trouble running perl with DB2 UDB Version 8 64-bit for AIX
5.2? Check out this technote.
(http://www-1.ibm.com/support/docview.wss?rs=71&context=SSEPGG&uid=swg21181032&loc=
For the DSN-less connections, see http://www.connectionstrings.com --
great resource.
Dan
On 6/2/05, Martin J. Evans <[EMAIL PROTECTED]> wrote:
> Sharon,
>
> The string after "ODBC:" is usually a DSN name as in:
>
> DBI->connect("dbi:ODBC:mydsn",...)
>
> or
>
> DBI->connect("dbi:ODBC:DSN=myds
This is not the mailing list you're looking for. This mailing list is
specifically about using the Perl DBI with the associated database
drivers (for example, the DBD::DB2 driver, as documented at
http://ibm.com/db2/perl/).
If you want help calling Java applications from a shell script, you
would
There is an archive of older ActiveState Perl releases at
http://downloads.activestate.com/ActivePerl that includes 5.8.4.
Dan
On Mon, 14 Mar 2005 09:01:24 -0500, Marina Greenstein
<[EMAIL PROTECTED]> wrote:
>
>
> Jeff,
>
> Any chance you will update repository with 5.8.6 binaries ? Or please
On Thu, 02 Dec 2004 08:53:38 +0100, Cosimo Streppone
<[EMAIL PROTECTED]> wrote:
> Tim Bunce wrote:
>
> > I know what it does, I'm trying to find real examples that demonstrate
> > why people think it's needed. Nick has provided a good one. Any others?
>
> Something like DBIx::DBH is in use in our
On Mon, 8 Nov 2004 15:17:34 +0100, Miroslav LauÅ <[EMAIL PROTECTED]> wrote:
> Hi all!
>
> I'm using DBD::DB2 to access remote DB2 database on an AS400 machine. I've
> managed it to work from command line.
>
> But when trying to connect to remote database from a mod_perl application the
> $DBI::er
Ben:
DB2 automatically takes the user ID you logged in with and uses that
as your default schema.
You can issue the "SET SCHEMA" statement to change your default schema
if you want it to be different from your DSN user ID. For example "SET
SCHEMA rick" would automatically prepend 'rick.' to all o
ricardo Guerra Flores wrote:
Hi all...
i'm having some problems trying to run a script that uses DBD::DB2 inside
mod_perl and the Apache::DBI module, the program runs right when i execute
it as a stand alone perl program. I've already set the ENV for db2home,
db2instance, etc. in startup.pl
This
26 matches
Mail list logo
