Re: ODBC Driver for Windows server 2008

From: Hiroshi Inoue <inoue(at)tpf(dot)co(dot)jp>
To: Mathias Zajaczkowski <mathias(dot)zajaczkowski(at)ubik(dot)ch>
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: ODBC Driver for Windows server 2008
Date: 2011-01-27 13:06:56
Message-ID: 4D416DF0.1020303@tpf.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

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

In response to

Browse pgsql-odbc by date

  From Date Subject
Next Message Andrus Moor 2011-01-30 14:42:01 09.00.0100 does not return data, 08.03.0400 causes exception Out of memory while reading tuples
Previous Message Jens Kapp 2011-01-27 11:14:47 Re: NO DATA error message in Frontend when querying large datasets