[Mono-list] Informix and ODBC

[Glen Ford]

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.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.ximian.com/pipermail/mono-list/attachments/20061212/405f270b/attachment.html