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