Webmaster Forum / Perl / DBI Library / March 2008

We have been struggling a lot about TDS & ODBC performance over high-latency
connections.
We're using MS SQL 2000 and unixODBC on Gentoo Linux to connect to it.
Our problem is that we have a single database that is being accessed by

I'm trying to setup my Perl and DBI/DBD:Sybase development  
environment for the first time on Mac OS X (Tiger v10.4).
I get errors running MAKE after the make Makefile.PL in DBD-Sybase-1.08
I installed XCode to get the C compilers, Make, etc.

I live (mostly) on windows with OCS 15, it is
installed into c:\sql.
I also have OCS 12.5 in c:\sql_12-5
Installed sybperl 2.18 into ActivePerl 5.8.8

I was attempting to tidy up some code in DBD::ODBC and noticed quite a
number of tests using DBIc_ACTIVE which attempt to signal an error when
the database is not active (not connected). Having never seen these
errors I wrote a quick test script and got no errors when calling

New to Perl and new to DBI, though not new to scripting and databases in
general.
My script hangs when I try to add a WHERE clause to the SQL. This code works
fine :

I'm having a problem with one of my modules (SQL::DB) failing on
calls to prepare_cached. I'm asking here for help because this is
failing on every CPAN Tester's build, but I can't repeat the issue
locally (x86_64 Debian). The tests use SQLite for the database.

-----BEGIN PGP SIGNED MESSAGE-----
Hash: RIPEMD160
I noticed a failing test when using DBI 1.603 on DBD::Pg and
tracked the error back to this new line inside of pure-perl

I am running DBI and Oracle DB; I am executing a
package and using
 $dbh->func('dbms_output_get')
as in

Hi,
I'm new to this list.  I looked over the various Perl mailing lists and
decided on this one although my problem isn't directly related to DBI.
But the reason I'm trying to compile Perl from source as 64 bit is to

I have been playing about with scrollable result sets (Cursors)
in Oracle/OCI and have noticed that there has been some discussion about
it before on the list
You can find the discussion here

           I am writing a perl script to execute several stored proc on
SQL Server 2005 and the stored proc uses the log function. When the
argument to the log function is -1, it is outside the domain for the
Log function and the SQL Server rightly generates an error message to

Hi, I have successfully installed the Oracle instant client,
DBI-1.602 and DBD-Oracle 1.20 and can connect to a database on a
remote host, but only if I set LD_LIBRARY_PATH to the directory where
the instant client is installed.  This is fine, but I need to do this

           I am trying to connect to SQL Server 2005 on a windows 64bit
machine from the same machine. And I get this error message:
DBI connect(xxxsql01,'sa',...) failed: [Microsoft][ODBC Driver Manager]
Data source name not found and no default driver specified (SQL-IM002)

Lo,
This is more for the archives than anything as there is a workaround.
When inserting 1234567890.123456 into a decimal(16,6) column, the value
stored is 1234567890.123460

I have a system here with the following versions installed:
 Perl            : 5.008008    (x86_64-linux-thread-multi)
 OS              : linux       (2.6.9-42.0.3.elsmp)
 DBI             : 1.602