Hi

I'm stuck with an issue on an old classic asp project.

I'm trying to migrate to another server which has same OS(Windows 2012) and MS-SQL 2012 but ADO versions are different. Current server(S1) ADO 6.2 whereas the new server(S2) has ADO 6.3

Now my issue is on S1, date format is '8/1/2017 7:22:05 PM' but on S2 it gives '01-08-2017 19:22:49'

This gives error while working with TSQL on S2

Microsoft SQL Server Native Client 11.0 error '80040e07'

The conversion of a varchar data type to a datetime data type resulted in an out-of-range value.

Please help