Thread: Re: continuing problems with sqlsetpos & syncing postgresql to a mobile database

Re: continuing problems with sqlsetpos & syncing postgresql to a mobile database

From
"Hiroshi Inoue"
Date:
OK please try the latest snapshot dll at http://www.geocities.jp/inocchichichi/psqlodbc/ .
 
regards,
Hiroshi Inoue
-----Original Message-----
From: SweetBeet.com Webmaster [mailto:webmaster@agterra.com]

Hiroshi,
 
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>

Re: continuing problems with sqlsetpos & syncing postgresql to a mobile database

From
"Hollysugar Webmaster"
Date:
We installed the latest snapshot dll and received the following error
 
<error code>
[2224][SQLError][2224]**** PGAPI_Error: henv=0, hdbc=19100592 hstmt=0
[2224]**** PGAPI_ConnectError: hdbc=19100592 <512>
</error code>
 
CC_get_error returned nothing.
----- Original Message -----
Sent: Friday, April 11, 2003 10:56 AM
Subject: Re: [ODBC] continuing problems with sqlsetpos & syncing postgresql to a mobile database

OK please try the latest snapshot dll at http://www.geocities.jp/inocchichichi/psqlodbc/ .
 
regards,
Hiroshi Inoue
-----Original Message-----
From: SweetBeet.com Webmaster [mailto:webmaster@agterra.com]

Hiroshi,
 
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>

Re: syncing postgresql to a mobile database Works

From
"Hollysugar Webmaster"
Date:
Thank you everyone for your help. We were able to successfully sinc our mobile database application (Visual CE by SyWare) with our PostgreSql database. The latest snapshot release that Hiroshi prepared worked for us once we selected the server side prepare setting in the advanced tab of the driver settings.
 
We are really excited to be able to add data onto our mobile device and sync it with our remote database server. If anyone has any need or interest in doing this I would be more than happy to explain the process we went through. SyWare was extremely helpful in our development process and without their technical support or the assistance of this list and the psqlodbc driver developers we could not have made this project work.
 
Julie

Re: continuing problems with sqlsetpos & syncing postgresql to a mobile database

From
"Hiroshi Inoue"
Date:
Could you give me more details ?
 
regards,
Hiroshi Inoue
-----Original Message-----
From: Hollysugar Webmaster [mailto:webmaster@hollysugar.com]
Sent: Saturday, April 12, 2003 2:36 AM
To: Hiroshi Inoue
Cc: pgsql-odbc@postgresql.org; Dave Page
Subject: Re: [ODBC] continuing problems with sqlsetpos & syncing postgresql to a mobile database

We installed the latest snapshot dll and received the following error
 
<error code>
[2224][SQLError][2224]**** PGAPI_Error: henv=0, hdbc=19100592 hstmt=0
[2224]**** PGAPI_ConnectError: hdbc=19100592 <512>
</error code>
 
CC_get_error returned nothing.