Hey Glen, I can confirm that this is working for me to. As soon as I set the size, I get a valid result instead of an error message.
I'll update the bugreport in Bugzilla. Thanks, /daniel -------- Original-Nachricht -------- Datum: Tue, 12 Dec 2006 14:29:05 +0000 Von: Glen Ford <[EMAIL PROTECTED]> An: Adam Tauno Williams <[EMAIL PROTECTED]> Betreff: Re: [Mono-list] Informix and ODBC > > FYI - we got parameters working by specifying size, if you leave the > provider to do it fails, but supplying a size works. > > Also found that you cannot return NULL's on (x)VARCHAR and TEXT fields > and have to use nvl to convert in SQL to an alternative value. > > > > Regards, > > > Glen > > > Adam Tauno Williams wrote: > >> Yes we are aware of the parameter issue. At the moment we are not > >> using parameters. > >> The biggest problem for us at the moment is Unicode characters - one > >> character works but as soon as a second is added to a statement it > >> generates an exception, and looking at the ODBC code it says it doesn't > >> support it :( > >> > > > > Ugh, the Mono ODBC provider doesn't do so many things.... > > > > We are also an Informix/LINUX shop; currently we are getting by using > > the ODBC driver but it isn't very pretty. > > > > Anyone been able to do anything with BLOBs on Informix via ODBC? > > > > > >> We cannot run under Windows as our env is Linux, we have been running > >> under Mono for several months but now have had to move from Postgres to > >> Informix hence the need for ODBC. > >> > > > > I hear DB2 is nice. :) > > > > _______________________________________________ > > Mono-list maillist - [email protected] > > http://lists.ximian.com/mailman/listinfo/mono-list > > > > > -- > > ------------------------------------------------------------------------- > > Glen Ford > Infrastructure Software Development Manager > SPINVOX LTD > > ------------------------------------------------------------------------- > > t: +44 (0)20 7965 2000 > f: +44 (0)20 7965 2001 > e: [EMAIL PROTECTED] > w: www.spinvox.com > > ------------------------------------------------------------------------- > > ** SPINVOX: AWARD WINNING PATENTED TECHNOLOGY ** > 'Science & Technology Entrepreneur of the Year 2006' - Ernst & Young > Entrepreneur of the Year Awards > 'Biggest Impact of Mobile Messaging 2006' - Mobile Messaging Awards > 'Red Herring 100 Europe Award 2006' - Most promising firms driving the > future of technology > 'Mobile Innovation Award 2006' - 3GSM World Congress > > Go to www.spinvox.com/news/awards to find out more. > > This electronic message and any attachments are intended solely for the > named addressee(s). Any other recipient should be aware that its contents may > be legally privileged and/or confidential and that its disclosure, copying > or distribution may be unlawful. Unless you are a named addressee, please > delete this message and immediately notify the sender. SpinVox has taken > steps to prevent the transmission of computer viruses with electronic mail, > but the responsibility for screening incoming messages and the risk of such > transmission and its consequences lies with the recipient. Any views > expressed in, or files attached to, this message are those of the individual > sender, unless stated otherwise. SpinVox can not guarantee the integrity of > this message across the Internet. SpinVox shall (will) not therefore be liable > for the message if modified. > -- "Ein Herz für Kinder" - Ihre Spende hilft! Aktion: www.deutschlandsegelt.de Unser Dankeschön: Ihr Name auf dem Segel der 1. deutschen America's Cup-Yacht! _______________________________________________ Mono-list maillist - [email protected] http://lists.ximian.com/mailman/listinfo/mono-list
