ODBC Driver for Windows server 2008

From: Mathias Zajaczkowski <mathias(dot)zajaczkowski(at)ubik(dot)ch>
To: pgsql-odbc(at)postgresql(dot)org
Subject: ODBC Driver for Windows server 2008
Date: 2011-01-25 16:03:07
Message-ID: 4D3EF43B.4090208@ubik.ch
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

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
mathias(dot)zajaczkowski(at)ubik(dot)ch

Attachment Content-Type Size
mathias_zajaczkowski.vcf text/x-vcard 231 bytes

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Jens Kapp 2011-01-26 16:17:51 NO DATA error message in Frontend when querying large datasets
Previous Message Adrian Klaver 2011-01-22 00:45:12 Re: problem connecting via ODBC when unicode (now in correct forum.).