RE: Informix ODBC Driver Error.

Posted in 2008

Topics: Connectivity: ODBC / JDBC / .NET

Knox, Ernest — Wed, 13 Feb 2008 16:59:13 — source: IIUG Forums & Mailing Lists

Sorry about that. The error picture did not come through. Here is the error in writing: ------------------------------------------------------------------------ --------- Web Intelligence Query 1 - SubRptP Database error: [Informix][Informix ODBC Driver] [Informix]String to date conversion error. Contact your Business Objects administrator or Database supplier for more Informix. (Error: WIS 10901). ------------------------------------------------------------------------ --------- Thanks, ************************************** Ernie Knox Sears Holding Co. IT Database Administrator Specialist IT Service Management, Strategy & Architecture 3333 Beverly Rd., B4-266A Hoffman Estates, IL. 60179 Office: (847) 286-5735 Fax: (847) 645-3874 Pager: (800) 759-8352 Pin#: 7271042 Email: eknox@sears.com " It's always a great day to watch Football ! " ************************************** -----Original Message----- From: Knox, Ernest Sent: Wednesday, February 13, 2008 10:39 AM To: ids@iiug.org Subject: Informix ODBC Driver Error. Has anyone countered this error? It's going against a 7.30.UC3 instance. Thanks, ************************************** Ernie Knox Sears Holding Co. IT Database Administrator Specialist IT Service Management, Strategy & Architecture 3333 Beverly Rd., B4-266A Hoffman Estates, IL. 60179 Office: (847) 286-5735 Fax: (847) 645-3874 Pager: (800) 759-8352 Pin#: 7271042 Email: eknox@sears.com " It's always a great day to watch Football ! " **************************************

↪ replying to Knox, Ernest

Sheshnarayan Agrawal — Thu, 14 Feb 2008 04:14:56 — source: IIUG Forums & Mailing Lists

Based on the error message, I assume that you have date value stored in CHAR/VARCHAR column and you want to get the same in ODBC DATE structure (i.e. SQL_DATE_STRUCT). What's the date format in which value is stored in CHAR/VARCHAR column? What's the DBDATE variable set to in your application environment? In ODBC default DATE format is Y4MD- -Shesh "Knox, Ernest" <eknox@searshc.com> Sent by: ids-bounces@iiug.org 13/02/2008 22:29 Please respond to ids@iiug.org To ids@iiug.org cc Subject RE: Informix ODBC Driver Error. [11303] Sorry about that. The error picture did not come through. Here is the error in writing: ------------------------------------------------------------------------ --------- Web Intelligence Query 1 - SubRptP Database error: [Informix][Informix ODBC Driver] [Informix]String to date conversion error. Contact your Business Objects administrator or Database supplier for more Informix. (Error: WIS 10901). ------------------------------------------------------------------------ --------- Thanks, ************************************** Ernie Knox Sears Holding Co. IT Database Administrator Specialist IT Service Management, Strategy & Architecture 3333 Beverly Rd., B4-266A Hoffman Estates, IL. 60179 Office: (847) 286-5735 Fax: (847) 645-3874 Pager: (800) 759-8352 Pin#: 7271042 Email: eknox@sears.com " It's always a great day to watch Football ! " ************************************** -----Original Message----- From: Knox, Ernest Sent: Wednesday, February 13, 2008 10:39 AM To: ids@iiug.org Subject: Informix ODBC Driver Error. Has anyone countered this error? It's going against a 7.30.UC3 instance. Thanks, ************************************** Ernie Knox Sears Holding Co. IT Database Administrator Specialist IT Service Management, Strategy & Architecture 3333 Beverly Rd., B4-266A Hoffman Estates, IL. 60179 Office: (847) 286-5735 Fax: (847) 645-3874 Pager: (800) 759-8352 Pin#: 7271042 Email: eknox@sears.com " It's always a great day to watch Football ! " ************************************** ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum. See you at the IIUG Informix 2008 Conference The Power Conference for Informix Professionals April 27 - 30, 2008 Marriott Overland Park (Kansas City), Kansas http://www.iiug.org/conf Registration Now Open!!

↪ replying to Knox, Ernest

Chris Salch — Tue, 19 Feb 2008 21:05:17 — source: IIUG Forums & Mailing Lists

On Wed, 2008-02-13 at 11:59 -0500, Knox, Ernest wrote: > Sorry about that. The error picture did not come through. Here is the > error in writing: > > ------------------------------------------------------------------------ > --------- > > Web Intelligence > > Query 1 - SubRptP > > Database error: [Informix][Informix ODBC Driver] > > [Informix]String to date conversion error. > > Contact your Business Objects administrator or > > Database supplier for more Informix. (Error: WIS 10901). > > ------------------------------------------------------------------------ > --------- > > Thanks, > > ************************************** > > Ernie Knox > > Sears Holding Co. > > IT Database Administrator Specialist > > IT Service Management, Strategy & Architecture > > 3333 Beverly Rd., B4-266A > > Hoffman Estates, IL. 60179 > > Office: (847) 286-5735 > > Fax: (847) 645-3874 > > Pager: (800) 759-8352 Pin#: 7271042 > > Email: eknox@sears.com > > " It's always a great day to watch Football ! " > > ************************************** > > -----Original Message----- > From: Knox, Ernest > Sent: Wednesday, February 13, 2008 10:39 AM > To: ids@iiug.org > Subject: Informix ODBC Driver Error. > > Has anyone countered this error? It's going against a 7.30.UC3 > instance. > > Thanks, > > ************************************** > > Ernie Knox > > Sears Holding Co. > > IT Database Administrator Specialist > > IT Service Management, Strategy & Architecture > > 3333 Beverly Rd., B4-266A > > Hoffman Estates, IL. 60179 > > Office: (847) 286-5735 > > Fax: (847) 645-3874 > > Pager: (800) 759-8352 Pin#: 7271042 > > Email: eknox@sears.com > > " It's always a great day to watch Football ! " > > ************************************** > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > See you at the IIUG Informix 2008 Conference > The Power Conference for Informix Professionals > April 27 - 30, 2008 Marriott Overland Park (Kansas City), Kansas > http://www.iiug.org/conf > Registration Now Open!! What does your SQL look like? If you have string constant date values you may want to think about using MDY or equivalent. -- -------------------------------------------- Chris Salch Programmer/Analyst LeTourneau University