Received: from mail.ruhr.de (ns.ruhr.de [141.39.224.34])
	by hub.org (8.9.3/8.9.3) with SMTP id LAA53040
	for <pgsql-interfaces@postgreSQL.org>;
	Sun, 23 Jan 2000 11:57:13 -0500 (EST)
	(envelope-from hph@hphbbs.ruhr.de)
Received: (qmail 69843 invoked by alias); 23 Jan 2000 16:57:11 -0000
Received: from localhost (3786 bytes) by hphbbs.ruhr.de
	via sendmail with P:stdio/R:smart_host/T:uux
	(sender: <hph>) (ident <hph> using unix)
	id <m12CQFR-000XcTC@hphbbs.ruhr.de>
	for <pgsql-interfaces@postgreSQL.org>;
	Sun, 23 Jan 2000 17:52:21 +0100 (MET)
	(Smail-3.2.0.101 1997-Dec-17 #1 built 1998-May-27)
To: pgsql-interfaces@postgreSQL.org
Subject: Weird behavior of ODBC driver ...
From: hph@hphbbs.ruhr.de (H.P.Heidinger)
Date: 23 Jan 2000 17:52:21 +0100
In-Reply-To: Constantin Teodorescu's message of "Mon,
 17 Jan 2000 10:25:47 GMT"
Message-ID: <m3zotw7mt6.fsf@hphbbs.localnet>
Lines: 66
X-Mailer: Gnus v5.5/XEmacs 20.4 - "Emerald"

Hello community,

I ran into problems with a particular table (~340 rows/ ~20 coloums).

I access the table via ODBC from within MS-Access'97.
The query always crashes if the table is accessed. Here the excerpt from
the debug-log (originally it was a one-liner, that I broke to achieve a
better overlook): 

-------------------------- 8< snip, snap 8< --------------------------------
Jan 23 17:55:16 hphs5 logger: query: SELECT "oid","code","Adresse_falsch",
'#S_C_H#',                                              |
'#S_C_H#',                                              |
'#S_C_H#'<-- comma missing, astraid entry?              |
'#S_C_H#',                                              |
'#S_C_H#'<-- comma missing, astraid entry?              |  Count is 12 here
'#S_C_H#',                                              |  2 commas missing
'#S_C_H#'     , (some space here -- syntactically o.k.) |
'#S_C_H#',                                              |
'#S_C_H#',                                              |
'#S_C_H#',                                              |
'#S_C_H#',                                              |
'#S_C_H#',                                              |
"ibm_id","Anmerkung","Lieferant","CATIA","CATVDAFS","CATSTEP","R/3","CSI","Servi
ce alt","Service neu","Firmen_ID","Titel_ID",'#S_C_H#','#S_C_H#',"CATIA_ID","Las
tmailing_date","Lastmailing_action","Bearbeiter","Bearbeit_Datum","Auswahl"  FRO
M "Kontakte"  WHERE 
"oid" = 19495 OR                                        | 
"oid" = 19496 OR                                        | 
"oid" = 19497 OR                                        | 
"oid" = 19498 OR                                        | 
"oid" = 19499 OR                                        | Count is 10 here 
"oid" = 19500 OR                                        | 
"oid" = 19501 OR                                        | 
"oid" = 19502 OR                                        | 
"oid" = 19503 OR                                        | 
"oid" = 19504                                           | 
Jan 23 17:55:16 hphs5 logger: ERROR:  parser: parse error at or near "'" 
                                                                     ^^^
                                                        small wonder with
                                                        the missing commas!

Jan 23 17:55:16 hphs5 logger: AbortCurrentTransaction 
-------------------------- 8< snip, snap 8< -------------------------------- 

What are these '#S_C_H#' thingies? They cannot come from the ODBC driver
(at least `grep'ing thru the driver-code for "S_C_H" brought nothing up.)

Meanwhile I separated the database via a dump and restored in on another
machine with a fresh PGSQL installation (6.5.3nl) from RPMs (instead of my 
own compile of 6.5.3 under RH-Linux 5.2) -- but the result is exactly the 
same :-(

On the WingDog-client (a Toshiba-Notebook) I use Win'95 (B.1111) with 
Access'97 of Office'97pro. The ODBC driver is 6.40.0007.

Any ideas? 
(I've been banging my head against that for the entire weekend and ran out
of ideas now)

Best regards, Peter
-- 
#--------- H.P. Heidinger, Steeler Str. 121, 45138 Essen /Germany ----------#
# Tel: +49-201: 8903091 (ISDN)  # 287802 (voice) # 287803 (analog data/FAX)
# Mobil: +49-172-7462130 
# -------------------- MicroSoft Pollution Survivor -------------------------