[INTERFACES] MSAccess problem deleting rows

Hi all,

I am having trouble using M$Access on a PostgreSQL database using PostODBC.

My setup:

Linux kernel: 2.0.36
Linux dist: RedHat 5.0
PostgreSQL: 6.4.2
PostODBC: -> 06.40.0006
M$Access: 97

My main problem is to make M$Access use the primary (unique) key of my table
when I am deleting a single row from M$Access. This is what I do:

1) Link the table 'ut32loen' into a new and freshly opened M$Access database.
2) Open the table in "raw" Access (simply clicking on the Open button in the
database window of Access).
3) Selecting the first row of the table (by clicking in the left-most column,
the one not being a table column, selecting the hole row).
4) Pressing the 'delete' key on the keyboard.

This results in two different responses from Access:

1) Access claims that somebody else has changed the data, that I am trying
to delete, though *noone* else is on the database.

2) I get an error from the backend.

Re 1: In this case I have *not* checked 'Row versioning' in the ODBC Manager
setup of the data set name that I am using. For some reason it looks
like Access cannot figure out to use the unique index that exists on
the table, and which it accepted when I linked the table. (It didn't
ask for a unique key, as it does if none exists.) In stead Acccess
generates this awfull where clause using *all* columns for qualifying
the row. I suspect, it is because of rounding errors that it can't find
the row resulting in this stupid message from Access telling me
somebody else has modified the data !!??
The main problem is, however, that M$Access does not use *only* the
unique key column in the where clause.
This situation is logged in the file psqlodbc_42941.... below.

Re 2: Here I have checked the 'Row versioning' option. The where clause looks
a lot better, but I get this error from the backend:
errmsg='ERROR: There is more than one possible operator '='
for types 'xid' and 'int4'
You will have to retype this query using an explicit cast'
I am afraid that I can't cast anything since this was generated by the
M$ JetEngine.
This situation is logged in the file psqlodbc_42942.... below.

I have included the output from a small psql session showing the table
ut32loen and its contents, the .sql that I used for generating the table,
and the two log-files that I refered to above.

I have tried the same thing without having the 'serial' (sequencer) on
the 'id' column, without any luck.

