Thread: troubles with ODBC tables

troubles with ODBC tables

From

DI Hasenöhrl

Date:

27 March 2003, 07:33:05

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