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