From: Javier Yáñez <javier@cibal.es>
To: pgsql-interfaces@postgreSQL.org
Subject: Problems with psqlodbc
Date: Thu, 2 Sep 1999 16:42:14 +0200
Message-ID: <002301bef551$59e21f20$1ac8a8c0@javier> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: javier@cibal.es
Subject: Re: Problems with psqlodbc
In-Reply-To: <002301bef551$59e21f20$1ac8a8c0@javier>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox