IBM webMethods Hybrid Integration

IBM webMethods Hybrid Integration

Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.

 View Only
Back to discussions
Expand all | Collapse all

AdapterException while INSERT Operation in SQL65Microsoft ODBC Driver Error 22008

  • 1.  AdapterException while INSERT Operation in SQL65Microsoft ODBC Driver Error 22008

    Posted Fri March 14, 2003 12:21 PM

    Server: Enterprise Server 5.1(OS Windows 2000 server)

    Adapter:
    I.
    Enterprise adapter 4.1(ODBC adapter)
    Adapter is installed in Windows NT 4.0 having MS SQL 6.5 server.

    II.
    Enterprise adapter 4.1(ODBC adapter)
    Adapter is installed in Windows 2000 server having MS SQL 2000 server.

    I am transferring Data from SQL 2000 to SQL6.5 server using Insert trigger.
    If a Record(in SQL 2000) does not have any null Date fields,INSERT OPERATION works fine in SQL6.5.

    But I am getting Adapter Exception during INSERT Operation, if the data has NULL Date objects in the Record.

    Specific Error: Microsoft ODBC Driver Error 22008.

    I want to know how can i handle NULL values for Date objects in Enterprise Integrator.

    Waiting for any TIPS


    #Integration-Server-and-ESB
    #Universal-Messaging-Broker
    #webMethods
    #broker


Related Content