SQL Server Dataserver default language and dates

Posted by christian.bryan@capita.co.uk on 10-Sep-2014 08:05

Hi 

I have an issue with the OE Dataserver and date matching in queries.

If you change the default language in the SQL server instance to something other than "English" in our case "British" the application can now longer match on dates.

e.g. the following query fails

Find record where date = 04/01/2014.

Our customer changing the setting and we can change it back but i wondered whether there were any dataserver options that can accommodate this?

Thanks

Christian.

All Replies

Posted by christian.bryan@capita.co.uk on 10-Sep-2014 09:42

FYi - If you use the SQL Server Native Driver this resolves the issue.

This thread is closed