| 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: | Whole Thread | Raw Message | 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
| 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 |