Re: ActivePerl 5.8.4 w/ DBD::Sybase hangs on connect

2004-07-05 Thread Tim Bunce
On Sat, Jul 03, 2004 at 04:33:21PM -0700, Henri Asseily wrote: I've been running DBD::Sybase with the following patch since version 1.01, which could remotely have an impact for you. This is the 1.02 patch, but should work fine in 1.04. FYI in DBD::Sybase version 1.04, the modified line is

ANNOUNCE: DBI 1.43

2004-07-05 Thread Tim Bunce
file: $CPAN/authors/id/T/TI/TIMB/DBI-1.43.tar.gz size: 359797 bytes md5: ceaa35210d70e9762a3de5426d4d9235 Just uploaded. May take a day or three to reach your favorite mirror. =head1 CHANGES in DBI 1.43 (svn rev 377),2nd July 2004 Fixed connect() and connect_cached()

binding select

2004-07-05 Thread msg_du
Hi all, I have a store procedure and there are more than one select statements in it.How can I pick one select statement's output data into perl code? Perl+DBI+ORACLE Thanks! dch 21:23 2004-7-5

some fixes for DBIx-Recordset-0.25a

2004-07-05 Thread Silvio Wanka
Hi, to use DBIx-Recordset 0.25a with DBD-Oracle 1.15 I must done some fixes (patch attached): 1. see http://www.mail-archive.com/[EMAIL PROTECTED]/msg21302.html 2. to make test.pl compatible with perl = 5.6 (two necessary changes was done from 0.24 to 0.25a, but not all) 3. for one changed test

some fixes for DBIx-Recordset-0.25a (now with the right attachement)

2004-07-05 Thread Silvio Wanka
Hi, to use DBIx-Recordset 0.25a with DBD-Oracle 1.15 I must done some fixes (patch attached): 1. see http://www.mail-archive.com/[EMAIL PROTECTED]/msg21302.html 2. to make test.pl compatible with perl = 5.6 (two necessary changes was done from 0.24 to 0.25a, but not all) 3. for one changed test

Re: Possible DBI logos

2004-07-05 Thread Tim Bunce
On Wed, Jun 02, 2004 at 05:28:21PM -0700, Jeff Zucker wrote: In honor of Tim Bunce's 40th birthday, here are some samples of possible DBI logos: http://www.vpservices.com/jeff/programs/dbi-logo/ Thanks Jeff. I'm think after something more plain and graphic. The core concept needs to

select binding

2004-07-05 Thread msg_du
Hi all, I have a store procedure and there are more than one select statements in it.How can I pick one select statement's output data into perl code? Perl+DBI+ORACLE Thanks! dch 21:23 2004-7-5

Re: DBI::ProxyServer in multi-threaded mode

2004-07-05 Thread John Escott
OK, Tim's prompting (off list) has spurred me into action. I'm posting back to the list, just in case anyone else is interested. There's some good news and some bad news First the good news: setting mode to threads in the config file and restarting dbiproxy certainly allows multiple

RE: Best Way to Auto Increment with Oracle

2004-07-05 Thread Jared Still
On Wed, 2004-06-16 at 08:43, Kipp, James wrote: Your program connects via SQL*net to the DB. At insert time, you need to fetch a sequence, so you issue 'select seq.nextval from dual'. Seems harmless enough until ... 1. The select statement must be passed across the SQL*Net

DBD::Sybase and Text problems

2004-07-05 Thread dan_horne
My problem arose because I was trying to prepare a SQL INSERT statement with placeholders, where one of the columns is a TEXT datatype (using DBD::Sybase). As the error message pointed out, This is illegal in a dynamic PREPARE statement. So I'd like to know what the alternatives are. As far as

Is there a DBD-Sybase.ppd?

2004-07-05 Thread dan_horne
Hi Does anyone know where I could find DBD::Sybase for Perl 5.8 and Windows? Cheers Dan *** This eMail may contain privileged and confidential information intended only for the use of the intended recipient. If you are

Re: DBD::Sybase and Text problems

2004-07-05 Thread Michael Peppler
On Tue, 2004-07-06 at 04:39, [EMAIL PROTECTED] wrote: My problem arose because I was trying to prepare a SQL INSERT statement with placeholders, where one of the columns is a TEXT datatype (using DBD::Sybase). As the error message pointed out, This is illegal in a dynamic PREPARE statement.