Re: problem with CVS version

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
============================================

In response to

Browse pgsql-odbc by date

  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