Skip site navigation (1) Skip section navigation (2)

ODBC

From: Lázaro Alonso <lazaro(at)matmor(dot)unam(dot)mx>
To: pgsql-odbc(at)postgresql(dot)org
Subject: ODBC
Date: 2002-09-04 20:41:09
Message-ID: 1031172069.3d766fe5a967a@gaspacho.matmor.unam.mx (view raw or flat)
Thread:
Lists: 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

Next:From: Marc BirkettDate: 2002-09-05 09:02:33
Subject: psqlODBC and MS-Access
Previous:From: Andrew SullivanDate: 2002-09-04 17:56:46
Subject: Re: [ODBC] ODBC Driver moved to GBorg ...

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group