Problems with psqlodbc

From: Javier Yáñez <javier(at)cibal(dot)es>
To: <pgsql-interfaces(at)postgreSQL(dot)org>
Subject: Problems with psqlodbc
Date: 1999-09-02 14:42:14
Message-ID: 002301bef551$59e21f20$1ac8a8c0@javier
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-interfaces by date

  From Date Subject
Next Message Ken J. Wright 1999-09-02 14:50:25 Re: [INTERFACES] FPK Pascal and Postgres
Previous Message Thomas Lockhart 1999-09-02 14:21:59 Re: [INTERFACES] Link error from libpq++ on RedHat 6.0 and Postgres 6.5.1