Sunday, March 25, 2012

Date problem

Hi i finished one website using asp and ms sql server. it using some content management system. i finished the project and tested successfully with my local host, and on a lan server. its all working fine. but when my client hosted it on his system (he have his own hosting) it caused error.

i went through the error and found that following lines are the reson for errors

UPDATE users SET lastlogin = '2005-02-17 07:59:40' WHERE username = 'sreeju'

INSERT INTO my_status (myid, StatusID, datecheckedout, checkedoutby) VALUES (22,1,'2005-02-17 08:05:39','sreeju')

I am getting error message as

Error Type:
Microsoft OLE DB Provider for SQL Server (0x80040E07)
The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.

since it is working fine with my server, is there any date settings i need to change in the client sql server...

Please help...
Thanks in Advance...What type is datecheckedout and lastlogin on the server it works on, and the server it does not?|||hi thanks for your care. from the local server i took backup and it restored in my client machine. so i don't know why its happening. so both the server have datatype datetime

No comments:

Post a Comment