> 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.pennino@nocerainformatica.net
============================================