Error "The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value." is identified by the VB Application

Article ID: 861801
Expand all | Collapse all

TechKnowledge Content

The information in this document applies to:

- Great Plains on Microsoft SQL Server

SYMPTOMS

The VB Application identified by the event source logged this Application WebService: Thread ID: 2560 ,Logged: MsgBox: , Run-time error '-2147217913 (80040e07)':

[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.

CAUSE

There is a problem with the ODBC DSN or using non-English (US) regional settings.

RESOLUTION


Check the ODBC DSN connection string.

1 Click Start, point to Programs, point to Administration Tools and then click Data Sources (ODBC).

2. Locate the DSN that was used for the eService Calls and eReturns installation, click to select the DSN name and then click Configure.

3. On the first screen, accept the current entries by clicking Next. On the second screen, enter the SQL login and password and then click Next. On the third screen, make sure that the Use ANSI quoted identifiers and Use ANSI nulls, paddings and warning are both cleared and then click Next. On the last screen, make sure all of the check boxes on this windows are also cleared and then click Finish.

After making these changes, re-boot the Internet Information Services (IIS) server so that the Dllhost.exe processes are cleared from memory.

Check the Regional Settings on the IIS server.

1. Click Start, click Settings, click Control Panel and then click Regional Options.

2. On the General tab, check the language settings to make sure Western Europe and United States is the only language and is defaulted.

3. On the Input Locals tab, make sure English is selected and defaulted.

If there are any changes, re-boot the machine for them to take effect.

This article was TechKnowledge Document ID: 33467

Properties

Article ID: 861801 - Last Review: October 15, 2011 - Revision: 3.0
Keywords: 
kbmbsmigrate kbretire KB861801
Retired KB Content Disclaimer
This article was written about products for which Microsoft no longer offers support. Therefore, this article is offered "as is" and will no longer be updated.

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com