Problems Using an old Informix Database

Toad Data Point & Toad Intelligence Central
1

Hello all

I am using TDA 3.0 and am connecting to an old Informix database via the Redbrick 5.02.04.03 driver.

The connection works fine, but I am having problems querying and viewing data. For example, a table with only 380 records displays as having more than 9 thousand records (it is showing 24 null records after every value).

Also, when doing a simple query like “select * from table” I get the following error messages:

System.ArgumentOutOfRangeException

Year, Month, and Day parameters describe an un-representable DateTime.

Stack Trace:

at System.DateTime.DateToTicks(Int32 year, Int32 month, Int32 day)

at Quest.Toad.NativeOdbc.UnManagedColumnDescriptor.GetBufferDataAsOdbcDate(UInt16 rowOffset)

at Quest.Toad.NativeOdbc.OdbcDataReader.GetValue(Int32 i)

at Quest.Toad.Odbc.OdbcToadConnection.ReadRow(IDataReader reader, FastTable datatable, FastReadOptions options, PrePostProcessHandler prePostProcessHandler)

at Quest.Toad.Db.ToadDataAdapter.InternalReadBackground()

Any ideas? Is the database/driver just too old to work with TDA 3.0?

Thanks in advance for the help.

2

We only support drivers that are compliant with ODBC 3.0. What API version does it support?