Webmaster Forum / Perl / DBI Library / November 2007

Dave, DBI User Group,
Can you take a quick look at the code block below and error messages
being generated when executing.  
Any idea why the last 2 characters of the $sql variable are getting

I am building DBD::ODBC without unicode support.
In dbdimp.c, I have:
     case SQL_VARCHAR: return "VARCHAR";
     case SQL_WCHAR: return "UNICODE CHAR";

I tried to install DBD::Sybase 1.08 on HP-UX 11.23 (64bit) and it failed in the test phase.
Versions of HP-UX and Sybase:
--------------------------------------------------------------------------------------------------------
$uname -a

I have installed mysql on my powermac G5 (64 bits) and I installed perl
DBD-mysql-4.005 and DBI-1.601 that I obtained from CPAN. The
installation did not work and I kept getting error message. I saw
somewhere that the 64 bit version of mysql was creating problems so i

To help diagnose the test failures some people are experiencing with
DBI-1.601 I've modified the t/80proxy.t file to include more info.
It would be a big help if anyone who has experienced a failure
(especially the cpan-testers I've CC'd) could fetch a copy from

I'm trying to write MS SQL Server support for a generic perl module
used to execute arbitrary SQL statements and then return the array
reference for the result set (if one exists). My basic idea was to do
in following way:

   I need to install the DBD::Pg under Solaris 10 sparc, the DBI::DBD
installed without errors with CPAN, but when trying to install DBI I
get the following error:
"Can't create variants of tests in 't' directory: No such file or

I have an integer field that tracks entries.  The question I have is
can I set an option so that when auto_increment  reaches it's maximum
integer value, it will start all over at zero.  I'm deleting every 15
minute the earlier entries, so I'm not too worried about the table

I just posted this question on Perl Monks:
http://perlmonks.com/?node_id=649489
Am I correct in my analysis of what's going?
I would be happy if I could pass strings to DBD::Oracle without having

I'm trying to get the DBD::Oracle 1.19 Perl module working fine under SuSE
Linux Enterprise Server 10 (IBM Power 64bit).
The version of SLES is 10.0 (no SP1 applied yet) and the version of Perl I'm
using is:

I am almost finished a number of changes to DBD::ODBC which a) make it
work on win64 platforms and b) reduce the number of ODBC calls required
for select statements. I would like to tidy up some of DBD::ODBC which
may have fallen behind DBI::DBD changes/improvements but I am ...

I started trying to convert all the DBIc_ERR etc calls to
DBIh_SET_ERR_CHAR. I made a mistake and ended up debugging a test case
in DBD::ODBC which is supposed to fail but failed for the wrong reason.
The test is supposed to fail because multiple concurrent statements is

Thanks, we can try 64 bit.
Interesting that Oracle are still distributing 32 bit with Oracle 10.2,
though, if there is not a 32 bit solution to this problem?
Peter Sands

Running perl5.8.3 compiled 32 bit with the Perl libraries, DBD 1.15, DBI
1.41 distributed with Oracle 10.2, I find that, having connected to Oracle
within a perl script any subsequent system() calls return a -1 error status,
even simple commands like true.  (First tried building and ...

Fellow DBI Users,
I am planning to release a module, DBIx::JCL, "DataBase Interface
eXtension Job Control Library". This module will (hopefully) fill the
need for a module to provide job creation support for database tasks.