From: | Gavrie Philipson <gavrie(at)netmor(dot)com> |
---|---|
To: | pgsql-interfaces(at)postgresql(dot)org |
Subject: | Problems with PostODBC driver |
Date: | 1999-04-15 16:55:19 |
Message-ID: | XFMail.990415195519.gavrie@netmor.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-interfaces |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Sergio A. Kessler | 1999-04-15 21:03:23 | Re: [INTERFACES] tuple size too big?? |
Previous Message | Ari Halberstadt | 1999-04-15 15:45:31 | Re: [INTERFACES] JDBC (executing transactions coding style) |