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.

_______________________________________________
Mono-list maillist  -  [email protected]
http://lists.ximian.com/mailman/listinfo/mono-list

Reply via email to