pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedODBC Windows driver corrupts data?
3+ messages / 2 participants
[nested] [flat]
* ODBC Windows driver corrupts data?
@ 2000-11-16 22:11 Michael Miyabara-McCaskey <mykarz@miyabara.com>
2000-11-21 09:55 ` Re: ODBC Windows driver corrupts data? Tibor Laszlo <ltibor@mail.tiszanet.hu>
0 siblings, 1 reply; 3+ messages in thread
From: Michael Miyabara-McCaskey @ 2000-11-16 22:11 UTC (permalink / raw)
To: pgsql-interfaces
Hello all,
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?
-Michael Miyabara-McCaskey
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: ODBC Windows driver corrupts data?
2000-11-16 22:11 ODBC Windows driver corrupts data? Michael Miyabara-McCaskey <mykarz@miyabara.com>
@ 2000-11-21 09:55 ` Tibor Laszlo <ltibor@mail.tiszanet.hu>
2000-11-22 23:13 ` RE: ODBC Windows driver corrupts data? Michael Miyabara-McCaskey <mykarz@miyabara.com>
0 siblings, 1 reply; 3+ messages in thread
From: Tibor Laszlo @ 2000-11-21 09:55 UTC (permalink / raw)
To: mykarz@miyabara.com; +Cc: pgsql-interfaces
> 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
^ permalink raw reply [nested|flat] 3+ messages in thread
* RE: ODBC Windows driver corrupts data?
2000-11-16 22:11 ODBC Windows driver corrupts data? Michael Miyabara-McCaskey <mykarz@miyabara.com>
2000-11-21 09:55 ` Re: ODBC Windows driver corrupts data? Tibor Laszlo <ltibor@mail.tiszanet.hu>
@ 2000-11-22 23:13 ` Michael Miyabara-McCaskey <mykarz@miyabara.com>
0 siblings, 0 replies; 3+ messages in thread
From: Michael Miyabara-McCaskey @ 2000-11-22 23:13 UTC (permalink / raw)
To: 'Tibor Laszlo' <ltibor@mail.tiszanet.hu>; +Cc: pgsql-interfaces; cedarc@visionforisrael.com
Thanks to each of you who responded...
I did figure out the problem.
The NT4 box was using MS Access 2000, after seeing a few other post on
"[INTERFACES] Access 2000 and empty fields"... I decided that upgrading MS
Access 2000 to Service Pack1, the MS JET to Spk5, and the MS MDAC to 2.6
were all great ideas.
I did all of them, and additionally turned on the OID field in the ODBC
driver, and have since used the OID as the unique field identifier... and
viola! Life is good... It seems that my actual troubles were the following:
In my meanderings I found a Q-Article on the Microsoft website that said
something like "text" is converted to "memo" for MS Access, and there was a
bug about using a "memo" field as a unique ID field. Although I can not for
the life of me find that article again on the MS site.
As for the query itself, I never even ran it... I only "linked" to the
tables via ODBC from MS Access 2000, and the "text" field that I selected to
be the unique identifier, had all it's data destroyed.
-Michael Miyabara-McCaskey
> -----Original Message-----
> From: pgsql-interfaces-owner@postgresql.org
> [mailto:pgsql-interfaces-owner@postgresql.org]On Behalf Of
> Tibor Laszlo
> Sent: Tuesday, November 21, 2000 1:56 AM
> To: mykarz@miyabara.com
> Cc: pgsql-interfaces@postgresql.org
> Subject: Re: [INTERFACES] ODBC Windows driver corrupts data?
>
>
> > 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
>
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2000-11-22 23:13 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-11-16 22:11 ODBC Windows driver corrupts data? Michael Miyabara-McCaskey <mykarz@miyabara.com>
2000-11-21 09:55 ` Tibor Laszlo <ltibor@mail.tiszanet.hu>
2000-11-22 23:13 ` Michael Miyabara-McCaskey <mykarz@miyabara.com>
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