Message-ID: <002301bef551$59e21f20$1ac8a8c0@javier>
From: =?Windows-1252?B?SmF2aWVyIFnh8WV6?= <javier@cibal.es>
To: <pgsql-interfaces@postgreSQL.org>
Subject: Problems with psqlodbc 
Date: Thu, 2 Sep 1999 16:42:14 +0200
MIME-Version: 1.0
Content-Type: text/plain;
	charset="Windows-1252"
Content-Transfer-Encoding: 7bit


I am using PostgreSQL 6,5,1, psqlODBC 6,40,00,06 and BDE 5.01.
I am having problems when doing consultations on great tables from Delphi
4.03 if I have activated in the PostODBC " Use/declare fetch ".

I have been doing tests from Borland SQL Explorer and are things that I do
not understand.

If I put this:

declare mycursor cursor for SELECT * FROM personas

fetch 100 in mycursor

it appears to me the error:

Could not begin a transaction;
Unexpected protocol character from backend (send_query)

If I do it from psql works correctly and it does not leave error reason why
it thinks that the problem this about psqlODBC.

Log of the PostODBC is this:

DSN info:
DSN='PG_Gesdohc',server='cibalix',port='5432',dbase='gesdoc',user='javier',p
asswd=''

readonly='0',protocol='6.4',showoid='0',fakeoidindex='0',showsystable='0'
          conn_settings=''
          translation_dll='',translation_option=''
conn = 57215100, SQLConnect(DSN='PG_Gesdohc', UID='gesdohc', PWD='')
Global Options: Version='06.40.0006', fetch=100, socket=4096,
unknown_sizes=2, max_varchar_size=254, max_longvarchar_size=4094
                disable_optimizer=0, ksqo=0, unique_index=0,
use_declarefetch=1
                text_as_longvarchar=0, unknowns_as_longvarchar=0,
bools_as_char=1
                extra_systable_prefixes='dd_;', conn_settings=''
conn=57215100, query=' '
conn=57215100, query='set DateStyle to 'ISO''
conn=57215100, query='BEGIN'
conn=57215100, query='declare SQL_CUR0369413C cursor for select oid from
pg_type where typname='lo''
conn=57215100, query='fetch 100 in SQL_CUR0369413C'
    [ fetched 0 rows ]
conn=57215100, query='close SQL_CUR0369413C'
conn=57215100, query='END'
conn=57215100, query='BEGIN'
conn=57215100, query='declare mycursor cursor for SELECT * FROM personas
'
conn=57215100, query='fetch 100 in mycursor
'
conn=57215100, query='ABORT'
STATEMENT ERROR: func=SC_execute, desc='', errnum=1, errmsg='Error while
executing the query'
                 -----------------------------------------------------------
-
                 hdbc=57215100, stmt=57229628, result=0
                 manual_result=0, prepare=0, internal=0
                 bindings=0, bindings_allocated=0
                 parameters=0, parameters_allocated=0
                 statement_type=-1, statement='fetch 100 in mycursor

'
                 stmt_with_params='fetch 100 in mycursor
'
                 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_CUR0369413C'
                 ----------------QResult
Info -------------------------------
CONN ERROR: func=SC_execute, desc='', errnum=106, errmsg='Unexpected
protocol character from backend (send_query)'
            ------------------------------------------------------------
            henv=58261636, conn=57215100, status=1, num_stmts=16
            sock=58261652, stmts=58261692, lobj_type=-999
            ---------------- Socket Info -------------------------------
            socket=204, reverse=0, errornumber=0, errormsg='(null)'
            buffer_in=57221428, buffer_out=57225528
            buffer_filled_in=4096, buffer_filled_out=0, buffer_read_in=12
conn=57215100, SQLDisconnect


Somebody something can explain me?.

Greetings,

Javi