pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedodbc driver failing. . .
2+ messages / 2 participants
[nested] [flat]
* odbc driver failing. . .
@ 1999-05-28 15:55 JT Kirkpatrick <jt-kirkpatrick@mpsllc.com>
1999-05-28 16:06 ` Re: [INTERFACES] odbc driver failing. . . Geoffrey C. Speicher <geoff@sirius.trassociates.com>
0 siblings, 1 reply; 2+ messages in thread
From: JT Kirkpatrick @ 1999-05-28 15:55 UTC (permalink / raw)
To: 'pgsql-interfaces@hub.org' <pgsql-interfaces@hub.org>; 'pgsql-admin@hub.org' <pgsql-admin@hub.org>
hi all. i have written in about illegal page faults when i try to add
records to a particular table -- editing it seems fine. well, i have
narrowed down another "weird" problem with the same table. i reported that
when i open it directly in datasheet view, the odbc driver fails every
time. this is not my largest table at all -- this one is 14M and over 45k
records -- my largest is 23M and over 90k records. i can open every other
table up in datasheet view (msaccess97 by the way) except the 14M one.
here is the log file after i opened a few other tables and then finally
the one that bombs -- does anyone have any ideas about what is going
wrong?? a few suspects -- the table has a field defined as varchar(300)
and another varchar(550) -- i have the odbc driver set to cache 1000 (at
least in this log file -- it was 100 and still bombed!), maxvarchar=550,
maxlongvarchar=15000. but editing the table a record at a time -- or even
pulling up a subset of records from the table works fine. . .
thanks for any suggestions! jt
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: [INTERFACES] odbc driver failing. . .
1999-05-28 15:55 odbc driver failing. . . JT Kirkpatrick <jt-kirkpatrick@mpsllc.com>
@ 1999-05-28 16:06 ` Geoffrey C. Speicher <geoff@sirius.trassociates.com>
0 siblings, 0 replies; 2+ messages in thread
From: Geoffrey C. Speicher @ 1999-05-28 16:06 UTC (permalink / raw)
To: JT Kirkpatrick <jt-kirkpatrick@mpsllc.com>; +Cc: 'pgsql-interfaces@hub.org' <pgsql-interfaces@hub.org>
> hi all. i have written in about illegal page faults when i try to add
I, too, witnessed some strange crashes in the ODBC driver. Checking the
"Recognize Unique Indexes" option in the advanced driver settings cleared
them up for me. May be worth a shot.
Geoff
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~1999-05-28 16:06 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1999-05-28 15:55 odbc driver failing. . . JT Kirkpatrick <jt-kirkpatrick@mpsllc.com>
1999-05-28 16:06 ` Geoffrey C. Speicher <geoff@sirius.trassociates.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