Problem with ODBC driver and MSP 2002 - Mailing list pgsql-odbc

From Benoit Menendez
Subject Problem with ODBC driver and MSP 2002
Date
Msg-id 001401c1af92$777050e0$0201a8c0@osprey
Whole thread Raw
List pgsql-odbc
I have created a compatible schema in PostgreSQL for MSP 2002, but I ran into the following error from the ODBC driver:
 
This appears to be a relatively standard (parameterized) update statement:
 
update MSP_PROJECTS
set PROJ_READ_COUNT = '0',
  PROJ_LOCKED = '0',
  PROJ_READ_WRITE = '1' ,
  PROJ_READ_ONLY = '1' ,
  PROJ_MACHINE_ID = ?,
  PROJ_DATA_SOURCE = 'PostgreMSP'
where PROJ_NAME = 'New Product'
and (PROJ_READ_COUNT = '0' or PROJ_READ_COUNT IS NULL)
and (PROJ_READ_ONLY = '0' or PROJ_READ_ONLY IS NULL)
 
The same query works with SQL Server... And I already tried just about every setting in the driver to see if it made a difference... This is the only error I get with MSP 2002 and I can load save and load projects, but projects I open are read-only because of this bug (I assume).
 
Can you please help? I am using version 7.01.00.09 with PostgreSQL version 7.1.3-2
 
    Benoit
 
[SQLBindCol]PGAPI_BindCol: entering...
**** PGAPI_BindCol: stmt = 41127008, icol = 1
**** : fCType=1 rgb=0 valusMax=17 pcb=11decc
[SQLPrepare]PGAPI_Prepare: entering...
**** PGAPI_Prepare: STMT_READY, change SQL
[SQLBindParameter]PGAPI_BindParameter: entering...
PGAPI_BindParamater: ipar=0, paramType=1, fCType=1, fSqlType=12, cbColDef=254, ibScale=0, rgbValue=1171040, *pcbValue = 48, data_at_exec = 0
[SQLExecute]PGAPI_Execute: entering...
PGAPI_Execute: clear errors...
PGAPI_Execute: copying statement params: trans_status=1, len=307, stmt='update MSP_PROJECTS set PROJ_READ_COUNT = '0', PROJ_LOCKED = '0', PROJ_READ_WRITE = '1' , PROJ_READ_ONLY = '1' ,  PROJ_MACHINE_ID = ?,  PROJ_DATA_SOURCE = 'PostgreMSP' where PROJ_NAME = 'New Product' and (PROJ_READ_COUNT = '0' or PROJ_READ_COUNT IS NULL) and (PROJ_READ_ONLY = '0' or PROJ_READ_ONLY IS NULL)'
copy_statement_with_params: from(fcType)=1, to(fSqlType)=12
   stmt_with_params = 'update MSP_PROJECTS set PROJ_READ_COUNT = '0', PROJ_LOCKED = '0', PROJ_READ_WRITE = '1' , PROJ_READ_ONLY = '1' ,  PROJ_MACHINE_ID = 'OSPREY'
      it's NOT a select statement: stmt=41127008
send_query(): conn=41107464, query='update MSP_PROJECTS set PROJ_READ_COUNT = '0', PROJ_LOCKED = '0', PROJ_READ_WRITE = '1' , PROJ_READ_ONLY = '1' ,  PROJ_MACHINE_ID = 'OSPREY'
send_query: done sending query
read 38, global_socket_buffersize=4096
send_query: got id = 'E'
send_query: 'E' - ERROR:  Unterminated quoted string
in QR_Constructor
exit QR_Constructor
send_query: got id = 'Z'
STATEMENT ERROR: func=SC_execute, desc='', errnum=7, errmsg='Error while executing the query'
CONN ERROR: func=SC_execute, desc='', errnum=110, errmsg='ERROR:  Unterminated quoted string'
[SQLError]**** PGAPI_Error: henv=0, hdbc=0, hstmt=41127008 <512>
SC_get_error: status = 7, msg = #Error while executing the query;
ERROR:  Unterminated quoted string#
       szSqlState = 'S1000', szError='Error while executing the query;
ERROR:  Unterminated quoted string'
[SQLError]**** PGAPI_Error: henv=0, hdbc=0, hstmt=41127008 <512>
       returning NO_DATA_FOUND

pgsql-odbc by date:

Previous
From: Nhan Ngo Dinh
Date:
Subject: Unicode support
Next
From: Hiroshi Inoue
Date:
Subject: Re: Problem with ODBC driver and MSP 2002