Re: Latest ODBC driver?

[Hiroshi Inoue <inoue(at)tpf(dot)co(dot)jp>]

Dave Page wrote:
>  
>
> > -----Original Message-----
> > From: pgsql-odbc-owner(at)postgresql(dot)org 
> > [mailto:pgsql-odbc-owner(at)postgresql(dot)org] On Behalf Of Mark 
> > Morgan Lloyd
> > Sent: 27 August 2006 22:49
> > To: pgsql-odbc(at)postgresql(dot)org
> > Subject: Re: [ODBC] Latest ODBC driver?
> >
> > Does this correspond to the versions of e.g. odbc32.dll as 
> > shown in the control
> > panel? 
>
> No - it's just the version of the spec that the driver supports.
>
> > Noted comment about the BDE- I'm still using that but trying 
> > to work to a point
> > where I can junk it: IMO it's the worst of all worlds. On the 
> > other hand once I
> > get rid of BDE I'm not sure whether I'll continue using ODBC 
> > or go direct. Are
> > there any specific issues I should be watching out for with 
> > BDE and the ANSI
> > driver?
>
> No - it's the Unicode one that disagrees with BDE - specifically,
> text/varchar columns will all be empty if requested as Unicode strings -
> which is exactly what BDE does because the driver offers that as the
> default.

As for BDE, I'm not able to test it by myself unfortunately.
I have a little hope in the next release with the combination
of the Unicode driver and BDE.
At the Advanced Options (DataSource) Page 2 of setup dialog
you can see Extra opts option. Settng the option to 0x4 may
take some effect though I'm not sure.

You can test it using the snapshot driver at  http://www.geocities.jp/inocchichichi/psqlodbc/index.html
.
If you already installed the 8.2.0002 driver, you can
simply replace the dll psqlodbc35w.dll at the site.

regards,
Hiroshi Inoue