Calling DB2 Stored Procedures through DBD::ODBC

2004-08-06 Thread samarth_kumar
Folks, I am not sure if this has been answered before or not but on searching the list archives I haven't been able to get an answer. I am connecting to DB2 using DBD::ODBC and am also able to run select statements. Now I have to run a stored procedure through the connection and was wondering i

Re: DBD::mysql and mysql_use_result

2004-08-06 Thread Alan Burlison
Alexey Stroganov wrote: It was already implemented in my tree with the same behaviour as for 'mysql_server_prepare' attribute: - attribute 'mysql_use_result' on dbh level, this allows to enable/disable mode for all new statements: - DBI->connect("DBI:mysql:test;mysql_use_result=1", "root

Re: DBD::Sybase and insert on TEXT column...

2004-08-06 Thread amonotod
amonotod <[EMAIL PROTECTED]> wrote > Okay, according to the Cheetah, DBD::Sybase does not support using placeholders on > TEXT columns. Here's why you should search the archive *before* you post: http://www.mail-archive.com/[EMAIL PROTECTED]/msg21494.html ;-), sorry, amonotod -- `\|||/

DBD::Sybase and insert on TEXT column...

2004-08-06 Thread amonotod
Okay, according to the Cheetah, DBD::Sybase does not support using placeholders on TEXT columns. If I'm doing a mass insert to a table with a TEXT column, shall I call a placeholder query to insert the non-TEXT columns, and then call a simple update statement to update the row with the TEXT dat

Re: Multiple copies of Driver.xst

2004-08-06 Thread Tim Bunce
On Fri, Aug 06, 2004 at 02:03:22PM +0200, Christian Stalp wrote: > I'm still hanging at my Adabas-Driver problem. Because nobody can help so > far, I try it step by step. > > First I wonder about the message: > > Multiple copies of Driver.xst found in: > /usr/local/lib/perl5/5.8.3/PA-RISC2.0/au

Re: DBD::mysql and mysql_use_result

2004-08-06 Thread Tim Bunce
On Fri, Aug 06, 2004 at 01:38:48PM +0100, Alan Burlison wrote: > I want to use the DBD::mysql 'mysql_use_result' attribute to make the > driver use mysql_use_result instead of mysql_store_result, and I want to > do it for all the queries I'm submitting against the database. Having > to set it o

Re: DBD::mysql and mysql_use_result

2004-08-06 Thread Rudy Lippan
On Fri, 6 Aug 2004, Alan Burlison wrote: > I'm not sure of the best way to go about this, there are two options: > > 1. Store the value in the DBH and copy into the STH when the STH is > created, unless the STD constructor is given an explicit value. > > 2. Store the value in the DBH and each t

DBD::mysql and mysql_use_result

2004-08-06 Thread Alan Burlison
I want to use the DBD::mysql 'mysql_use_result' attribute to make the driver use mysql_use_result instead of mysql_store_result, and I want to do it for all the queries I'm submitting against the database. Having to set it on each and every statement handle that I generate is a real pain, I'd

Multiple copies of Driver.xst

2004-08-06 Thread Christian Stalp
I'm still hanging at my Adabas-Driver problem. Because nobody can help so far, I try it step by step. First I wonder about the message: Multiple copies of Driver.xst found in: /usr/local/lib/perl5/5.8.3/PA-RISC2.0/auto/DBI /usr/local/lib/perl5/site_perl/5.8.3/PA-RISC2.0/auto/DBI at Makefile.PL

Re: fetchall_arrayref and Can't set DBI::st=HASH(0x850eeb0)->{NAME}: unrecognised attribute or invalid value

2004-08-06 Thread Tim Bunce
On Thu, Aug 05, 2004 at 10:50:07PM -0400, Rudy Lippan wrote: > On Thu, 5 Aug 2004, Tim Bunce wrote: > > > I don't see any metion of it in the docs. but I recall that DBD::mysql > > only makes statement handle attributes like NAME available while > > the statement handle is still Active. > > Shoul

Re: DBD::Proxy

2004-08-06 Thread John Escott
On Wed, Aug 04, 2004 at 08:02:28AM -0700, Tim Howell asked for information about how people are using DBD:Proxy. I'm using it in clients on HPUX and Linux to access, via ODBC, a Centura SQLBase database running under Win2000. Current use has -mode=single in the Win2000 ProxyServer. I ran a tes