I think you'll find you're suffering from other effects of the bug
The latest snapshot (8.00.0004) contains the fix. It worked for me, as
long as you don't use Memo field types.
If the installer doesn't seem to be removing/repairing/upgrading the
ODBC driver, check the version by inspecting the properties of
psqlodbc.dll in WINNT\system32. Just delete it or overwrite it with the
Marco Tamanti wrote:
>Before installing version 8.0.1 of postgresql on windows 2000 SP4, I was
>in this situation:
>postgresql 7.3.4 on a linux machine
>Borland C++Builder 4 updated Pack 1.
>After installing postgresql-8.0.1 on the same machine where I run
>C++Builder, I've had a problem with varchar (or character varying):
>When I run applications built with c++builder I get the error
>"<ComponentName>: field '<fieldName>' not found.", where <ComponentName>
>and <fieldName> are appropriate values.
>With Database Explorer, I can see that all the information on the tables
>are correct and that the fields are there.
>If I enter an SQL statement "select * from tablename" the result does
>not contain varchar fields.
>If I do "select fieldname from tablename" where fieldname is a varchar
>field, I get the column with all empty values.
>Using pgadmin none of these problems appear. All queries are ok.
>The same problem appears even if I connect to the old postgres 7.3.4 on
>linux. This, after the installation of the 8.0.1 version.
>I've tried to reinstall Windows 2000, C++Builder (now version 5),
>pgsqlodbc-07_03_0200 and the old database 7.3.4 on linux was perfectly
>responding. After installing postgres 8.0.1 on windows the problem came
>Even when I remove postgres 8.0.1 the problem persist.
>I suppose there's a problem on odbc driver, but I tried to install it
>again with no result. I tried to reinstall C++Builder and no result
>Anyone with the same problem? Any solution?
>I'm using SQL_ASCII coding. Most of testing has been done on a
>varchar(50) field, not null, storage extended.
In response to
pgsql-odbc by date
|Next:||From: Marco Tamanti||Date: 2005-02-07 09:27:46|
|Subject: R: varchar problem after installing postgresql-8.0.1 on windows|
|Previous:||From: Iain||Date: 2005-02-07 08:31:21|
|Subject: Re: ODBC & character encoding|