Discussion:
[Microsoft][SQL Server Native Client 10.0]Datetime field overflow
(too old to reply)
Grzesiekc
2009-12-09 15:20:43 UTC
Hello!

UPDATE ml_user SET last_upload_time = ? WHERE user_id = ?
E. 12/08 13:15:28. <1.5> [3]: Error: [-10002] ODBC: [Microsoft][SQL
Server Native Client 10.0]Datetime field overflow. Fractional second
precision exceeds the scale specified in the parameter binding. (ODBC State
= 22008, Native error code = 0, Column or parameter #1)

Mobilink: 9.0.2.3581

Works ok when odbc driver is [SQL Server] but doesn't work on ][SQL Server
Native Client 10.0]
Any ideas?
Reg Domaratzki [Sybase iAnywhere]
2009-12-09 15:41:25 UTC
Post by Grzesiekc
Hello!
UPDATE ml_user SET last_upload_time = ? WHERE user_id = ?
E. 12/08 13:15:28. <1.5> [3]: Error: [-10002] ODBC: [Microsoft][SQL
Server Native Client 10.0]Datetime field overflow. Fractional second
precision exceeds the scale specified in the parameter binding. (ODBC State
= 22008, Native error code = 0, Column or parameter #1)
Mobilink: 9.0.2.3581
Works ok when odbc driver is [SQL Server] but doesn't work on ][SQL Server
Native Client 10.0]
Any ideas?
What is the version of your back end SQL Server database?
--
Reg Domaratzki, Sybase iAnywhere Solutions
Please reply only to the newsgroup

Documentation : Exercise your WRITE @DocCommentXchange: DCX.sybase.com
SQL Anywhere Patches and EBFs : http://downloads.sybase.com/swd/base.do
-> Choose SQL Anywhere
-> Optionally set filter to "Display ALL platforms IN ALL MONTHS"
Grzesiekc
2009-12-09 15:47:37 UTC
SQL Server 2008

Uzytkownik "Reg Domaratzki [Sybase iAnywhere]"
Post by Reg Domaratzki [Sybase iAnywhere]
Post by Grzesiekc
Hello!
UPDATE ml_user SET last_upload_time = ? WHERE user_id = ?
E. 12/08 13:15:28. <1.5> [3]: Error: [-10002] ODBC: [Microsoft][SQL
Server Native Client 10.0]Datetime field overflow. Fractional second
precision exceeds the scale specified in the parameter binding. (ODBC
State = 22008, Native error code = 0, Column or parameter #1)
Mobilink: 9.0.2.3581
Works ok when odbc driver is [SQL Server] but doesn't work on ][SQL
Server Native Client 10.0]
Any ideas?
What is the version of your back end SQL Server database?
--
Reg Domaratzki, Sybase iAnywhere Solutions
Please reply only to the newsgroup
SQL Anywhere Patches and EBFs : http://downloads.sybase.com/swd/base.do
-> Choose SQL Anywhere
-> Optionally set filter to "Display ALL platforms IN ALL MONTHS"
Reg Domaratzki [Sybase iAnywhere]
2009-12-09 16:05:38 UTC
Post by Grzesiekc
Post by Reg Domaratzki [Sybase iAnywhere]
Post by Grzesiekc
UPDATE ml_user SET last_upload_time = ? WHERE user_id = ?
E. 12/08 13:15:28. <1.5> [3]: Error: [-10002] ODBC: [Microsoft][SQL
Server Native Client 10.0]Datetime field overflow. Fractional second
precision exceeds the scale specified in the parameter binding. (ODBC
State = 22008, Native error code = 0, Column or parameter #1)
Mobilink: 9.0.2.3581
Works ok when odbc driver is [SQL Server] but doesn't work on ][SQL
Server Native Client 10.0]
Any ideas?
What is the version of your back end SQL Server database?
SQL Server 2008
We have never tested and do not support MobiLink v902 with the SQL
Server Native Client 10.0 ODBC driver. We have also never tested and do
not support MobiLink v902 against SQL Server 2008. See
http://www.sybase.com/detail?id=1033610 for the list of ODBC drivers we
recommend, and the consolidated databases we support.

If you want to use a SQL Server 2008 consolidated database, you should
consider upgrading MobiLink to v11.0.1. See
http://www.sybase.com/detail?id=1062511.
--
Reg Domaratzki, Sybase iAnywhere Solutions
Please reply only to the newsgroup

Documentation : Exercise your WRITE @DocCommentXchange: DCX.sybase.com
SQL Anywhere Patches and EBFs : http://downloads.sybase.com/swd/base.do
-> Choose SQL Anywhere
-> Optionally set filter to "Display ALL platforms IN ALL MONTHS"