Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2005
    Posts
    3

    Angry Unanswered: ERROR[HY000] Date conversion format must contain a month, day, and year component

    Hello together,

    I've got a problem connecting to my Informix Server via VB.NET.

    Calling con.open() a receive an Exception:

    "ERROR [HY000] [Informix .NET provider][Informix]Date conversion format must contain a month, day, and year component"

    If I print out the Environment DBDATE is set to "dd.mm.yyyy" ... any ideas?



    I am using ClientSDK 2.90 under Windows XP.
    Last edited by goth; 11-21-05 at 12:50.

  2. #2
    Join Date
    Apr 2004
    Location
    Brussels
    Posts
    57
    on aix we have DBDATE="MDY4/"
    this means mm/dd/yyyy

    I think your DBDATE should be set to "DMY4."
    try it,

    success
    yves
    Yves & Willy

  3. #3
    Join Date
    Nov 2005
    Posts
    3
    OMG ... thanx very much ... that's it!!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •