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

List:       dbi-dev
Subject:    RE: Array Binding (an ODBC example)
From:       "Jeff Urlwin" <jurlwin () bellatlantic ! net>
Date:       2001-08-10 17:29:07
[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?

It was, at the time <G>.

>
> 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.)

My recollection is that it was more functionally complete, but someone else
would know better.

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

Not recently, but it was painfully slow on my machine.  It builds a lot of
individual files and takes a lot of time.  I never completely got it running
at the time, either.

>
> 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]