Thread: Postgresql, ODBC, StarOffice 5.1

Postgresql, ODBC, StarOffice 5.1

From
"Andrew D. Balsa"
Date:
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