Home > mailing lists

Thread: Problem with ODBC driver and MSP 2002

Problem with ODBC driver and MSP 2002

From

Benoit Menendez

Date:

07 February 2002, 02:49:59

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

Re: Problem with ODBC driver and MSP 2002

From

Hiroshi Inoue

Date:

07 February 2002, 03:49:35

> Benoit Menendez wrote:
>
> 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

I've just changed a suspicious place.
Please try the driver at
        http://w2422.nsk.ne.jp/~inoue/
and let me know the result.

regards,
Hiroshi Inoue

Re: Problem with ODBC driver and MSP 2002

From

Benoit Menendez

Date:

07 February 2002, 04:29:46

Thanks, this fixes the problem...

    Benoit

----- Original Message -----
From: "Hiroshi Inoue" <Inoue@tpf.co.jp>
To: "Benoit Menendez" <benoitm@pacbell.net>
Cc: <pgsql-odbc@postgresql.org>
Sent: Wednesday, February 06, 2002 9:43 PM
Subject: Re: [ODBC] Problem with ODBC driver and MSP 2002


> > Benoit Menendez wrote:
> >
> > 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
>
> I've just changed a suspicious place.
> Please try the driver at
>         http://w2422.nsk.ne.jp/~inoue/
> and let me know the result.
>
> regards,
> Hiroshi Inoue
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html

Re: Problem with ODBC driver and MSP 2002

From

Benoit Menendez

Date:

07 February 2002, 04:49:51

Thanks, this fixes the problem...

    Benoit

----- Original Message -----
From: "Hiroshi Inoue" <Inoue@tpf.co.jp>
To: "Benoit Menendez" <benoitm@pacbell.net>
Cc: <pgsql-odbc@postgresql.org>
Sent: Wednesday, February 06, 2002 9:43 PM
Subject: Re: [ODBC] Problem with ODBC driver and MSP 2002


> > Benoit Menendez wrote:
> >
> > 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
>
> I've just changed a suspicious place.
> Please try the driver at
>         http://w2422.nsk.ne.jp/~inoue/
> and let me know the result.
>
> regards,
> Hiroshi Inoue
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html