When I look up data from a database, this “not a legal oleaut date” exception occurs.
WriteDataReader or WriteDataTable in Bin2DataStreamer.
Is there a way to avoid this exception without fixing data?
DataAbstract 184.108.40.2067 , c# Winform.
Unfortunately there is no way to avoid this exception w/o fixing the data (* see below). The issue is that the streamer needs to convert the DateTime value to a double to write it to the stream. If the incoming
DateTime value doesn’t fit to the range that could be converted to a Double then it fails.
*There are 2 ways to fix the data:
- Fix the underlying data table data (this is not always possible)
- Wrap the data table on the Schema level:
2.1. Open the server’s .daSchema file
2.2. Go to the table containing bad data
2.3. Open its Statements node
2.4. Change its Statement type from
SQLand allow Schema Modeler to generate the SQL statement for you
2.5. Amend the SQL statement to return fixed datetime value
Hope that helps
Thank you for your answer.
If possible, I’d like the user to see it if they typed it incorrectly.
And when JsonDataStreamer or System.Runtime.Serialization.Formatters.Binary.BinaryFormatter was used, exception did not occur.
If I use this method, I would like to know which part of it is different from Bin2DataStreamer.
Quite expected as these 2 serializers use different ways of storing a
Bin2 serializer cannot handle DateTime values that are outside of the supported range (from
01/01/0100 up to