ODBC - Mailing list pgsql-odbc

From Lázaro Alonso Baca Marín
Subject ODBC
Date
Msg-id 1031172069.3d766fe5a967a@gaspacho.matmor.unam.mx
Whole thread Raw
List pgsql-odbc
Hello

I'm programming in Power Builder 8.0
I have Postgresql 7.2 in a red hat 7.3 machine
I have ODBC-07-02-0002

I'm connecting with the postgres user.

When I try to access some table with the ODBC, the PowerBuildeer crash
can someone help me??

this is the content of the odbc.log file:



conn=66992464, query='select pbe_name, pbe_edit, pbe_type, pbe_cntr,
pbe_work, pbe_seqn, pbe_flag from "postgres".pbcatedt order by pbe_name,
pbe_seqn'
ERROR from backend during send_query: 'ERROR:  parser: parse error at or
near "."'
STATEMENT ERROR: func=SC_execute, desc='', errnum=7, errmsg='Error while
executing the query'

------------------------------------------------------------
                 hdbc=66992464, stmt=66986264, result=67013344
                 manual_result=0, prepare=0, internal=0
                 bindings=0, bindings_allocated=0
                 parameters=0, parameters_allocated=0
                 statement_type=0, statement='select pbe_name, pbe_edit,
pbe_type, pbe_cntr, pbe_work, pbe_seqn, pbe_flag from "postgres".pbcatedt
order by pbe_name, pbe_seqn'
                 stmt_with_params='select pbe_name, pbe_edit, pbe_type,
pbe_cntr, pbe_work, pbe_seqn, pbe_flag from "postgres".pbcatedt order by
pbe_name, pbe_seqn'
                 data_at_exec=-1, current_exec_param=-1, put_data=0
                 currTuple=-1, current_col=-1, lobj_fd=-1
                 maxRows=0, rowset_size=1, keyset_size=0, cursor_type=0,
scroll_concurrency=1
                 cursor_name='SQL_CUR03FE2118'
                 ----------------QResult Info
-------------------------------
                 fields=67014320, manual_tuples=0, backend_tuples=0,
tupleField=0, conn=0
                 fetch_count=0, num_total_rows=0, num_fields=0,
cursor='(NULL)'
                 message='ERROR:  parser: parse error at or near "."',
command='(NULL)', notice='(NULL)'
                 status=7, inTuples=0
CONN ERROR: func=SC_execute, desc='', errnum=110, errmsg='ERROR:  parser:
parse error at or near "."'
            ------------------------------------------------------------
            henv=66985752, conn=66992464, status=1, num_stmts=16
            sock=66985776, stmts=66985848, lobj_type=-999
            ---------------- Socket Info -------------------------------
            socket=508, reverse=0, errornumber=0, errormsg='(NULL)'
            buffer_in=67003432, buffer_out=67007536
            buffer_filled_in=1, buffer_filled_out=0, buffer_read_in=1



--
Atte: Lazaro Alonso Baca Marín

-------------------------------------------------
This mail sent through IMP: http://horde.org/imp/

pgsql-odbc by date:

Previous
From: mlw
Date:
Subject: Re: Connecting to PGSQL
Next
From: Lázaro Alonso Baca Marín
Date:
Subject: suscribe