Thread: OpenOffice: SetPos with data_at_exec not yet supported

OpenOffice: SetPos with data_at_exec not yet supported

From
Frank Joerdens
Date:
Greetings! Intermittently, but not regularly (unfortunately; those
errors are the most notoriously difficult to pinpoint), when browsing
records which were pulled into OO from a PostgreSQL database via the
Postgres Windows ODBC driver, the error

SetPos with data_at_exec not yet supported

pops up. If you confirm the dialog which displays this error message,
and try to browse to the next record, you get a second one:

Only SQL_POSITION/REFRESH is supported for PGAPI_SetPos

If you confirm this dialog too, and try to move to the next or previous
(or first, last ... ) record, it'll pop up again. The only way to get
rid of it is to press the 'Undo: Data entry' button. Sometimes this
won't work though; what I do then is press 'Undo: Data entry' first, and
after that a button on the form that I've created (which opens another
document). Now I can continue browsing records. This doesn't make any
sense to me.

It would seem that sometimes OO thinks I'm trying to update
some record in the database although all I am doing is pressing the
'Next Record' button. At first I thought that the follwing stuff in the
ODBC driver's log file was corresponding to the error, but it doesn't -
this message also regularly appears in the logfile when the error
message doesn't pop up:

-- snip --
STATEMENT ERROR: func=PGAPI_SetStmtAttr, desc='', errnum=28, errmsg='Unsupported statement option (Set)'
                 ------------------------------------------------------------
                 hdbc=58191016, stmt=58399760, result=0
                 manual_result=0, prepare=0, internal=0
                 bindings=0, bindings_allocated=0
                 parameters=0, parameters_allocated=0
                 statement_type=-2, statement='(NULL)'
                 stmt_with_params='(NULL)'
                 data_at_exec=-1, current_exec_param=-1, put_data=0
                 currTuple=-1, current_col=-1, lobj_fd=-1
                 maxRows=0, rowset_size=1, keyset_size=0, cursor_type=1, scroll_concurrency=1
                 cursor_name=''
                 ----------------QResult Info -------------------------------
CONN ERROR: func=PGAPI_SetStmtAttr, desc='', errnum=0, errmsg='(NULL)'
            ------------------------------------------------------------
            henv=57949464, conn=58191016, status=1, num_stmts=16
            sock=57982624, stmts=57998696, lobj_type=-999
            ---------------- Socket Info -------------------------------
            socket=1040, reverse=0, errornumber=0, errormsg='(NULL)'
            buffer_in=58315440, buffer_out=58202016
            buffer_filled_in=238, buffer_filled_out=0, buffer_read_in=238
-- snap --

I am using OOo 1.1, PostgreSQL 7.4.1, the PsqlODBC driver
7.03.02.00, and I've set the 'Updatable Cursors' DSN option to 'On' -
which is an idea I've got from

http://archives.postgresql.org/pgsql-odbc/2003-04/msg00014.php

Any ideas?

Regards, Frank

Re: OpenOffice: SetPos with data_at_exec not yet supported

From
"Hiroshi Inoue"
Date:
> -----Original Message-----
> From: Frank Joerdens
>
> Greetings! Intermittently, but not regularly (unfortunately; those
> errors are the most notoriously difficult to pinpoint), when browsing
> records which were pulled into OO from a PostgreSQL database via the
> Postgres Windows ODBC driver, the error
>
> SetPos with data_at_exec not yet supported
>
> pops up. If you confirm the dialog which displays this error message,
> and try to browse to the next record, you get a second one:
>
> Only SQL_POSITION/REFRESH is supported for PGAPI_SetPos

Could you try the dll at
    http://www.geocities.jp/inocchichichi/psqlodbc/ ?

regards,
Hiroshi Inoue