From: | "Hollysugar Webmaster" <webmaster(at)hollysugar(dot)com> |
---|---|
To: | <pgsql-odbc(at)postgresql(dot)org> |
Subject: | Re: continuing problems with sqlsetpos & syncing postgresql to a mobile database |
Date: | 2003-04-11 16:25:03 |
Message-ID: | 004401c30046$e8369db0$a1d2a8c0@impsu.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
MessageHiroshi,
Thank you very much for replying. We did finally determine that the problem with the update was that the oid column was a user defined column. The vendor for our mobile database altered their application so it no longer needed to utilize an oid column and we were successfully able to use sql_update and sql_delete. We are still having problems with sql_add. I have pasted a snippet of the code from the psqlodbc mylog below. Thank you in advance for any help you can offer on this.
Julie
<snippet>
[3148]pcrow=1
[3148][SQLSetPos][3148]PGAPI_SetPos fOption=4 irow=2 lock=0 currt=1
[3148]STATEMENT ERROR: func=PGAPI_SetPos, desc='', errnum=21, errmsg='Row value out of range'
[3148]CONN ERROR: func=PGAPI_SetPos, desc='', errnum=0, errmsg='(NULL)'
[3148][[SQLGetDiagRec]]
[3148]PGAPI_GetDiagRec entering rec=1[3148]**** PGAPI_StmtError: hstmt=19137600 <2000>
[3148]SC_get_error: status = 21, msg = #Row value out of range#
[3148] szSqlState = 'S1107',len=22, szError='Row value out of range'
[3148]PGAPI_GetDiagRec exiting 0
[3148][[SQLGetDiagRec]]
[3148]PGAPI_GetDiagRec entering rec=2[3148]**** PGAPI_StmtError: hstmt=19137600 <2000>
[3148]SC_get_error: status = 21, msg = #Row value out of range#
[3148]PGAPI_GetDiagRec exiting 100
[3148][[SQLGetDiagRec]]
[3148]PGAPI_GetDiagRec entering rec=1[3148]**** PGAPI_StmtError: hstmt=19137600 <512>
[3148]SC_get_error: status = 21, msg = #Row value out of range#
[3148] szSqlState = 'S1107',len=22, szError='Row value out of range'
[3148]PGAPI_GetDiagRec exiting 0
</snippet>
----- Original Message -----
From: Hiroshi Inoue
To: SweetBeet.com Webmaster
Cc: pgsql-odbc(at)postgresql(dot)org ; Dave Page
Sent: Friday, April 11, 2003 3:27 AM
Subject: RE: continuing problems with sqlsetpos & syncing postgresql to a mobile database
Sorry for the late answer.
How did you create the "contract_test" table ?
OID seems to be a user column in contract_test not a system column.
regards,
Hiroshi Inoue
-----Original Message-----
From: SweetBeet.com Webmaster [mailto:webmaster(at)agterra(dot)com]
Sent: Wednesday, April 09, 2003 4:46 AM
To: Dave Page
Cc: pgsql-odbc(at)postgresql(dot)org; Hiroshi Inoue
Subject: continuing problems with sqlsetpos & syncing postgresql to a mobile database
Dave,
We tried both the snapshot of the psqlodbc driver and the snapshot of the psqlodbc30 driver. We were not able to get either to work. I looked through the logs and when I searched for "error" I did find new error messages but I am not sure what they mean. I have attached all the logs for both drivers. I truncated the mylogs to reduce their size, let me know if you need to see the full log
Julie
From | Date | Subject | |
---|---|---|---|
Next Message | Hiroshi Inoue | 2003-04-11 16:56:39 | Re: continuing problems with sqlsetpos & syncing postgresql to a mobile database |
Previous Message | Chris Gamache | 2003-04-11 12:38:44 | Re: Connection to posgresql database works under windows scripting host but not IIS/ASP |