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
