Migrating website

[karazy]

Hey I am migrating a site from an NT server to a 2003 server..... they are both connecting to the same MSSQL database but querys from the 2003 server are being strict about the datatypes like dates and strings and Integers ...... where as from the NT server they are not strict ..........

forexample I used to be able to query a varchar object with a number. But now it is erroring and telling me that the type is wrong.... It is the exact same code but one is quering the server from NT4 and the other is Server 2003.

EDIT: I think i better give and example too
This will work from the NT server
insert into division (type,updateby,createdate,moddate) VALUES ('test','191','25/2/2004','25/2/2004')

But only this will work from the 2003 server
insert into division (type,updateby,createdate,moddate) VALUES ('test','191',25/2/2004,25/2/2004)

[bcolflesh]

querys from the 2003 server are being strict about the datatypes like dates and strings and Integers

This is the correct behavior - fix your old code to conform with the strict handling - it will save you hassles and potential security problems later.