| Ticket Hash: | ee2c42b4678488f85030265105bf96db13721ff1 | |||
| Title: | DateTime Format dropdown not working correctly when it creates the connection string | |||
| Status: | Closed | Type: | Incident | |
| Severity: | Important | Priority: | Medium | |
| Subsystem: | Connection | Resolution: | Unable_To_Reproduce | |
| Last Modified: | 2019-06-08 16:18:56 | |||
| Version Found In: | ||||
| User Comments: | ||||
anonymous added on 2019-04-24 17:41:38:
The problem is with the Connection String dialog box in that it is creating the wrong string when selecting "Ticks" for the DateTime Format I submitted a bug to the developer of SqlCeToolbox about it not creating the correct connection string when the DateTime Format is set to "Ticks". https://github.com/ErikEJ/SqlCeToolbox/issues/779#event-2296856008 mistachkin added on 2019-04-25 01:38:06: I've carefully examined the code that produces the connection string based on the properties. I'm unable to explain what is happening here; however, I think that perhaps the DisplayName property value for DateTimeFormat is being used at some point in SSMS. The DisplayName property value does contain a space, but it should only be used for display purposes, not building of the actual connection string. There are several tests in the test suite that check various generated connection strings, including one based on setting all supported properties. Perhaps there are tools that use the DisplayName to construct the connection string? In that case, it might be good to enhance System.Data.SQLite to be able to recognized those names as well as the base property names. | ||||
