Knowledge Base
smartDBforms.NET for ASP.NET 2
 
Home/Support/
 
 
Knowledge Base Forum
Testimonials
It’s really refreshing to use. Looking at codegen products that are way overkill and generate source code that’s not maintainable - your product rocks.


I have demoed several other products also, and none came close to yours. The simplicity, ease of use and user friendliness were impeccable.
William Joshua
Madison County Schools


Thanks to smartDBforms.NET I am able to save lots of time and make even better websites. I am looking forward to use this tool to help me build websites based on databases.
Anton Beerens
www.blauwwit81.nl


We are really impressed with smartDBforms.NET and there is nothing else on the market as good.
Andy Jones
Make I.T. Simple
www.makeitsimple.info
Search knowledge base:
Main > smartDBforms.NET

PRB: 'Incorrect time value' error when updating or inserting TIME columns with MySQL ODBC driver
Saturday, 29 November 2008
You could receive the following error - [MySQL][ODBC 5.1 Driver][mysqld-5.0.51a-community-nt-log]Incorrect time value: '11:12:34''11:12:3' for column at row 1, when you are using smartDBforms.NET with MySQL and ODBC driver and you edit or create a new record, which contains columns of type TIME

SYMPTOMS

You could receive the following error - [MySQL][ODBC 5.1 Driver][mysqld-5.0.51a-community-nt-log]Incorrect time value: '11:12:34''11:12:3' for column at row 1, when you are using smartDBforms.NET with MySQL and ODBC driver and you edit or create a new record, which contains columns of type TIME

CAUSE

MySQL ODBC driver fails to properly convert the provided .NET TimeSpan value to the native MySQL TIME value.

RESOLUTION

The problem has been fixed in MySQL ODBC driver version 5.1.5. This problem is related to the following MySQL ODBC driver bug - ODBC TIMESTAMP string format not handled properly by ODBC driver.

APPLIES TO

  • smartDBforms.NET 2.2 and later( MySQL is not supported in the previous versions ).
  • MySQL with MySQL ODBC Driver 
Page Options: format for printing  Format for Printer

Copyright 2006-2011 Adillis Terms Of Use Feedback Contact Us