Postgresql, ODBC, StarOffice 5.1 - Mailing list pgsql-general
From | Andrew D. Balsa |
---|---|
Subject | Postgresql, ODBC, StarOffice 5.1 |
Date | |
Msg-id | 000701bf13ca$25057760$581ca8c0@it.luckson.intranet Whole thread Raw |
List | 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
pgsql-general by date: