[Mono-list] Informix and ODBC

[Daniel Freund]

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!