Re: PGAPI_SetPos error - Mailing list pgsql-odbc

From Patrick Hatcher
Subject Re: PGAPI_SetPos error
Date
Msg-id OFB5D3450A.271F106D-ON882571C3.00507976-882571C3.005082C8@FDS.com
Whole thread Raw
In response to Re: PGAPI_SetPos error  (Ludek Finstrle <luf@pzkagis.cz>)
List pgsql-odbc
Thanks!  I'll give this a try and report back.

Patrick Hatcher
Development Manager  Analytics/MIO
Macys.com




             Ludek Finstrle
             <luf@pzkagis.cz>
                                                                        To
             08/06/06 11:46 PM         Patrick Hatcher
                                       <PHatcher@macys.com>
                                                                        cc
                                       pgsql-odbc@postgresql.org
                                                                   Subject
                                       Re: [ODBC] PGAPI_SetPos error










Thu, Aug 03, 2006 at 08:57:39AM -0700, Patrick Hatcher wrote:
> ODBC v 8.1.2
>
> server.  When we try to update the table, we receive the following error:
> ERROR: Error updating table entry: Only SQL_POSITION/REFRESH is supported
> for PGAPI_SetPos
>
> Any suggestion as to what I can do?

Hello

The psqlODBC 08.01.XXXX doesn't support updateable cursors. I know there
is such option. But it doesn't work. Please try 08.02.0002 and then
replace the dlls with once from:

http://www.geocities.jp/inocchichichi/psqlodbc/index.html

It's the latest. The version there is 07.03.XXXX but you should use it.
I don't know why Hiroshi use that numbering.

Regards,

Luf



pgsql-odbc by date:

Previous
From:
Date:
Subject: [ psqlodbc-Bugs-1000681 ] Error when using ODBC driver with Microsoft Access
Next
From: hansell baran
Date:
Subject: Slow transfer speeds