Problems with psqlodbc

Поиск
Список
Период
Сортировка
От Javier Yáñez
Тема Problems with psqlodbc
Дата
Msg-id 002301bef551$59e21f20$1ac8a8c0@javier
обсуждение исходный текст
Список pgsql-interfaces
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






В списке pgsql-interfaces по дате отправления:

Предыдущее
От: Thomas Lockhart
Дата:
Сообщение: Re: [INTERFACES] Link error from libpq++ on RedHat 6.0 and Postgres 6.5.1
Следующее
От: Denis Barbet
Дата:
Сообщение: [INTERFACES] sqlca error