MSSQL Server datetime data type conversion error
Sample Error
[Microsoft][ODBC SQL Server Driver][SQL Server]The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value
Solution or Workaround
This is a problem due to the Microsoft SQL Server Default Language, your web host likely installed the server with the wrong default region. If the date format of the web server environment and the MSSQL Server do not match, it will result in an error like this. In other words, your database server & web server disagree on how to format dates.
The latest revision of PDshop Advanced does include a workaround for this situation. You should download and install the latest revision; contact PageDown Technology support if you need further assistance or a custom solution - also see 'Formatting' page in PDAdmin for some new LCID bypass parameters.
The latest revision of PDshop Advanced does include a workaround for this situation. You should download and install the latest revision; contact PageDown Technology support if you need further assistance or a custom solution - also see 'Formatting' page in PDAdmin for some new LCID bypass parameters.
Related Articles
Related Topics
Search for help...