recenlty I wanted to migrate my app from MySQL 3 to MySQL4.1.19, conector: MyODBC 3.51.06 into MyODBC 3.51.11-1win.
Now I have a problem with time values from my database. In a field I have the value '00:00:01'. When I retrieve this value in my app (via MyODBC) i get a null value. I don't want that null value, I vant my '00:00:01'.
Before the migration, I hadn't this problem ... everything worked fine. Is there a setting in MyODBC that I must check to solve this? If not, how can I solve this problem ... quick?
Please help me quick because it's a critical application for an airport.
Any help would be apreciated.
1. you attempt insert a time of '00:00:01' but odbc intercepts it and stores a null instead
2. you attempt insert a time of '00:00:01' but mysql stores it as null
3. you manage to insert a time of '00:00:01' but mysql displays it as null
4. you manage to insert a time of '00:00:01' but odbc intercepts it and displays it as null
let's start eliminating some possibilities, and see what we end up with