The Clarion 12 release was delayed past our initial January 1st target as we maintained our traditional end-of-year break, I had planned for us to work straight through but decided we needed the break to recharge. Here’s something else that is new in this release.
Microsoft SQL Server Driver Updates
We’ve rebuilt the Microsoft SQL Server driver with some new capabilities:
Security
- TLS 1.2/1.3 support with related configuration options
- Column-level encryption
- Support for Server Certificate validation (including self-issued certificates)
- Improved error handling for security operations
Note: these features require the Microsoft ODBC Driver 17+
Version Support
- SQL Server 2005 through 2022
- SQL Server on Linux
- Azure SQL Database
- Existing connection strings and configurations remain valid unchanged
Azure SQL Database Support
- Azure Active Directory and Managed Identity authentication
- Failover group support
- Region-aware connectivity
- Elastic pool connections
Backward Compatibility
As with all our releases, Clarion 12 maintains 100% backward compatibility. Existing applications will work without modification, and all new features are opt-in.
General ODBC Driver Improvements
The SQL Server driver improvements extend into our entire ODBC stack:
- Refactored connection handling
- Enhanced custom connection string support
- More detailed error handling
- Full compatibility with existing applications
PostgreSQL Support
Our ODBC driver layer provides enhanced support for the official PostgreSQL ODBC driver:
- Improved connection string handling
- Enhanced error reporting
- Full compatibility with PostgreSQL’s native ODBC capabilities
SQLite Updates
And we’re working on new SQLite features:
- In-memory database support
- Improved transaction handling
- Better concurrent connection management
Next
We’ll soon provide a web application where developers can sign up to test upcoming AI features in the IDE. The database improvements in this release are complete and are in final testing. We need a few more days of testing before we announce C12 GA. Thanks for you support and patience!