[Mono-list] Informix and ODBC

[Glen Ford]

Hi Daniel,


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 :(

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.


Regards,


Glen




Daniel Freund wrote:
> Hi Glen,
>
> I ran into this issue about a year ago. My problem was (well, actually still is), that the ODBC does not deal with parameters. I issued a bug in bugzilla (http://bugzilla.ximian.com/show_bug.cgi?id=74917), but ODBC seems to be a low prio thing. I run my test cases every now and then with actual Mono versions, but as of Mono 1.2 it still fails.
>
> Maybe one of the System.Data-maintainers can give some statements about future plans regarding the ODBC stuff. The Mono website states that still some testing is required...
>
> For now I run my ASP.NET application under Windows using MS .Net and the Informix driver delivered with the Informix CSDK. I didn't find an affordable alternative yet.
>
> Several tests using the IBM Informix driver under Linux/Mono failed, because the driver uses several native CSDK/Windows DLLs.
>
> I issued a feature request to IBM asking for a fully managed Informix driver about a month ago. It seems they are working on it but it is loosely scheduled for mid 2007. As I have heard the driver will be fully managed but I'm not sure if it will work under Mono.
>
> Hope that helps,
>
> /daniel
>
>
> -------- Original-Nachricht --------
> Datum:  Wed, 06 Dec 2006 09:04:24 +0000
> Von: Glen Ford <glen.ford at spinvox.com>
> An: mono-list at lists.ximian.com
> Betreff:  [Mono-list] Informix and ODBC
>
>   
>> Hi, is anyone out there using Informix with the Mono ODBC Provider?
>>
>> We have hit a number of issues with the provider, and would like to find 
>> out if there is a later version available anywhere.
>>
>> Alternatively if anyone knows of a Native Provider that would be great.  
>> Informix only supply a .Net version which includes Native Windows
>> reliance.
>>
>>
>>
>> Thanks,
>>
>>
>> Glen
>> _______________________________________________
>> 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/20061206/3563ece4/attachment-0001.html