From: JT Kirkpatrick <jt-kirkpatrick@mpsllc.com>
To: 'pgsql-interfaces@hub.org' <pgsql-interfaces@hub.org>
To: 'pgsql-admin@hub.org' <pgsql-admin@hub.org>
Subject: odbc driver failing. . .
Date: Fri, 28 May 1999 11:55:06 -0400
Message-ID: <01BEA900.EE6149C0.jt-kirkpatrick@mpsllc.com> (raw)
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
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: jt-kirkpatrick@mpsllc.com, pgsql-interfaces@hub.org, pgsql-admin@hub.org
Subject: Re: odbc driver failing. . .
In-Reply-To: <01BEA900.EE6149C0.jt-kirkpatrick@mpsllc.com>
* 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