SQL Server & international date formats

[tim-p]

Here we go again...... I have been developing an asp app using a SQL Server DB
on my test server in the UK. All formats are set to be UK formats, dd/mm/yyyy
etc, and all is cool. All searches involving dates find the correct events, all
date inserts work fine and display correctly. Now I have to put it up on a
public webserver in order for the client to play with it - in my case a
Fasthosts server. Still in the UK, you would think everything would be OK.
Nope, all the fields involving dates throw an error on submit: Microsoft OLE
DB Provider for SQL Server error '80040e07' The conversion of char data type
to smalldatetime data type resulted in an out-of-range smalldatetime value.
All searches find the wrong results. I have tried putting LCID=2057 in my
connection page, so that it is an include in every page in the site. Still
wrong. Because this site is only temporarily on the public server I don't
really want to do wholesale re-writes. Anybody got any ideas for a
work-around?

[tim-p]

Another symptom. All the dates display correctly on the page. It is just where they are searched or inserted/updated that the problems arise.

Aaaaargh!