Error in conversion of smalldatetime

jrportela · Post by **jrportela** » Fri 01 Feb 2008 18:38

Good afternoon.

I am developer Brazilian and I acquires a copy of "dbExpress'Driver_for_MS_SQL_Server"(version 1.86).
We has urgency to update our server of data, of version SQLServer2000 for the SQLServer2005 version.
In the page of the product we saw in the section 'history' that the support for the SQL2005 was implemented completely in version 3.70.
We made download of version 4.20 to evaluate the functioning and to buy. However we now have a problem when inserting registers in tables that possess fields datetime or smalldatetime.

The error message is the following one: "The conversion from datetime data type to smalldatetime data type resulted in a smalldatetime overflow error".

OperationSystem => Windows Server 2003 Standar Edition SP2
DatabaseServer => MS SQLServer 2000 SP3a
ProgrammingSoftware => Borland Delphi 7

I thank the attention and I ask one solution, the possible fastest.

Cordial,

Edivaldo Portela - [email protected]

Antaeus · Post by **Antaeus** » Mon 04 Feb 2008 14:58

Please describe the problem in more details, or send us a complete small sample at sdac*crlab*com to demonstrate it, including scripts to create couple of tables (one on SQL Server 2000, another on SQL Server 2005), and fill them. Try to simplify tables structure as much as possible. Also provide exact steps to reproduce the problem.