im getting this error while inserting into table (description of table given below)

mytable
mycode smallint identity,
mydataitem varchar(100),
mydatefrom smalldatetime,
mydateto smalldatetime,
myopcode smallint,
lastupdate smalldatetime

my sql statement was

INSERT INTO mytable
(mydataitem,mydatefrom,mydateto,myopcode,lastupdat e)
VALUES
('SAMPLEDATA','01/01/2003','18/05/2003',1,'05/Mar/2004')

THE ERROR RETURNED IN MY CLIENT APP IS
[Microsoft][ODBC SQL Server Driver][SQL Server]The conversion of char data type to smalldatetime data type resulted in an out-of-range smalldatetime value.

AND THAT IN QA IS

Server: Msg 296, Level 16, State 3, Line 1
The conversion of char data type to smalldatetime data type resulted in an out-of-range smalldatetime value.
The statement has been terminated.

can ne 1 point out the mistake in my sql statement ?

Date in MySql is used as YYYY-mm-dd

You use dd/mm/YYYY but your application seem to use mm/dd/YYYY