Postgresql, ODBC, StarOffice 5.1

From: "Andrew D(dot) Balsa" <it(at)luckson(dot)com>
To: <pgsql-general(at)hub(dot)org>
Subject: Postgresql, ODBC, StarOffice 5.1
Date: 1999-10-11 09:22:31
Message-ID: 000701bf13ca$25057760$581ca8c0@it.luckson.intranet
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

I am using a Linux server with Postgresql 6.4.2 as server, and Windows98
with StarOffice 5.1 as clients through ODBC.
I tried to use large objects to store images, by adding the type lo as
suggested in the ODBC driver FAQ.
I am now getting the following error message:

****************************************************************************
******************************
conn=33095800, query='SELECT Table1_1."ID", Table1_1."test1" FROM "Table1"
Table1, "Table1" Table1_1'
[ fetched 16 rows ]
STATEMENT ERROR: func=SQLGetData, desc='', errnum=1, errmsg='Couldnt open
large object for reading.'
-----------------------------------------------------------
-
hdbc=33095800, stmt=33110328, result=33176068
manual_result=0, prepare=1, internal=0
bindings=33176784, bindings_allocated=2
parameters=0, parameters_allocated=0
statement_type=0, statement='SELECT Table1_1."ID",
Table1_1."test1" FROM "Table1" Table1, "Table1" Table1_1'
stmt_with_params='SELECT Table1_1."ID", Table1_1."test1"
FROM "Table1" Table1, "Table1" Table1_1'
data_at_exec=-1, current_exec_param=-1, put_data=0
currTuple=0, current_col=-1, lobj_fd=-1
maxRows=0, rowset_size=1, keyset_size=0, cursor_type=0,
scroll_concurrency=1
cursor_name='SQL_CUR01F93938'
----------------QResult
Info -------------------------------
fields=34148140, manual_tuples=0, backend_tuples=34071020,
tupleField=34071020, conn=33095800
fetch_count=0, fcount=16, num_fields=2, cursor='(null)'
message='(null)', command='SELECT', notice='(null)'
status=8, inTuples=0
CONN ERROR: func=SQLGetData, desc='', errnum=-2, errmsg='The buffer was too
small for the result.'
------------------------------------------------------------
henv=34144388, conn=33095800, status=1, num_stmts=16
sock=34144404, stmts=34144444, lobj_type=18048
---------------- Socket Info -------------------------------
socket=340, reverse=0, errornumber=0, errormsg='(null)'
buffer_in=33102128, buffer_out=33106228
buffer_filled_in=12, buffer_filled_out=0, buffer_read_in=11
****************************************************************************
*************************

What buffer is this? Where/how can I change its size?
Any help would be greatly appreciated. :-)
--
Andrew
Database Developer
Luckson Development

Browse pgsql-general by date

  From Date Subject
Next Message Max J. Tsai 1999-10-11 15:17:37
Previous Message Martin Dolog 1999-10-11 07:36:46 unsubscribe