[Mono-list] Informix and ODBC
Daniel Freund
lunkwill at gmx.net
Tue Dec 12 11:22:36 EST 2006
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 <glen.ford at spinvox.com>
An: Adam Tauno Williams <adam at morrison-ind.com>
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 - Mono-list at lists.ximian.com
> > 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: glen.ford at spinvox.com
> 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!
More information about the Mono-list
mailing list