Webmaster Forum / Perl / DBI Library / March 2010

Hola
What is the preferred way of allowing a driver to use either
DBI::PurePerl or DBI?
Module::Build does not support alternative requirements

I'm trying the following:
$sqcollision = "select reserved_id, reserver, purpose,  
to_char(starttime, 'HH:MI'), to_char(stoptime, 'HH:MI') from  
reservedroomtest where roomid in (?) and ((to_date(?, 'MM/DD/YYYY  

Who's ever the dbi-users group monitor, please shut this annoying person
off:
Kenneth Webber <mp34ken@hotmail.com>

Hey All,
I am facing this situation where I have coded a Perl framework on Windows
and its all working fine. The framework mostly uses DBI and ODBC module to
connect to both Oracle server, execute SQL queries, fetch Rows etc etc.

I am was having problem with compiling DBD::DB2 on strawberry
perl. After some fussing about I realized that the build statement was
not made correctly ( it was not linking the db2cli.lib and db2api.lib in
dmake). So I manually ran that command and got it to work. However now

Hi,
I'm trying to load IBM's DB2 Perl Database Interface for LUW on my brand new Dell desktop running Windows 7 Professional and ActiveState Perl but despite the easy instructions at http://www-01.ibm.com/support/docview.wss?rs=71&uid=swg21297335 every time I run the command "ppm ...

I am working on Perl 5.6.1 version for my web application. I want to
know whether perl5.6.1 supports the DBI module or not, if it supports
the what is the version of DBI module.
Please let me know the answers.

I am about to ask someone to install DBI and DBD-SQLite on a platform.
I noticed there are a number of related repos on CPAN:  DBD-SQLite,
DBD-SQLite2, DBD-SQLite-Amalgamation.
Is DBD-SQLite the right one to get?

I've been looking at how to do this for some time,
but I seem to don't get it.
If I have a $dbh handle, is it possible to know which
hostname is that $dbh connected to?

I'm using DBD::Oracle.
Is it possible to set the NLS_LANG setting on a dbh so that the
setting overrides what is specified by $ENV{NLS_LANG}?
Thanks,

I am attempting to select from a table that has a field with a
system defined type.  Unfortunately, I get back an error when I
execute the prepare method.
In reading the DBD::Oracle docs, it seems like it is saying that

I see a big difference in what $sth->{TYPE} returns (and the name) and
what column_info () - if implemented - is returning.
From the DBI docs:
  Handle attributes:

Two questions:
1. Is it possible to add/store "user defined" attributes in a database handle.
I'd like to do something like this:
my $dbh = DBI->connect(...);

The syntax is $csr->bind_param_inout(':var',\$perlvar,$maxlength)
My question is what is $maxlength in relation to the database.
If my statement is returning a number (a sequence value) how big do I  
need it to be?

All - I'm under Solaris using perl v. 5.8.3 and DBI v. 1.48.  I can catch signals w/o a problem before I connect to the database.
However after I connect, I can't catch signals anymore.  If I comment out the "DBI->connect" and press ctrl-c in a ReadLine(0), the signal is caught ...