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 |
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.). |