Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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: mathias_zajaczkowski.vcf
Description: text/x-vcard (231 bytes)

Responses

pgsql-odbc by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group