Informix and ODBC and Business Objects --> troubles !!

Posted in 1999

Topics: Connectivity: ODBC / JDBC / .NET

Christophe CHUSSEAU — Tue, 9 Nov 1999 10:40:02 +0100 — source: Informix-list mailing list archive (1991-1998)

I have some troubles with the version of ODBC : Informix CLI SDK 3.30 2.30 TC1 for Windows95 and Informix SE 5.05. With Business Objects i can't create an object on a column with a type : INTERVAL HOUR TO TIME !! It was OK with Informix connect V7 ! Why ????? Christophe CHUSSEAU

↪ replying to Christophe CHUSSEAU

Art S. Kagel — Tue, 09 Nov 1999 14:01:13 -0500 — source: Informix-list mailing list archive (1991-1998)

Christophe CHUSSEAU wrote: > > I have some troubles with the version of ODBC : Informix CLI SDK 3.30 2.30 > TC1 for Windows95 > and Informix SE 5.05. > > With Business Objects i can't create an object on a column with a type : > INTERVAL HOUR TO TIME !! What does that mean? Valid Informix INTERVAL definitions are such as these: INTERVAL HOUR(4) TO HOUR INTERVAL HOUR TO MINUTE INTERVAL HOUR(2) TO SECOND INTERVAL HOUR(3) TO FRACTION(5) > It was OK with Informix connect V7 ! I doubt that. What was the database column's type? Art S. Kagel

↪ replying to Art S. Kagel

Christophe CHUSSEAU — Wed, 10 Nov 1999 09:48:27 +0100 — source: Informix-list mailing list archive (1991-1998)

you'r right it's not HOUR TO TIME but HOUR TO MINUTE and it's OK with Informix Connect V7 but i needed to use an odbc driver and I find the solution, we have to use INTERSOLV 3.11 32 BIT INFORMIX 9 odbc driver and NOT INFORMIX 3.30 32 BIT odbc driver ! Thank C. CHUSSEAU Art S. Kagel <kagel@bloomberg.net> a 'crit dans le message : 38286F79.46EA4A7B@bloomberg.net... > Christophe CHUSSEAU wrote: > > > > I have some troubles with the version of ODBC : Informix CLI SDK 3.30 2.30 > > TC1 for Windows95 > > and Informix SE 5.05. > > > > With Business Objects i can't create an object on a column with a type : > > INTERVAL HOUR TO TIME !! > > What does that mean? Valid Informix INTERVAL definitions are such as > these: > > INTERVAL HOUR(4) TO HOUR > INTERVAL HOUR TO MINUTE > INTERVAL HOUR(2) TO SECOND > INTERVAL HOUR(3) TO FRACTION(5) > > > It was OK with Informix connect V7 ! > > I doubt that. What was the database column's type? > > Art S. Kagel >