You are currently offline, waiting for your internet to reconnect

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

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.
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: 10/15/2011 18:35:00 - Revision: 3.0

  • kbmbsmigrate kbretire KB861801
Feedback
>