Plese forgive me for not compressing and attaching these files, this
old mailer is not capable of doing attachments :-(.

Please help,

___________________________________________________________________________
/
_/ _/_/ / Leif Jensen (leif(at)danmos(dot)dk)
_/ _/ _/ /
_/ _/_/ _/_/_/ /
_/ _/ _/ _/ _/ / Linux 2.0.36, gcc 2.7.2, wxWin 1.68c
_/ _/ _/_/ _/ _/ /
_/ _/ _/ _/ _/ /
_/_/_/_/ _/_/ _/_/ _/ / (and Windows 95 :-(
___________________________________________________________________________

---- psql.out: -------------------------------------------------------------------------------

>\d ut32loen

Table = ut32loen
+----------------------------------+----------------------------------+-------+
| Field | Type | Length|
+----------------------------------+----------------------------------+-------+
| id | int4 not null default nextval('u | 4 |
| beregnnr | int4 | 4 |
| stempling | int4 | 4 |
| stemplingstype | int4 | 4 |
| beregndato | date | 4 |
| startdato | date | 4 |
| enddato | date | 4 |
| medarbejder | varchar() | 50 |
| periodeskema | varchar() | 50 |
| kommettid | varchar() | 50 |
| gaaettid | varchar() | 50 |
| normtimer | float8 | 8 |
| pausetimer | float8 | 8 |
| tillaegtimer | float8 | 8 |
| flextimer | float8 | 8 |
| akkordtimer | float8 | 8 |
| fravaertimer | float8 | 8 |
| varseltimer | float8 | 8 |
| bonustimer | float8 | 8 |
| beskrivelse | varchar() | 50 |
| loensats | varchar() | 50 |
| flexkrpar | float8 | 8 |
| flextimerpar | float8 | 8 |
| funktionaerloen | float8 | 8 |
+----------------------------------+----------------------------------+-------+
Index: ut32loen_pkey

>select * from ut32loen;
id|beregnnr|stempling|stemplingstype|beregndato| startdato| enddato|medarbejder|periodeskema|kommettid|gaaettid| normtimer|pausetimer|tillaegtimer| flextimer|akkordtimer|fravaertimer|varseltimer|bonustimer|beskrivelse|loensats|flexkrpar|flextimerpar|funktionaerloen
--+--------+---------+--------------+----------+----------+----------+-----------+------------+---------+--------+----------------+----------+------------+------------------+-----------+------------+-----------+----------+-----------+--------+---------+------------+---------------
27| 19| 0| 0|05-07-1999|04-12-1999|04-12-1999| 87|No |00:00:00 |00:00:00| 0| 0| 0|-0.550000000046566| 0| 0| 0| 0|Flex |No | 0| 0| 0
28| 19| 3413| 1|05-07-1999|04-12-1999|04-12-1999| 87|No |09:07:11 |16:36:36|6.94999999995343| 0| 0| 0| 0| 0| 0| 0|Normtimer |Ln1 | 0| 0| 0
(2 rows)

>\q
----------------------------------------------------------------------------------------------

---- ut32loen.sql: ---------------------------------------------------------------------------

CREATE TABLE "ut32loen" (
"id" int4 DEFAULT nextval('ut32loen_id_seq') NOT NULL,
"beregnnr" int4,
"stempling" int4,
"stemplingstype" int4,
"beregndato" date,
"startdato" date,
"enddato" date,
"medarbejder" character varying(50),
"periodeskema" character varying(50),
"kommettid" character varying(50),
"gaaettid" character varying(50),
"normtimer" float8,
"pausetimer" float8,
"tillaegtimer" float8,
"flextimer" float8,
"akkordtimer" float8,
"fravaertimer" float8,
"varseltimer" float8,
"bonustimer" float8,
"beskrivelse" character varying(50),
"loensats" character varying(50),
"flexkrpar" float8,
"flextimerpar" float8,
"funktionaerloen" float8);
COPY "ut32loen" FROM stdin;
27 19 0 0 05-07-1999 04-12-1999 04-12-1999 87 No 00:00:00 00:00:00 0 0 0 -0.550000000046566 0 0 0 0 Flex No 0 0 0
28 19 3413 1 05-07-1999 04-12-1999 04-12-1999 87 No 09:07:11 16:36:36 6.94999999995343 0 0 0 0 0 0 0 Normtimer Ln1 0 0 0
\.
CREATE UNIQUE INDEX "ut32loen_pkey" on "ut32loen" using btree ( "id" "int4_ops" );
----------------------------------------------------------------------------------------------

---- psqlodbc_42941....: ----------------------------------------------------------

conn=80021628, SQLDriverConnect( in)='DSN=ut32_be_p;', fDriverCompletion=1
DSN info: DSN='ut32_be_p',server='ljserv',port='5432',dbase='ut32_be_i',user='cdsinfo',passwd='******'
readonly='0',protocol='6.4',showoid='1',fakeoidindex='0',showsystable='1'
conn_settings=''
translation_dll='',translation_option=''
Global Options: Version='06.40.0006', fetch=100, socket=4096, unknown_sizes=0, max_varchar_size=254, max_longvarchar_size=8190
disable_optimizer=1, ksqo=1, unique_index=1, use_declarefetch=1
text_as_longvarchar=1, unknowns_as_longvarchar=0, bools_as_char=1
extra_systable_prefixes='dd_;', conn_settings=''
conn=80021628, query=' '
conn=80021628, query='set DateStyle to 'ISO''
conn=80021628, query='set geqo to 'OFF''
conn=80021628, query='set ksqo to 'ON''
conn=80021628, query='BEGIN'
conn=80021628, query='declare SQL_CUR04C5413C cursor for select oid from pg_type where typname='lo''
conn=80021628, query='fetch 100 in SQL_CUR04C5413C'
[ fetched 0 rows ]
conn=80021628, query='close SQL_CUR04C5413C'
conn=80021628, query='END'
conn=80021628, SQLDriverConnect(out)='DSN=ut32_be_p;DATABASE=ut32_be_i;SERVER=ljserv;PORT=5432;UID=cdsinfo;PWD=******;READONLY=0;PROTOCOL=6.4;FAKEOIDINDEX=0;SHOWOIDCOLUMN=1;ROWVERSIONING=0;SHOWSYSTEMTABLES=1;CONNSETTINGS='
conn=80021628, query='BEGIN'
conn=80021628, query='declare SQL_CUR04C5413C cursor for SELECT Config, nValue FROM MSysConf'
ERROR from backend during send_query: 'ERROR: msysconf: Table does not exist.'
conn=80021628, query='ABORT'
STATEMENT ERROR: func=SC_execute, desc='', errnum=1, errmsg='Error while executing the query'
------------------------------------------------------------
hdbc=80021628, stmt=80036156, result=0
manual_result=0, prepare=0, internal=0
bindings=0, bindings_allocated=0
parameters=0, parameters_allocated=0
statement_type=0, statement='SELECT Config, nValue FROM MSysConf'
stmt_with_params='declare SQL_CUR04C5413C cursor for SELECT Config, nValue FROM MSysConf'
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_CUR04C5413C'
----------------QResult Info -------------------------------
CONN ERROR: func=SC_execute, desc='', errnum=110, errmsg='ERROR: msysconf: Table does not exist.'
------------------------------------------------------------
henv=81068164, conn=80021628, status=1, num_stmts=16
sock=81068180, stmts=81068220, lobj_type=-999
---------------- Socket Info -------------------------------
socket=61, reverse=0, errornumber=0, errormsg='(null)'
buffer_in=80027956, buffer_out=80032056
buffer_filled_in=3, buffer_filled_out=0, buffer_read_in=2
conn=80021628, query='BEGIN'
conn=80021628, query='declare SQL_CUR04C64208 cursor for select relname, usename, relhasrules from pg_class, pg_user where relkind = 'r' and relname !~ '^xinv[0-9]+' and int4out(usesysid) = int4out(relowner)order by relname'
conn=80021628, query='fetch 100 in SQL_CUR04C64208'
[ fetched 100 rows ]
conn=80021628, query='fetch 100 in SQL_CUR04C64208'
[ fetched 21 rows ]
conn=80021628, query='close SQL_CUR04C64208'
conn=80021628, query='END'
conn=80021628, query='BEGIN'
conn=80021628, query='declare SQL_CUR04C64208 cursor for select u.usename, c.relname, a.attname, a.atttypid,t.typname, a.attnum, a.attlen, a.atttypmod, a.attnotnull from pg_user u, pg_class c, pg_attribute a, pg_type t where int4out(u.usesysid) = int4out(c.relowner) and c.oid= a.attrelid and a.atttypid = t.oid and (a.attnum > 0) and c.relname like 'ut32loen' order by attnum'
conn=80021628, query='fetch 100 in SQL_CUR04C64208'
[ fetched 24 rows ]
conn=80021628, query='close SQL_CUR04C64208'
conn=80021628, query='END'
conn=80021628, query='BEGIN'
conn=80021628, query='declare SQL_CUR04C7A444 cursor for select u.usename, c.relname, a.attname, a.atttypid,t.typname, a.attnum, a.attlen, a.atttypmod, a.attnotnull from pg_user u, pg_class c, pg_attribute a, pg_type t where int4out(u.usesysid) = int4out(c.relowner) and c.oid= a.attrelid and a.atttypid = t.oid and (a.attnum > 0) and c.relname like 'ut32loen' order by attnum'
conn=80021628, query='fetch 100 in SQL_CUR04C7A444'
[ fetched 24 rows ]
conn=80021628, query='close SQL_CUR04C7A444'
conn=80021628, query='END'
conn=80021628, query='BEGIN'
conn=80021628, query='declare SQL_CUR04C64208 cursor for select c.relname, i.indkey, i.indisunique, i.indisclustered from pg_index i, pg_class c, pg_class d where c.oid = i.indexrelid and d.relname = 'ut32loen' and d.oid = i.indrelid'
conn=80021628, query='fetch 100 in SQL_CUR04C64208'
[ fetched 1 rows ]
conn=80021628, query='close SQL_CUR04C64208'
conn=80021628, query='END'
conn=80021628, query='BEGIN'
conn=80021628, query='declare SQL_CUR04C7A444 cursor for SELECT "ut32loen"."id" FROM "ut32loen" '
conn=80021628, query='fetch 100 in SQL_CUR04C7A444'
[ fetched 2 rows ]
conn=80021628, query='close SQL_CUR04C7A444'
conn=80021628, query='END'
conn=80021628, query='BEGIN'
conn=80021628, query='declare SQL_CUR04C7A444 cursor for SELECT "oid","id","beregnnr","stempling","stemplingstype","beregndato","startdato","enddato","medarbejder","periodeskema","kommettid","gaaettid","normtimer","pausetimer","tillaegtimer","flextimer","akkordtimer","fravaertimer","varseltimer","bonustimer","beskrivelse","loensats","flexkrpar","flextimerpar","funktionaerloen" FROM "ut32loen" WHERE "id" = 27 OR "id" = 28 OR "id" = 28 OR "id" = 28 OR "id" = 28 OR "id" = 28 OR "id" = 28 OR "id" = 28 OR "id" = 28 OR "id" = 28'
conn=80021628, query='fetch 100 in SQL_CUR04C7A444'
[ fetched 2 rows ]
conn=80021628, query='close SQL_CUR04C7A444'
conn=80021628, query='END'
conn=80021628, query='BEGIN'
conn=80021628, query='declare SQL_CUR04C5413C cursor for SELECT "oid","id","beregnnr","stempling","stemplingstype","beregndato","startdato","enddato","medarbejder","periodeskema","kommettid","gaaettid","normtimer","pausetimer","tillaegtimer","flextimer","akkordtimer","fravaertimer","varseltimer","bonustimer","beskrivelse","loensats","flexkrpar","flextimerpar","funktionaerloen" FROM "ut32loen" WHERE "id" = 27'
conn=80021628, query='fetch 100 in SQL_CUR04C5413C'
[ fetched 1 rows ]
conn=80021628, query='close SQL_CUR04C5413C'
conn=80021628, query='END'
conn=80021628, query='BEGIN'
conn=80021628, query='DELETE FROM "ut32loen" WHERE "id" = 27 AND "oid" = 199520 AND "beregnnr" = 19 AND "stempling" = 0 AND "stemplingstype" = 0 AND "beregndato" = '1999-05-07' AND "startdato" = '1999-04-12' AND "enddato" = '1999-04-12' AND "medarbejder" = '87' AND "periodeskema" = 'No' AND "kommettid" = '00:00:00' AND "gaaettid" = '00:00:00' AND "normtimer" = 0.000000 AND "pausetimer" = 0.000000 AND "tillaegtimer" = 0.000000 AND "flextimer" = -0.550000 AND "akkordtimer" = 0.000000 AND "fravaertimer" = 0.000000 AND "varseltimer" = 0.000000 AND "bonustimer" = 0.000000 AND "beskrivelse" = 'Flex' AND "loensats" = 'No' AND "flexkrpar" = 0.000000 AND "flextimerpar" = 0.000000 AND "funktionaerloen" = 0.000000'
conn=80021628, query='COMMIT'
conn=80021628, SQLDisconnect
----------------------------------------------------------------------------------------------

---- psqlodbc_42942.....: --------------------------------------------------------------------

conn=80021628, SQLDriverConnect( in)='DSN=ut32_be_p;', fDriverCompletion=1
DSN info: DSN='ut32_be_p',server='ljserv',port='5432',dbase='ut32_be_i',user='cdsinfo',passwd='******'
readonly='0',protocol='6.4',showoid='1',fakeoidindex='0',showsystable='1'
conn_settings=''
translation_dll='',translation_option=''
Global Options: Version='06.40.0006', fetch=100, socket=4096, unknown_sizes=0, max_varchar_size=254, max_longvarchar_size=8190
disable_optimizer=1, ksqo=1, unique_index=1, use_declarefetch=1
text_as_longvarchar=1, unknowns_as_longvarchar=0, bools_as_char=1
extra_systable_prefixes='dd_;', conn_settings=''
conn=80021628, query=' '
conn=80021628, query='set DateStyle to 'ISO''
conn=80021628, query='set geqo to 'OFF''
conn=80021628, query='set ksqo to 'ON''
conn=80021628, query='BEGIN'
conn=80021628, query='declare SQL_CUR04C5413C cursor for select oid from pg_type where typname='lo''
conn=80021628, query='fetch 100 in SQL_CUR04C5413C'
[ fetched 0 rows ]
conn=80021628, query='close SQL_CUR04C5413C'
conn=80021628, query='END'
conn=80021628, SQLDriverConnect(out)='DSN=ut32_be_p;DATABASE=ut32_be_i;SERVER=ljserv;PORT=5432;UID=cdsinfo;PWD=******;READONLY=0;PROTOCOL=6.4;FAKEOIDINDEX=0;SHOWOIDCOLUMN=1;ROWVERSIONING=1;SHOWSYSTEMTABLES=1;CONNSETTINGS='
conn=80021628, query='BEGIN'
conn=80021628, query='declare SQL_CUR04C5413C cursor for SELECT Config, nValue FROM MSysConf'
ERROR from backend during send_query: 'ERROR: msysconf: Table does not exist.'
conn=80021628, query='ABORT'
STATEMENT ERROR: func=SC_execute, desc='', errnum=1, errmsg='Error while executing the query'
------------------------------------------------------------
hdbc=80021628, stmt=80036156, result=0
manual_result=0, prepare=0, internal=0
bindings=0, bindings_allocated=0
parameters=0, parameters_allocated=0
statement_type=0, statement='SELECT Config, nValue FROM MSysConf'
stmt_with_params='declare SQL_CUR04C5413C cursor for SELECT Config, nValue FROM MSysConf'
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_CUR04C5413C'
----------------QResult Info -------------------------------
CONN ERROR: func=SC_execute, desc='', errnum=110, errmsg='ERROR: msysconf: Table does not exist.'
------------------------------------------------------------
henv=81068164, conn=80021628, status=1, num_stmts=16
sock=81068180, stmts=81068220, lobj_type=-999
---------------- Socket Info -------------------------------
socket=61, reverse=0, errornumber=0, errormsg='(null)'
buffer_in=80027956, buffer_out=80032056
buffer_filled_in=3, buffer_filled_out=0, buffer_read_in=2
conn=80021628, query='BEGIN'
conn=80021628, query='declare SQL_CUR04C64208 cursor for select relname, usename, relhasrules from pg_class, pg_user where relkind = 'r' and relname !~ '^xinv[0-9]+' and int4out(usesysid) = int4out(relowner)order by relname'
conn=80021628, query='fetch 100 in SQL_CUR04C64208'
[ fetched 100 rows ]
conn=80021628, query='fetch 100 in SQL_CUR04C64208'
[ fetched 21 rows ]
conn=80021628, query='close SQL_CUR04C64208'
conn=80021628, query='END'
conn=80021628, query='BEGIN'
conn=80021628, query='declare SQL_CUR04C64208 cursor for select u.usename, c.relname, a.attname, a.atttypid,t.typname, a.attnum, a.attlen, a.atttypmod, a.attnotnull from pg_user u, pg_class c, pg_attribute a, pg_type t where int4out(u.usesysid) = int4out(c.relowner) and c.oid= a.attrelid and a.atttypid = t.oid and (a.attnum > 0) and c.relname like 'ut32loen' order by attnum'
conn=80021628, query='fetch 100 in SQL_CUR04C64208'
[ fetched 24 rows ]
conn=80021628, query='close SQL_CUR04C64208'
conn=80021628, query='END'
conn=80021628, query='BEGIN'
conn=80021628, query='declare SQL_CUR04C7A5A0 cursor for select u.usename, c.relname, a.attname, a.atttypid,t.typname, a.attnum, a.attlen, a.atttypmod, a.attnotnull from pg_user u, pg_class c, pg_attribute a, pg_type t where int4out(u.usesysid) = int4out(c.relowner) and c.oid= a.attrelid and a.atttypid = t.oid and (a.attnum > 0) and c.relname like 'ut32loen' order by attnum'
conn=80021628, query='fetch 100 in SQL_CUR04C7A5A0'
[ fetched 24 rows ]
conn=80021628, query='close SQL_CUR04C7A5A0'
conn=80021628, query='END'
conn=80021628, query='BEGIN'
conn=80021628, query='declare SQL_CUR04C64208 cursor for select c.relname, i.indkey, i.indisunique, i.indisclustered from pg_index i, pg_class c, pg_class d where c.oid = i.indexrelid and d.relname = 'ut32loen' and d.oid = i.indrelid'
conn=80021628, query='fetch 100 in SQL_CUR04C64208'
[ fetched 1 rows ]
conn=80021628, query='close SQL_CUR04C64208'
conn=80021628, query='END'
conn=80021628, query='BEGIN'
conn=80021628, query='declare SQL_CUR04C7A5A0 cursor for SELECT "ut32loen"."id" FROM "ut32loen" '
conn=80021628, query='fetch 100 in SQL_CUR04C7A5A0'
[ fetched 2 rows ]
conn=80021628, query='close SQL_CUR04C7A5A0'
conn=80021628, query='END'
conn=80021628, query='BEGIN'
conn=80021628, query='declare SQL_CUR04C7A5A0 cursor for SELECT "oid","id","beregnnr","stempling","stemplingstype","beregndato","startdato","enddato","medarbejder","periodeskema","kommettid","gaaettid","normtimer","pausetimer","tillaegtimer","flextimer","akkordtimer","fravaertimer","varseltimer","bonustimer","beskrivelse","loensats","flexkrpar","flextimerpar","funktionaerloen","xmin" FROM "ut32loen" WHERE "id" = 27 OR "id" = 28 OR "id" = 28 OR "id" = 28 OR "id" = 28 OR "id" = 28 OR "id" = 28 OR "id" = 28 OR "id" = 28 OR "id" = 28'
conn=80021628, query='fetch 100 in SQL_CUR04C7A5A0'
[ fetched 2 rows ]
conn=80021628, query='close SQL_CUR04C7A5A0'
conn=80021628, query='END'
conn=80021628, query='BEGIN'
conn=80021628, query='declare SQL_CUR04C5413C cursor for SELECT "oid","id","beregnnr","stempling","stemplingstype","beregndato","startdato","enddato","medarbejder","periodeskema","kommettid","gaaettid","normtimer","pausetimer","tillaegtimer","flextimer","akkordtimer","fravaertimer","varseltimer","bonustimer","beskrivelse","loensats","flexkrpar","flextimerpar","funktionaerloen","xmin" FROM "ut32loen" WHERE "id" = 27'
conn=80021628, query='fetch 100 in SQL_CUR04C5413C'
[ fetched 1 rows ]
conn=80021628, query='close SQL_CUR04C5413C'
conn=80021628, query='END'
conn=80021628, query='BEGIN'
conn=80021628, query='DELETE FROM "ut32loen" WHERE "id" = 27 AND "xmin" = 115514'
ERROR from backend during send_query: 'ERROR: There is more than one possible operator '=' for types 'xid' and 'int4'
You will have to retype this query using an explicit cast'
conn=80021628, query='ABORT'
STATEMENT ERROR: func=SC_execute, desc='', errnum=1, errmsg='Error while executing the query'
------------------------------------------------------------
hdbc=80021628, stmt=80259088, result=0
manual_result=0, prepare=0, internal=0
bindings=0, bindings_allocated=0
parameters=80168644, parameters_allocated=2
statement_type=3, statement='DELETE FROM "ut32loen" WHERE "id" = ? AND "xmin" = ?'
stmt_with_params='DELETE FROM "ut32loen" WHERE "id" = 27 AND "xmin" = 115514'
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_CUR04C8A810'
----------------QResult Info -------------------------------
CONN ERROR: func=SC_execute, desc='', errnum=110, errmsg='ERROR: There is more than one possible operator '=' for types 'xid' and 'int4'
You will have to retype this query using an explicit cast'
------------------------------------------------------------
henv=81068164, conn=80021628, status=1, num_stmts=16
sock=81068180, stmts=81068220, lobj_type=-999
---------------- Socket Info -------------------------------
socket=61, reverse=0, errornumber=0, errormsg='(null)'
buffer_in=80027956, buffer_out=80032056
buffer_filled_in=3, buffer_filled_out=0, buffer_read_in=2
conn=80021628, SQLDisconnect
----------------------------------------------------------------------------------------------