Post reply

[Microsoft][ODBC SQL Server Driver][SQL Server]Conversion failed when converting character string to smalldatetime data type.

  • November 18, 2005 at 9:48 am

    #169617

    Ok, first off, I have a update statement that worked fine under SQL 2000 and now after upgrading to 2005, im getting this error when updating a record.

    I pull in the data from the sql 2005 server in ASP where one of the fields are smalldatetime.

    In the form, I make my changes, which right now, im not editing the date, and when I go to update the data, the error is thrown.

    Any ideas why 2005 is doing this and what a possible remedy would be?

  • November 21, 2005 at 2:28 am

    #604875

    Could you post the entire error message (it's been truncated), and the update code?

    As a random guess based on the 'conversion' part of the error, it may be a collation problem. You can play with these more in 2005, conencting it to the system locale settings (windows collation) or configure it per database.

    See: http://msdn2.microsoft.com/en-us/library/ms187582.aspx

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply