ADO VB can't read Informix Interval Year to Month fields
Posted in 2000
Paul McLaughlin — — source: Informix-list mailing list archive (1991-1998)
Hi all, I am trying to connect up Informix DS 7.30.UC10 using Informix Client SDK and the driver { Informix 3.30 32 BIT } with ADO2.0 and VB6. I can connect and retrieve data ok, but I cannot read Interval Year to Month fields. I have set up a stored procedure to bring the data back as: a String, an Integer Years and an Integer Months Value. This works fine. But the field is quite important and I don't want to have to call a stored procedure every time I need to refer to it or set it. Anyone know of how I can get the driver to bring back the data I need? Is there an option I need to set or something in registry that I need to fiddle with? Any help would be greatly appreciated. Paul McLaughlin