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