Webmaster Forum / Perl / DBI Library / August 2007

Hey folks -
We have written an app that makes a connection to a MSSQL server using ODBC.  It works great as long as the length of our select statement is 668 characters or less.  As soon as it hits 669 characters, it hangs forever doing the execute.  It also fails if we use ...

just wondering how to achieve this. Want to query (PostgresSQL DB)
successively 3 different SQL.
1. delete from main_table
2. insert into main_table

I'm currently moving a perl script from an old Red Hat to a new Debian
machine. The script connects to Microsoft SQL Server using FreeTDS. It
runs fine on the new machine, but gives these warnings:
DBD::Sybase::st fetchrow_hashref warning: Number of row fields

I'm trying to log into a sql server 2005 express through perl using
DBI and DBD::Sybase module.
this is my freetds.conf file (located under /etc/freetds/freetds.conf)
[MyServer70]

DBD::Proxy version 0.2004
fetch() doesn't set proxy_rows.
disconnect() shouldn't attempt to dereference rdbh if it isn't defined.
Patches attached.

I am using ODBC to convert an old clipper application to a web based application and I came across something seems simple but it's not.
how can I save a date from perl to a date field in dbf file? can a perl expert helps out someone who is novice in perl like me? your help would ...

Building the DBD for Oracle on a Tru64 UNIX 4.0G server (alphaserver)
under perl 5.8.8, I'm stuck on getting the test process working
correctly.  Looks like the build and compile work just fine, but the
first test complains about a symbol not being found.  I'm not sure what

What are the plans on supporting DBI on older platforms? Since DBI 1.57
(also in 1.58 and 1.59), some tests fail on Win98 (ActivePerl 5.8.8
build 822, module compiled with MinGW 3.4.2 (+ nmake)), while all tests
pass on XP.

The Debian autobuilders for arm and m68k fail while trying test t/85gofer.t
with the following messages:
t/zvxgp_85gofer...........
#   Failed test 'pipeone: DBI connect('transport=null;policy=pedantic;dsn=dbi:Gofer:transport=pipeone;policy=pedantic;perl=/usr/bin/perl  ...

Does the latest version of DBI/DBD::Oracle support it? I didn't see a
support version table anywhere.
Robert

I have problem with compiling DBD::Informix.
Could anybody help me ?
Piotr Poloczek
----------------------------------------------------------------------

Good Morning,
I using DBI-1.34/DBD-Sybase-0.95 to access Sybase servers, using Sybase
client 11.5.1, regular CGI/command line scripts (No Mod Perl, etc.).
Running against ASE 12.5.0.1

I have an application currently written in sybperl.  I need now use an
Oracle database as well.  I tried to just hook in DBI interface with no
luck.  Is there a way to do this, or am I going to convert my sybperl to
DBI-DBD?

Hello!  I was wondering if it would be possible to pass a reference to
an array or hashes to execute_for_fetch() in DBD::Oracle.  Right now,
a ref to array of arrays is passed.  My thought is to enable named
placeholders.  Right now, numeric/sequential placeholders are used.

Current method.. pseudo code.
while (1)
{
$from_datetime = time;