I'm using the Sql Anywhere ADO.NET Data Provider and the Entity Framework 4.4 (latest version for .NET 4.0) in an application, that I'm developing.
I just installed the currently latest EBF (220.127.116.1167).
When I run my application now, I get the following exception when the connection to the database is opened at the start of the application:
Invalid option 'timestamp_with_time_zone_format' -- no PUBLIC setting exists
So I checked the database for that option and the 'timestamp_with_time_zone_format' option indeed is not set. And the reason for that is, that it was not needed (and still isn't).
My guess would be, that this behavior (i.e. trying to set this option) was added (as default) along with a bugfix (Build #3856 - Engineering Case #731461 in the changelog of the EBF).
My question is: how can I disable it? I don't need it (or do I?).
Thanks in advance for any help.
Update 3: This issue is now resolved in CR #741704, 18.104.22.16823, 22.214.171.1241.
Update 2: I have now been able to reproduce this issue 126.96.36.19995 with the .NET 4.5 Provider, with an 188.8.131.522 database, running on a 184.108.40.20695 server.
Either upgrading/rebuilding the 11.0.1 database file to version 12, or running the 11.0.1 database on the original 11.0.1 server is a possible workaround. I have opened this investigation as CR #741704.
Update: This issue has now been fixed in CR #735654, in 220.127.116.1176 and 18.104.22.1681
Which version of the database server are you using? Which version of the SQL Anywhere software was your database initialized with? (
Yes, you are correct - this is a regression due to the CR #731461 bug fix. Thank you for reporting this issue - I have opened this new investigation as CR #735654. I will update this thread when we have additional information.
Currently, the workaround is to downgrade the ADO.NET provider to a build earlier than 22.214.171.12456.