[prev in list] [next in list] [prev in thread] [next in thread] 

List:       dbi-dev
Subject:    Re: Array Binding (an ODBC example)
From:       Tim Bunce <Tim.Bunce () pobox ! com>
Date:       2001-08-10 14:37:08
[Download RAW message or body]

On Fri, Aug 10, 2001 at 09:44:48AM -0400, Jeff Urlwin wrote:
> I don't mind keeping the iODBC in there.  I remember trying to build
> UnixODBC, at one point, and it was slow and painful.  iODBC was light and
> fast to build.  I think kick starting users, given the number of people who
> actually read the docs that come with everything, is better than pointing
> them to multiple places.  I would prefer something like:
> 
> 	We have included the iODBC driver, as it is fast to build and works with
> DBD::ODBC.  However, your mileage may vary.  You may wish to use unixODBC,
> which can be found at http://www.unixodbc.org.  [Insert more comments here]

Is the iODBC being bundled upto date?

How does it compare in functionailty with UnixODBC? (I'd rather not
have DBD::ODBC be limited in functionality for the life of the
installation just because people took the easier option at build time.)

Have you tried building UnixODBC recently? (I've never tried so I can't comment.)

Tim.


> Jeff
> 
> > -----Original Message-----
> > From: Tim Bunce [mailto:Tim.Bunce@pobox.com]
> > Sent: Friday, August 10, 2001 8:11 AM
> > To: martin@easysoft.com
> > Cc: dbi-dev@perl.org
> > Subject: Re: Array Binding (an ODBC example)
> >
> >
> > On Fri, Aug 10, 2001 at 09:47:01AM +0100, martin@easysoft.com wrote:
> > >
> > > DBD::ODBC changed some time back to distribute with a driver
> > manager (iODBC,
> > > although the version is old now and I personally use the
> > unixODBC driver manager
> > > instead - http://www.unixodbc.org).
> >
> > Back then the DM was hard to find. Now it should be removed and
> > replaced with
> > references on where to get DMs from.
> >
> > > If an ODBC driver does not support array bound parameters I
> > guess DBD::ODBC
> > > should do the multiple calls to SQLExecute/SQLFetch moving
> > through the arrays -
> > > in that way people writing perl using DBD::ODBC do not have to
> > worry about a
> > > driver supporting arrays or not.
> >
> > Yes, although the DBI will also offer that, doing it within
> > DBD::ODBC would be
> > much faster.
> >
> > Tim.
> 

[prev in list] [next in list] [prev in thread] [next in thread]