Webmaster Forum / Perl / DBI Library / February 2008

I'm new to the usage of the FreeTDS and DBD::Sybase combination.
I am seemingly able to connect to the DB correctly. It may perhaps
be as simple as my MSSQL syntax is failing? I have verified that
I am at all able to communicate correctly with the database by

          I am using Active Perl5.8.8 (build 820) and Oracle client( 9i).
          I have got DBI package already installed.If I want to install
DBD-Oracle,what is the process I need to follow.
        I tried using PPM>ppm install DBD-Oracle.Since I have firewall

I am getting the following error from make (excerpt only full list
follows)
Running Mkbootstrap for DBD::Oracle ()
       chmod 644 Oracle.bs

I am getting 3 duplicate (3*2=6 total) redefinition of target errors when I
try to make the latest DBD::ODBC 1.15 from CPAN. I am using the Borland C++
compiler on Windows XP Pro. The duplicate redefinitions occur after these
two lines in the Makefile on blank lines:

I'm using  DBD::ODBC Version 1.13 and had following problem:
Te connection timed out after exactly 30 seconds even when
"odbc_query_timeout" was not set.
According to the documentation there should be no timeout in this case.

Just wondered if anyone else had seen this and if there are any opinions
on getting around it. I use DBIx::Log4perl (which I wrote to help debug
our DBI appication) and DBD::Oracle. New code added to our application
calls an oracle package function which returns a reference ...

I have a small TCP daemon running (using Net::EasyTCP and Proc::Daemon). The
daemon does some very simple interactions with a local database.
I'm not aware of it doing anything complex or special. The same CDBI-based
classes are used under normal script and mod_perl2 conditions.

attempting a DB connection using a brand new installation of perl
5.8.8 on an old sun box: 'sun4u sparc SUNW,Ultra-4'.
i have connectivity.
this command line script returns a reference to a hash:

I don't really know if this is the right list I should write
to but in doubt...
I've got a webserver (apache) running a database search web
interface through fastcgi.

I'm having some issues with queries against a Sybase cluster, and am
told by my DBAs that I need to specify not only the table name, but the
owner using the folloiwing syntax:
  owner..table_name

I am building DBD::Sybase on perl 5.10, threaded, Solaris 8 (5.8). All
is well except that the xblk tests fail.
When I google
   DBD::Sybase xblk

This may be less a DBI question and more Oracle - probably both...
Using DBD::Oracle
Given this table:
TABLE batch_application_sla

I'm getting this error:
Unable to retrieve key from seclivesyb02 for 64152205: Implicit
conversion from datatype 'VARCHAR' to 'NUMERIC' is not allowed.  Use the
CONVERT function to run this query.

file: $CPAN/authors/id/T/TI/TIMB/DBI-1.602.tar.gz
 size: 497279 bytes
  md5: 6ca87d67decf274983e62261889edc85
=head2 Changes in DBI 1.602 (svn rev 10706)  8th February 2008

I am generating a report in Perl and data's are from oracle. Connecting
via DBI module.
I run the following query directly in SQLPLUS and got 25 result.
   SELECT item.*   FROM tmp_loadplan_items item,tmp_loadplans loadplan