"Date" is a reserved word in MS Access (which I guess you may be using) and probably in other databases too. Changing the column name to something more precise would, as a side effect, improve your database design.
Joined: Jul 10, 2005
they i changed the field name date to edate. now its working. thanks a lot friends.
Joined: Jan 23, 2006
check the DNS name which should be created as company while connecting to MS sql server.