Webmaster Forum / Perl / DBI Library / May 2007

2007-05-31  0.27 - H.Merijn Brand   <h.m.brand@xs4all.nl>
       * checked with perlcritic (still works under 5.00504)
         so 3-arg open cannot be used (except in the docs)
       * 3-arg open in docs too

I am trying to install the DBD::DB2 module on my Linux machine. I have
installed Perl 5.8.5, IBM DB2 v8.1 , DBI v1.56 .
But when i tried to test before install the perl module DBD::DB2 , i got the
below error. I would like to know how to resolve this issue.

I have simple script , trying to get connection to DB.
#!/usr/bin/perl
use DBI;
my $database="billing";

(DBD::Oracle version 1.17)
Given the following:
my $sLobLocator;
my $hSQL = $hDB->prepare(q{

I have been digging a bit to find what people consider loose ends in
Text::CSV_XS, and tried to summarize that (in no particular order) in
the new TODO list. Here "TODO" gives no guarantee that it will be done,
nor on any implementation or API that it might suggest, it is there now

I am writing an application that is using DBI to access a MS SQL database
hosted on a remote server.  I think I am having trouble with larger result
sets.
For example:

I like the functionality of find_or_create() however, i think it could
be better if it allowed you specify the search criteria and the actual
record data as seperate parameters like:
 ## find_or_create(\%search_criteria [,\%new_record]);

   Can you please  clarify my doubts regarding DBI perl module used for database connection.
In my environment I am using single module to prepare and execute the sql queries. The sql query can have bind variables or they may not have. In order to improve performance i used ...

Does connect_cached() reset attributes each time it's called?  Even if
just returning an active $dbh?
On a CDBI application I need to access multiple databases with the
same schema.  So my initial attempt was:

Recently I have bumped into a memory leak happening in DBI.
Running DBI version 1.55, DBD::ODBC version 1.13 on Windows XP SP2,
Active State Active Perl 5.8 build 819. More comprehensive build info
at the bottom of this email.

I am trying to write a script that connects to a remote MS SQL database.
I have set up dsn on my server before and have no problem connecting. But
something is working this time.
I am pasting my script and the error messages below.  If nay one has any

Quick question - how do I ensure from C something that I eval on the
perl side, if it fails sets $@? Say for instance, I have something that
checks something in C, I return in a way that eval/$@ is set.
Thanks in advance!

I´ve just installed DBD::DB2 to access a DB2 database, but I always get the
following message when I run a SELECT query:
DBD::DB2::db prepare failed: Error calling SQLGetInfo at ...
Although this message, I receive the result of the query.

I am using DBI 1.51 and DBD::ODBC 1.13, connecting to MSSQL2005.
Executing following statements:
$sth = $dbh->prepare('create table #foo  (a int not null)');
$sth->execute();