Toad World® Forums

Problems Using an old Informix Database


Hello all

I am using TDA 3.0 and am connecting to an old Informix database via the Redbrick 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:


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.


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