Re: ODBC driver for Windows & future...

--- Russ Cobbe <russc(at)inline(dot)net> wrote:

> > > There is an ODBC=>JDBC gateway out there
> (closed-source I believe) but
> > I
> > > don't know of a .Net one.
> >
> > I think rather the ODBC driver should wrap the
> libpq library. The .net
> > driver has some justification for implementing its
> own protocol stack
> > because of marshalling issues; the ODBC has little
> to gain besides
> > paying a extra maintenance price which is now
> being paid in full :-).
> > There may be some valid reasons why this was done
> that I'm not aware of,
> > though.
>
> We might be able to help out here. We have written
> more ODBC drivers
> than any one else (50+). www.opayc.com
>
> What is the status of the project?
> What needs doing?
>
> We probably wouldn't be able to contribute anything
> until the new
> year but we can start looking at things now.

Many people (including me) would be blessing you if
you took it on.

The status of the project is: drifting. The driver
has been maintained by volunteers, with the attendant
time and resource problems. The last maintainer,
Hiroshi Inouye, did a great job, but since he quit,
no-one has stepped forward to take his place, in spite
of appeals.

Based on recent discussions on various lists (my
memory is hazy as to which), the opinion of the
Hackers appears to be that the ODBC driver is best
reimplemented as a wrapper to libpq, the PostgreSQL C
client library.

The nature of the current driver is determined by
implementation choices made years ago, when
circumstances were different. The code effectively
reimplements what libpq already provides, but in a
manner that is likely to be less robust. On the face
of it, further development along that track is a
questionable exercise at best. Especially in view of
the fact that none of us, who is currently involved,
actually understands the code.

>
> Russ Cobbe, President
> Inline Internet Systems, Inc.
> 20 Marlatts Road
> Thorold, ON L2V 1N1 Canada
> 1-905-680-0436x211 http://www.inline.net
> Providing Comprehensive E-Business Solutions
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 9: the planner will ignore your desire to choose
> an index scan if your
> joining column's datatypes do not match
>

__________________________________
Do you Yahoo!?
Yahoo! Mail - Helps protect you from nasty viruses.
http://promotions.yahoo.com/new_mail