ODBC Driver for Windows server 2008

This is a multi-part message in MIME format.
--------------020409000800080303070306
Content-Type: multipart/related;
boundary="------------050509080904090707070702"


--------------050509080904090707070702
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit








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







Here is the content of my dsn file:



[ODBC]

DRIVER=PostgreSQL Unicode(x64)

UID=postgres

XaOpt=1

GssAuthUseGSS=0

LowerCaseIdentifier=0

UseServerSidePrepare=0

ByteaAsLongVarBinary=0

BI=0

TrueIsMinus1=0

DisallowPremature=0

UpdatableCursors=1

LFConversion=1

ExtraSysTablePrefixes=dd_

CancelAsFreeStmt=0

Parse=0

BoolsAsChar=1

UnknownsAsLongVarchar=0

TextAsLongVarchar=1

UseDeclareFetch=0

Ksqo=1

Optimizer=0

CommLog=0

Debug=0

MaxLongVarcharSize=8190

MaxVarcharSize=255

UnknownSizes=0

Socket=4096

Fetch=100

ConnSettings=

ShowSystemTables=0

RowVersioning=0

ShowOidColumn=0

FakeOidIndex=0

Protocol=7.4

ReadOnly=0

SSLmode=disable

PORT=5432

SERVER=localhost

DATABASE=Affaires





Any advice / help would be appreciated.



Thanks in advance

-- 

Mathias Zajaczkowski

Ubik S.A.

Chemin du Signal 22

1296 Coppet

(+) 41 22 960 03 91

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~/psqlo dbc/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

--
Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc