Hello,
We are attempting to use an ETL tool (Monarch Data Pump) to move data from
various sources into PostgreSQL; however, we are recieving the following error
message when we attempt to Load the data:
[1500][SQLSetPos][1500]PGAPI_SetPos fOption=4 irow=1 lock=0 currt=0
[1500]STATEMENT ERROR: func=PGAPI_SetPos, desc='', errnum=10, errmsg='Only
SQL_POSITION/REFRESH is supported for PGAPI_SetPos'
[1500]CONN ERROR: func=PGAPI_SetPos, desc='', errnum=0, errmsg='(NULL)'
[1500][[SQLGetDiagRec]]
We tried several recent ODBC drivers (versions 7.03.02.03, 7.03.02, and
7.03.01), and made sure to check "Updateable Cursors".
I have also reviewed the posts at
http://archives.postgresql.org/pgsql-odbc/2003-07/msg00006.php and
http://archives.postgresql.org/pgsql-odbc/2003-04/msg00015.php and downloaded
the source code. Unfortunately, I have not programmed C for about
10 years. Are we missing something obvious?
Thanks,
Peter Eltgroth