Re: PGAPI_SetPos error - Mailing list pgsql-odbc

From Ludek Finstrle
Subject Re: PGAPI_SetPos error
Date
Msg-id 20060807064647.GB20625@soptik.pzkagis.cz
Whole thread Raw
In response to PGAPI_SetPos error  (Patrick Hatcher <PHatcher@macys.com>)
Responses Re: PGAPI_SetPos error  (Patrick Hatcher <PHatcher@macys.com>)
List pgsql-odbc
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-1000699 ] Problem creating TableAdapter with WHERE parameter
Next
From:
Date:
Subject: [ psqlodbc-Bugs-1000702 ] Issues with pgSQL 8.1.3 - Error 42601