I have a CF2023 box running with MSSQL 2022 and I ...
# adobe
s
I have a CF2023 box running with MSSQL 2022 and I see these messages frequently throughout the day:
Copy code
Dec 17, 2024 10:51:30 AM Warning [ajp-nio-127.0.0.1-8022-exec-7] - [Macromedia][SQLServer JDBC Driver][SQLServer]Changed database context to '[redacted]'.
Dec 17, 2024 10:51:30 AM Warning [ajp-nio-127.0.0.1-8022-exec-7] - SQL Warning Code: 5703, SQLState: 01000
Dec 17, 2024 10:51:30 AM Warning [ajp-nio-127.0.0.1-8022-exec-7] - [Macromedia][SQLServer JDBC Driver][SQLServer]Changed language setting to us_english.
I haven’t seen this before the upgrade so not sure why it’s happening all of a sudden - is there a way to prevent this or to specify that it doesn’t change to US english as this might mess up date/times I think. This is in the coldfusion-out log. I did look up JDBC arguments but didn’t find anything definitive.
r
Dates should be stored in ISO format and those are just warnings. You can probably safely ignore them. You can configure the language with SQL Server. See https://learn.microsoft.com/en-us/sql/database-engine/configure-windows/configure-the-[…]-language-server-configuration-option?view=sql-server-ver16.
s
Thanks Rodney! I actually just came from that page before I commented to so good to know it’s likely ignorable
I haven’t actually spotted any locale issues (yet?) but I thought I’d ask around in case someone else had encountered it