Re: Latest ODBC driver?

> -----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 12:41
> To: pgsql-odbc(at)postgresql(dot)org
> Subject: Re: [ODBC] Latest ODBC driver?
>
> Dave Page wrote:
>
> > Mark; if you can wait for the new release, I think you'll
> be much happier in the long term.
>
> I can hold on a little while, scheduling the work isn't
> straightforward.
>
> Three questions if I may:
>
> i) What is the the minimum acceptable ODBC DLL versions I
> think I saw 3.51
> somewhere? Knowing this I might be able to contribute
> some more coherent
> testing/debugging info.

No idea - it's not something that came up before - iirc, the ODBC DM
hasn't changed much, if at all in the last few versions of MDAC.

> ii) Does the new driver insist on Unicode, and do I need to
> accomodate that
> in the app/database/table setup?

No, you use what you want and the driver handles it. There were (and
will continue to be) 2 drivers in 08.02, a Unicode one which most people
will use, and an ANSI one which is recommended for use with BDE apps,
and for people having trouble with their combination of LATINx charset
and whatever they're running on the server (a very small number of
people).

> iii) How do I de-install the 8.01.0200 driver? The usual way
> of working from
> NT's control panel applet simply reinstalls it.

That works fine on 2K/XP/2K3, but I've never tried on NT. You could try:

msiexec uninstall psqlodbc.msi

From a command prompt.

Regards, Dave.