From: Tibor Laszlo <ltibor@mail.tiszanet.hu>
To: mykarz@miyabara.com
Cc: pgsql-interfaces@postgresql.org
Subject: Re: ODBC Windows driver corrupts data?
Date: Tue, 21 Nov 2000 10:55:46 +0100
Message-ID: <00112111541200.01150@tir> (raw)
In-Reply-To: <000201c0501a$1f875af0$aa00a8c0@ncc1701e>
References: <000201c0501a$1f875af0$aa00a8c0@ncc1701e>
> I am having a rather strange, highly annoying problem. Any help would be
> appreciated.
>
> I am running PostgreSQL 7.0.2 on Linux 2.2.17, and I have the ODBC (windows)
> driver running on WinNT 4.0 spk6.
>
> The problem itself seems to be that if I try and do anything with a "text"
> field from the Windows machine, it deletes ALL the data from that field, in
> the entire table.
>
> The only change I did to the ODBC setup was turned the default "Read Only"
> off.
>
> Has anyone else experienced this?
Sorry for the late post. What kind of software makes your UPDATEs? Or do
them you? And can you get the ODBC log to view what UPDATE sent to the
backend caused this? (You can turn on the driver log vith the CommLog check box
on the Advanced Options (Driver) dialog. I think its better than the Win ODBC
DriverManager's tracing.) We make C++Builder apps with ODBCExpress and we always
watch the log files... I think your UPDEATE's WHERE clause was wrong. But
let's see the log...
Regards, Tibor
--
Tibor Laszlo
ltibor@mail.tiszanet.hu
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: ltibor@mail.tiszanet.hu, mykarz@miyabara.com
Subject: Re: ODBC Windows driver corrupts data?
In-Reply-To: <00112111541200.01150@tir>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox