Informix Interval values into a DataGrid

Discussion in 'ASP .Net' started by Dave Varley via .NET 247, Sep 1, 2004.

  1. I am trying to pull Interval information from an Informix SEdatabase on Unix and display it in a DataGrid in C# .NET. TheDataSet column mapping does not recognise the data typeinterval. I have tried forcing the data type to System.TimeSpanbut I get the following error message:-

    Unknown SQL type - 110.
    Description: An unhandled exception occurred during the executionof the current web request. Please review the stack trace formore information about the error and where it originated in thecode.

    Exception Details: System.ArgumentException: Unknown SQL type -110.

    This is a limitation of the ODBC driver for Informix. If I coulduse the OLE DB Provide or the .NET Provider I wouldn't have thisproblem as they recognise the Interval data type. However theOLE & .NET Providers don't work with my old version ofInformix.

    Informix will not let me CAST the output value as a string or anyother useful type, so I'm out of ideas. Can anyone help or isanyone having the same problem.


    --------------------------------
    From: Dave Varley

    -----------------------
    Posted by a user from .NET 247 (http://www.dotnet247.com/)

    <Id>khViiOPOL0+QkUnhKbCu6A==</Id>
    Dave Varley via .NET 247, Sep 1, 2004
    #1
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. BS
    Replies:
    3
    Views:
    2,036
    Alvin Bruney [MVP]
    Jun 17, 2004
  2. Christian Eriksson

    Problem loading DBD::Informix

    Christian Eriksson, Nov 23, 2003, in forum: Perl
    Replies:
    3
    Views:
    744
    Christian Eriksson
    Nov 24, 2003
  3. Boris Condarco

    Working with Informix's SPL

    Boris Condarco, Aug 25, 2003, in forum: ASP .Net
    Replies:
    0
    Views:
    383
    Boris Condarco
    Aug 25, 2003
  4. Patrick.O.Ige

    Informix OLEDB problem

    Patrick.O.Ige, Nov 9, 2005, in forum: ASP .Net
    Replies:
    3
    Views:
    3,217
    Patrick.O.Ige
    Nov 9, 2005
  5. busybee
    Replies:
    2
    Views:
    1,800
    busybee
    Feb 20, 2004
Loading...

Share This Page