Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 datetime conversion error

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2004-07-08 : 12:01:16
tapiwa writes "am implementing application using vb and sql and this error keeps appearing. the clients are running windows 98 and server is windows 2000 server. not all client machines are producing this error, on average 3 out of ten machines work. error message is

error number - 2147217913

conversion of a char data type to a date time datatype has resulted in an out of range date time value.
Source: Microsoft OLEDB Provider for SQL Server


have tried everything please help as approaching deadline for project completion"

drymchaser
Aged Yak Warrior

552 Posts

Posted - 2004-07-08 : 12:23:47
I can only guess with the information you provided. Checking some local/regional settings on the clients. User error (entered bad data). If multiple servers maybe a setting there.
Go to Top of Page
   

- Advertisement -