Re: ODBC Driver for Windows server 2008

Hi Mathias,

(2011/01/26 1:03), Mathias Zajaczkowski wrote:
> Hi,
>
> Could you tell me how to install a Postgres ODBC driver on Windows
> Server 2008 for Postgres 8.4.
> I've used psqlodbc.msi from psqlodbc_08_04_0200.zip however the driver
> does not show up in ODBC Data Source Administrator.
>
> Then I've used psqlodbc.msi from psqlodbc_09_00_0200-x64.zip and when I
> try to connect using DSN file I receive the following message

There are 2 kinds of applications on 64bit Windows, 32bit ones and
64bit ones.

32bit applications requires 32bit ODBC drivers and 32bit ODBC
DataSource Adminstrator is needed to manage DSNs.
64bit applications requires 64bit ODBC drivers and 64bit ODBC
DataSource Adminstrator is needed to manage DSNs.
Maybe ODBC DataSource Administrator which you are using is the 64bit
one and the application you use to connect via DSN file is the 32bit
one.
please look at
http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/~checkout~/psqlodbc/psqlodbc/docs/faq.html?rev=1.10&content-type=text/html
.
You can find a FAQ 6.8) Installing psqlODBC on 64bit Windows.

regards,
Hiroshi Inoue