troubles with ODBC tables

From: DI Hasenöhrl <i(dot)hasenoehrl(at)aon(dot)at>
To: <pgsql-odbc(at)postgresql(dot)org>
Subject: troubles with ODBC tables
Date: 2003-03-27 09:30:10
Message-ID: 000c01c2f443$76e80ae0$01011eac@irina
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc


Hi all,

I use postgresql 7.1.3 with ODBC driver 7.1.0009 and MsAccess97 as frontend.
My database runs for 11/2 years without problems, but now I had to implement an activx element in order to use the functions of a barcode reader and now something mysterious happens.

Although no error occurs, my ODBC connection is sat back and I cann't find any hint in the log file.
Here is a part of the log file:

conn=151550676, query='SELECT a_nr,a_bez1,a_bez2,a_bez3,a_bez4,a_vol,a_gewicht,a_bruttoG,eh_bez,barcode FROM artikel INNER JOIN einheitbez ON artikel.eh_nr=einheitbez.eh_nr WHERE a_nr = '14001' AND sp_id = 'D';'
[ fetched 1 rows ]
conn=151550676, query='SELECT AP_Preis FROM artikelpreis WHERE pl_nr=3 AND a_nr = '14001';'
[ fetched 1 rows ]
conn=151487540, query='SELECT "allelager"."l_nr" FROM "allelager" '
STATEMENT ERROR: func=SC_execute, desc='', errnum=1, errmsg='Error while executing the query'
------------------------------------------------------------
hdbc=151487540, stmt=153064336, result=0
manual_result=0, prepare=0, internal=0
bindings=0, bindings_allocated=0
parameters=0, parameters_allocated=0
statement_type=0, statement='SELECT "allelager"."l_nr" FROM "allelager" '
stmt_with_params='SELECT "allelager"."l_nr" FROM "allelager" '
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_CUR091F9390'
----------------QResult Info -------------------------------
CONN ERROR: func=SC_execute, desc='', errnum=104, errmsg='Could not send Query to backend'
------------------------------------------------------------
henv=152587904, conn=151487540, status=1, num_stmts=16
sock=152588544, stmts=152588592, lobj_type=-999
---------------- Socket Info -------------------------------
socket=320, reverse=0, errornumber=6, errormsg='Could not flush socket buffer.'
buffer_in=151472932, buffer_out=151498456
buffer_filled_in=305, buffer_filled_out=0, buffer_read_in=305

Please, can someone give me a hint, what's happening in my database. What can I do to find the error? Shall I update my ODBC driver?

Thanks in advance
Irina


Browse pgsql-odbc by date

  From Date Subject
Next Message Mike Miller 2003-03-27 20:52:44 Re: Storing Binary Data
Previous Message Giuliano Gavazzi 2003-03-27 09:14:58 Re: Compiling with unixodbc support