Multiple Results in DBD::ODBC 0.31

2002-01-28 Thread Abi Pothen
Hi, I am having a problem with DBD::ODBC (version 0.31) that has fixes to handle multiple result set. This fix is working fine only when the number of columns of the previous result set is equal to or greater than the number of columns of the following result set. If the number of columns of

Re: DBD naming question?

2002-01-28 Thread Schuyler Erle
Tim Bunce wrote: > > On Wed, Jan 23, 2002 at 04:34:03PM -0800, Schuyler Erle wrote: > > Hello. I've written a DBD module to wrap other DBD handles and provide > > intelligent drop-in support for asymmetrically replicated databases > > (e.g., MySQL v3)... [snip] Suggestions? > > Is it not possibl

Re: Argh! Archives!!

2002-01-28 Thread Terrence Brannon
On Monday, January 28, 2002, at 05:41 AM, Tim Bunce wrote: > I'll probably 'take ownership' of them but would be interested in > working with someone to do day-to-day (actually week-to-week) > maintenance. > > Hopefully that person would also be interested in looking after the > FAQ-o-matic syst

Re: Error -904 when selecting without result

2002-01-28 Thread Michael Peppler
H.Merijn Brand writes: > On Mon 28 Jan 2002 17:27, Michael Peppler <[EMAIL PROTECTED]> wrote: > > A couple of things: > > > > First, although Sybase does ship the libraries in 64 bit mode there > > should normally also be a 32 bit version on the CD. > > > > Second - DBD::Sybase 0.94 won't

Re: Error -904 when selecting without result

2002-01-28 Thread H.Merijn Brand
On Mon 28 Jan 2002 17:27, Michael Peppler <[EMAIL PROTECTED]> wrote: > Tim Bunce writes: > > On Fri, Jan 25, 2002 at 10:20:38AM +0100, H.Merijn Brand wrote: > > > > > > Now what would be a solution for a problem stated either here or on another > > > group related to new perl builds and the u

Re: Error -904 when selecting without result

2002-01-28 Thread Michael Peppler
Tim Bunce writes: > On Fri, Jan 25, 2002 at 10:20:38AM +0100, H.Merijn Brand wrote: > > > > Now what would be a solution for a problem stated either here or on another > > group related to new perl builds and the use of DBI/DBD. Sybase (I think) only > > ships their new products with 64bit l

Re: SQL GetInfo (Was Re: SQL Implementation Specifics)

2002-01-28 Thread Steffen Goeldner
Jeff Zucker wrote: > > Tim Bunce wrote: > > > > I'd strongly suggest that the configuration be implemented in a way > > compatible with ODBC GetInfo, as far as possible. Which basically > > means use something like a hash where the key is an integer and the > > value is the corresponding value of

RE: Adding data-sources implementation to DBD-Ingres

2002-01-28 Thread Mark Buckle
Hi Henrik, I suppose I there had to be a GOOD reason for the non-implementation. Looks as though there is! :-) For my purposes (in which searching iidbdb is adequate), I might patch the source locally, and rebuild it. I only really need to run against OI 1.2 and Ingres II. Thanks, Mark. PS, I d

Re: SQL GetInfo (Was Re: SQL Implementation Specifics)

2002-01-28 Thread Tim Bunce
On Sun, Jan 27, 2002 at 01:55:45PM -0800, Jeff Zucker wrote: > > http://www.vpservices.com/jeff/programs/SQL/docs/odbc-getinfo-msdn.html >http://www.mipt.sw.ru/en/products/ots/ Thanks Jeff. > > Also let it be specified by passing a code ref, in which case the > > code ref is called with

Re: Argh! Archives!!

2002-01-28 Thread Tim Bunce
On Sat, Jan 26, 2002 at 05:23:19PM -0800, Tim Harsch wrote: > Could somebody please fix the pointers to the archives on the > symbolstone home page? The US list has not worked in I don't know how > long and the European one has moved and all you get is the new server's > home page. Thanks Al te

Re: DBD::Oracle: get_info(), SQL_DBMS_VERSION

2002-01-28 Thread Steffen Goeldner
Tim Bunce wrote: > > > SELECT version > >FROM product_component_version > > WHERE product LIKE 'Oracle%' > > should be a quite portable way. > > I'd be a little nervous of that returning more than one row. > But lets wait and see if anyone complains :) How about a test: #!perl -w sub o

Re: DBD::Oracle: get_info(), SQL_DBMS_VERSION

2002-01-28 Thread Steffen Goeldner
Tim Bunce wrote: > > > *** DBD-Oracle-1.12.orig/Oracle.pmFri Aug 31 18:27:18 2001 > > --- Oracle.pm Fri Jan 25 11:37:32 2002 > > *** > > *** 580,585 > > --- 580,601 > > return 1; > > } > > > > + sub _server_version { > > Might as well call it ora_server_

RE: Adding data-sources implementation to DBD-Ingres

2002-01-28 Thread Henrik Tougaard
> From: Mark Buckle [mailto:[EMAIL PROTECTED]] > > data-sources is not implemented for ingres, but the local > database names can be queried from iidbdb. Yes but that is only local database names, you would have to query all iidbdb's that can be accessed by Ingres/Net, and I gave up on that.

Adding data-sources implementation to DBD-Ingres

2002-01-28 Thread Mark Buckle
data-sources is not implemented for ingres, but the local database names can be queried from iidbdb. I suppose my question breaks down into into these sub-queries :- Are there are technical reasons not to issue a database query (against iidbdb) to retrieve this information ? Does the DBI spec