Re: ODBC Upgrades

Dave,

When I uninstall the old driver and install the newer driver it is not
available in admin tools data sources as a driver to select from to
configure any type of DSN. In addition, when I have attempted to use the
newer MSI packages to install the ODBC it registers in the local machine
but not the current user. Any thoughts?

Thank you for your support.

_____

Annette Curtis - Database Manager
University of Rochester School of Nursing
office: (585) 275-5398
annette_curtis(at)urmc(dot)rochester(dot)edu
-----Original Message-----
From: Dave Page [mailto:dpage(at)postgresql(dot)org]
Sent: Friday, May 04, 2007 10:56 AM
To: Curtis, Annette M
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: [ODBC] ODBC Upgrades

Curtis, Annette M wrote:
> Currently I have 08.00.0101 installed as PSQLODBC dated 03/05/2005.
> Whenever I attempt to use the MSI installation of any of the later
> versions this dll does not upgrade and nor does it install the latest
> version of the MSI either.

No, it will only upgrade from an early revision - ie. 08.00.0101 ->
08.00.0400. Uninstall the old driver first, and then install the new
one.
>
> I am currently running PostgreSQL ver. 8.2.x which was just upgraded
> from 7.4.x this week. I was able to reload the entire client for
PgAdmin
> and it works successfully.
>
>
>
> However, I am unable to update the ODBC file and currently have users
> who are unable to access there databases since I am unable to update
the
> ODBC client from the MSI installation. The majority of the users are
on
> WinXP a few are still on Win2K.

Why are they unable to connect? The driver is backwards compatible with
older servers, and the server is backward compatible with the older
clients.

Regards, Dave.