Webmaster Forum / Perl / DBI Library / October 2008

Is there a way in DBI to get a $sth->rows count, when selecting to a
temporary table?
In this code I get a proper count from the SELECT, but the SELECT INTO
TEMPORARY TABLE returns -1.

I don't understand what the error I get has to do with the executed code.
Can someone enlighten me?
--8<---
use strict;

I've been using DBI for a while.
Now I need to provide security for the password and maybe data to.
Does DBI support any kind of encryption, security layer, whatever ?
thanks

I have two hosts here. They are both using FreeTDS to talk to a SQL
Server. One is running DBD::Sybase v 0.95, and it works fine. The other
is running v 1.08, and it gets the following error whenever I try to run
any SQL command:

Has anyone successfully built a 64 bit perl on OSX? I've tried and I get
just over 1000 errors on make test -
all relate to loading XS stuff and getting a wrong architecture error.
All I did (to be fair) was ./Configure -Dcc='cc -m64' -des

the Makefile.PL script seems to run fine (no errors) when I do the make
command it errors out
[/home/oracle/DBI/DBI-1.607] $ make
Skip blib/arch/auto/DBI/Driver_xst.h (unchanged)

What's the right DBI version to use with perl 5.6.1? Is there any matrix
what is compatible with what?
I downloaded DBI 1.607 but it complains about the perl version - needs
perl v5.8.1.

Hey all,
I'm really at the end of my rope with this one problem I'm having. I
need some clues. I've looked everywhere where I know to look but I
need some suggestions on where else to look.

I am hoping someone might have had to do something like this and have a
good solution. I am using DBD::Oracle. I have a table with a simple
integer and a timestamp:
create mytable (id int, created timestamp);

 I've spent 2 days trying to isntall DBD. I think there must be some servers down because it's not easy to install.
Here's part of the code that fails:
 DBI->connect("DBI:mysql:buildstatus:$dbserver", $user, $password) ;
It says cannot locate DBD/mysql.pm.

I have a quick question . I have an Oracle 10g running on a Sun 9.5 .
I Want to access the Database from perl . I am aware that I need DBI
and DBD module to interface it . However do I also need to install and
configure the Oracle client 'OLITE_10.3.0.2.0_SOLARIS' (Oracle

I am doing a simple TO-DO list manager using Coldfusion 8 and the language and MSSQL as the database.? My Required Functionality is:
??? Add TODO
??? Remove TODO
??? Modify TODO

All,
Oracle has a very nice perl module associated with it - DDL::Oracle -
it allows for dumping of procedures, indexes, tables, stored
procedures, and so on, in a way that can be highly configured (ie:

   I am working with Red Hat Enterprise Linux ES release 4 (Nahant
Update 3) Linux and
psql (PostgreSQL) 7.4.8 version and perl v5.8.5 version.
I have created my own database and tables in postgresql and my table

OK - a customer (large enough to be a household name in the USA) is using
Perl + DBI + DBD::Informix, and is wanting to build Perl with both DBI and
DBD::Informix statically linked.
I'm strongly discouraging this, but they have literally over ten thousand