From: Gavrie Philipson <gavrie@netmor.com>
To: pgsql-interfaces@postgresql.org
Subject: Problems with PostODBC driver
Date: Thu, 15 Apr 1999 19:55:19 +0300 (IDT)
Message-ID: <XFMail.990415195519.gavrie@netmor.com> (raw)
Hi,
I have a database in MS Access 97 which I want to port to PostgreSQL.
The database has rather large text fields (30-50k each), which are stored
as 'memo' fields in Access.
I have created the table structure in Postgres, and used the 'text' data
type for these fields.
However, when I try to INSERT the data from the Access table into the
Postgres one (I have linked the PG table into Access using ODBC), I have
big problems adding rows with the big text fields.
I should mention that adding small records (a few K each) is no problem.
The error I get from Access:
> ODBC--insert on linked table 'products' failed.
> Error while executing the query; Query string is too long (#1)
----------------------------------------------------------
Excerpts from the psqlodbc log file:
conn=81133688, SQLDriverConnect( in)='DSN=PostgreSQL;', fDriverCompletion=1
DSN info: DSN='PostgreSQL',server='cheetah',port='5432',dbase='companies',
user='company',passwd='xxxxx'
readonly='0',protocol='6.4',showoid='0',fakeoidindex='0',
showsystable='0'
conn_settings=''
translation_dll='',translation_option=''
Global Options: Version='06.40.0005', fetch=100, socket=4096,
unknown_sizes=0,
max_varchar_size=254, max_longvarchar_size=65536
disable_optimizer=1, ksqo=1, unique_index=0, use_declarefetch=0
text_as_longvarchar=1, unknowns_as_longvarchar=0, bools_as_char=1
extra_systable_prefixes='dd_;', conn_settings=''
[....]
[lots of INSERTs that went OK]
[last, large INSERT (but <64k)]
----------------QResult Info
CONN ERROR: func=SC_execute, desc='', errnum=103, errmsg='Query string is
too long'
------------------------------------------------------------
henv=82186080, conn=81133688, status=1, num_stmts=16
sock=82186096, stmts=82186136, lobj_type=-999
---------------- Socket Info -------------------------------
socket=53, reverse=0, errornumber=0, errormsg='(null)'
buffer_in=81140016, buffer_out=81144116
buffer_filled_in=3, buffer_filled_out=0, buffer_read_in=2
conn=81133688, SQLDisconnect
------------------------------------------------------------------
------------------------------------------------------------------
My system info: Postgres server on Linux 2.0.
ODBC driver version: 6_40_0005 (Insight)
Postgresql database version: 6.4.2
-----------------------------------------
I have tried playing a lot with the max_longvarchar_size setting in the
ODBC control panel. I even tried to set it to (-4) which should give
unlimited size according to the FAQ. But, no dice.
Any ideas as to why I can't INSERT these big text blocks?
Thanks,
Gavrie.
--
Gavrie Philipson
Netmor Applied Modeling Research Ltd.
Bnei Brak, Israel.
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: gavrie@netmor.com
Subject: Re: Problems with PostODBC driver
In-Reply-To: <XFMail.990415195519.gavrie@netmor.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