Skip site navigation (1) Skip section navigation (2)

Re: varchar problem after installing postgresql-8.0.1 on windows

From: David Brown <time(at)bigpond(dot)net(dot)au>
To: Marco Tamanti <tama(at)inwind(dot)it>
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: varchar problem after installing postgresql-8.0.1 on windows
Date: 2005-02-07 08:37:24
Message-ID: 420728C4.9090700@bigpond.net.au (view raw or flat)
Thread:
Lists: pgsql-odbc
I think you'll find you're suffering from other effects of the bug 
described here:

http://gborg.postgresql.org/project/psqlodbc/bugs/bugupdate.php?996

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 
new version.

Regards

David

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
>pgsqlodbc-07_03_0100
>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
>out again.
>
>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
>again.
>
>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

Responses

pgsql-odbc by date

Next:From: Marco TamantiDate: 2005-02-07 09:27:46
Subject: R: varchar problem after installing postgresql-8.0.1 on windows
Previous:From: IainDate: 2005-02-07 08:31:21
Subject: Re: ODBC & character encoding

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group