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