>You need to know what is the format the server is accepting and use it. >Normally, using yyyy/mm/dd will be accepted on any settings because there is >no ambiguity.
Correction: its not ymd its dmy

i checked it in sql query analyzer
set dateformat DMY
insert into thetable(datecolumn) values('2002/03/23')
it gives an error.

>This is a different thread!!! You don't need a different connection. I would >need to see your problematic code on this.
I'm not always getting this error and i'm trying to simulate it again, as i get the perfect code i'll surely come back to u on this.