From: | "Antonio Pennino" <a(dot)pennino(at)nocerainformatica(dot)net> |
---|---|
To: | pgsql-odbc(at)postgresql(dot)org |
Subject: | Re: problem with CVS version |
Date: | 2004-07-28 18:44:38 |
Message-ID: | 41081036.31430.3254A8@localhost |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
> If the connection is made using SQLConnectW,
> SQLDriverConnectW or SQLBrowseConnectW,
I am *sure* : i not call unicode API.
Ok, is a problem of the driver manager.
The MDAC update not solve the problem.
The database is not unicode:
firedell:/etc/postgresql# psql -l
List of databases
Name | Owner | Encoding
-----------+----------+-----------
dbrete | postgres | SQL_ASCII
firedell | postgres | SQL_ASCII
template0 | postgres | SQL_ASCII
template1 | postgres | SQL_ASCII
One table (with varchar also) is read ok, the other 4 no!
Building the connection string (via a .udl file) it is:
DSN=firedell;DATABASE=firedell;SERVER=192.168.160.254;PORT=5432
;UID=postgres;PWD=<omissis>;ReadOnly=0;Protocol=6.4;FakeOidInde
x=0;ShowOidColumn=0;RowVersioning=0;ShowSystemTables=0;ConnSett
ings=;Fetch=100;Socket=4096;UnknownSizes=0;MaxVarcharSize=254;M
axLongVarcharSize=8190;Debug=1;CommLog=0;Optimizer=1;Ksqo=1;Use
DeclareFetch=1;TextAsLongVarchar=0;UnknownsAsLongVarchar=0;Bool
sAsChar=0;Parse=1;CancelAsFreeStmt=0;ExtraSysTablePrefixes=dd_;
;LFConversion=1;UpdatableCursors=0;DisallowPremature=0;TrueIsMi
nus1=0;BI=0;ByteaAsLongVarBinary=0;UseServerSidePrepare=0
Why Protocol=6.4 when i have set it to 7.x? the server is 7.2.x
Sorry for yours time.... and for my time also :-))
============================================
Antonio Pennino
Nocera Informatica s.r.l.
telefono: 035/4219033
telefax : 035/4219050
e-mail : a(dot)pennino(at)nocerainformatica(dot)net
============================================
From | Date | Subject | |
---|---|---|---|
Next Message | Mario Soto | 2004-07-28 19:39:10 | Postgresql odbc coulumn bytea problem |
Previous Message | Janet Borschowa | 2004-07-28 16:18:03 | Re: Updatable Cursors, CTID, and Views |