When CF connects to an MS SQL server, as part of the connection it sets the language and date format as follows:
set language us_english set dateformat mdy Can I override these values in the Connection String and if so, how? I've been Googling for hours and found a few things to try but I've had no success. I want to set the defaults to "British" for the language and "dmy" for the dateformat but the profiler is still showing the details as above. An approximation of the connection string I've been testing with is as follows... jdbc:sqlserver://localhost:1433;databaseName=xxxx;user=yyyy;password=zzzz;La nguage=British;dateformat=dmy; I've tried "Current Language" as well to set the language but nothing seems to be having an effect. Is there something totally obvious that I'm getting completely wrong? This is the first time I've played with connection strings and it's not going too well... :( Paul ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293251 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
