Powering thousands of Online Stores, Shopping Carts, around the world!

PDshop is built on Asp.Net, works with ALL Windows web hosts and Windows servers!
Powered by Asp.Net Learn More
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.
Related Articles
Related Topics
Search for help...

Updates

No updates or new downloads are currently available.  Check back later for news and updates on products we may be developing. Support has ended for most legacy products and tools.