Home > mailing lists

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

From	Benoit Menendez
Subject	Problem with ODBC driver and MSP 2002
Date	February 7, 2002 02:49:59
Msg-id	001401c1af92$777050e0$0201a8c0@osprey Whole thread Raw
List	pgsql-odbc

Tree view

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:

From: Nhan Ngo Dinh
Date: 03 February 2002, 18:37:04
Subject: Unicode support

From: Hiroshi Inoue
Date: 07 February 2002, 03:49:35
Subject: Re: Problem with ODBC driver and MSP 2002

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

Previous

Next