From: | Peter Eltgroth <peter(at)accutelligence(dot)com> |
---|---|
To: | pgsql-odbc(at)postgresql(dot)org |
Subject: | PGAPI_SetPos |
Date: | 2003-11-14 18:19:49 |
Message-ID: | 1068833989.3fb51cc575321@accutelligence.com |
Views: | Whole Thread | Raw Message | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Tomas =?iso-8859-1?q?Sk=E4re?= | 2003-11-14 18:55:45 | Re: PGAPI_SetPos |
Previous Message | Ted Thibodeau Jr | 2003-11-13 17:34:48 | Re: Mac OS X Driver |