troubles with ODBC tables
| От | DI Hasenöhrl | 
|---|---|
| Тема | troubles with ODBC tables | 
| Дата | |
| Msg-id | 000c01c2f443$76e80ae0$01011eac@irina обсуждение исходный текст | 
| Список | pgsql-odbc | 
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
 
		
	
В списке pgsql-odbc по дате отправления: