mx.DateTime, mx.ODBC.Windows, and MS SQL Server - Fractional truncation error

[M.-A. Lemburg]

robin and jim wrote:
> 
> Has anyone seen this type of SQL error with mx.DateTime, mx.ODBC.Windows,
> and MS SQL Server?
> 
> import mx.DateTime
> 
> date_time_0 = mx.DateTime.GregorianDateTime (2001, 5, 14, 17, 12, 47.20)
> date_time_1 = mx.DateTime.GregorianDateTime (2001, 5, 14, 17, 13, 14.978)
> 
> date_time_0 can be inserted in a table containing an SQL DATETIME data type
> column.
> 
> date_time_1 can NOT be inserted in a table containing an SQL DATETIME data
> type column.
> The error message is:
> ('01004', 0, '[Microsoft][ODBC SQL Server Driver]Fractional truncation',
> 4479)

Looks like MS SQL Server's ODBC driver is being too careful again.
What you are seeing there is a SQL warning which mxODBC translates
into an exception.

One of the future mxODBC versions will replace the warning to exception
translation with a different error handling mechanism (e.g. a list
of messages which you can query by accessing an attribute .warnings),
but currently there's no way to work around this other than
by recompiling the package with -DDONT_REPORT_WARNINGS.
 
> Some details about the execution framework are:
> 
> Python 2.0
> mx.DateTime 2.0.0
> mx.ODBC 2.0.1
> MS SQL Server 2000
> MS Windows 2000
> 
> Thanks in advance for any suggestions.
> 
> --
> http://mail.python.org/mailman/listinfo/python-list

-- 
Marc-Andre Lemburg
______________________________________________________________________
Company & Consulting:                           http://www.egenix.com/
Python Software:                        http://www.lemburg.com/python/