Re: Informix SE/Esker/MS query

Posted in 1996

Chris Drauch — 24 May 1996 06:58:05 -0400 — source: Informix-list mailing list archive (1991-1998)

John Caperon wrote > >Trying to connect Excel 95 to Informix SE 5.01 on SCO ODT 3.0. I'm using >tun plus 8.01 from Esker as middleware. When I select "get external data" >from Excel, MS query fires up. After the connection, tables & fields >dialogues bingo up comes the data (except smallfloats ?), but when I >select "return data to Excel" the money (decimal 16,2?) data types are >returned as zero's. Other data type e.g. dates, integers, text etc. are >returned OK. Very frustrating! Anyone trying the same, or even any ideas? >Oh yes: tunodbc.ifx v 1.03a, tunodb32.dll v 8.0.1...Cheers Enable the server side debugging (-debug, -output & -output2 in param file) and see what the esker server side is doing - the debug file could help. You could try to contact Rich Revill <revill@esker.fr>, he is the guy for SCO/tunodbc. Could you reproduce this behaviour with other ODBC apps like access/vb? -- Chris Drauch ...................................................................... . c/o DRAUCH Ges.m.b.H. Tel. 43/ 3135/46387-0 . . Gewerbestrasse 5 Fax 43/ 3135/4638728 . . A-8071 Hausmannstaetten EMail cdr@xteam.co.at . ......................................................................