A new ODBC driver for SQL Server adds support for always encrypted access.
Does anybody know of any compatibility issues with SQL 2012 and the Advantage StreamlineSQL ODBC driver? I have a linked server using a DSN which is using said driver which will not allow me to query the database with it. I have connected via a C# app and through MS Access with this driver.
While the preview version of the driver had support for SQL Server's Always Encrypted security feature, this did not make the version that was released with SQL Server 2016 RTW (Release To Web).
The missing elements from ODBC Driver 13 for SQL Server have now been included in version 13.1, which can now be downloaded. Alongside the support for Always Encrypted, the new version supports Azure Active Directory authentication.
The Always Encrypted support relates to SQL Server 2016 and Azure SQL Database. Data can be encrypted within the application, meaning SQL Server and/or Azure SQL Database only handles the encrypted data, and never sees plaintext values. If a SQL instance or host machine is compromised, an attacker can only access ciphertext of your sensitive data.
Azure Active Directory (AAD) support is another addition. AAD authentication provides an alternative to SQL Server authentication, and is used to centrally manage identities of database users. The ODBC Driver 13.1 lets you provide your AAD credentials in the ODBC connection string to connect to Azure SQL DB.
Another improvement in the updated driver is support for Internationalized Domain Names (IDNs). These let your web server use Unicode characters for the server name. The new driver lets you convert a Unicode serverName to ASCII compatible encoding (Punycode) when required during a connection.
The final improvement to the updated driver is support for AlwaysOn Availability Groups (AG). The documentation says that the driver quickly discovers the current AlwaysOn topology of your server infrastructure and connects to the current active server transparently.
More Information
Related Articles
SQL Server 2016 Released
To be informed about new articles on I Programmer, sign up for our weekly newsletter,subscribe to the RSS feed and follow us on, Twitter,Facebook, Google+ or Linkedin.
Mathematical Art 2019 02/06/2019 There is a deep affinity between math and art. There is beauty in mathematical symbols and the forms that they describe. Every year the American Mathematical Society (AMS) organizes an art exhibition [ ... ] |
Python - Dead Batteries Included? 22/05/2019 Python is the 'batteries included' language - but is it? A recent heated talk at the Python Language Summit accused Python of having leaking batteries and suddenly the core developers are considering [ ... ] |
More News |
Comments
or email your comment to: [email protected]
I have a Faircom c-tree database file (.dat & .idx).I have connected it using ODBC Faircom Driver.
now I want to build queries on that database. actually i have already ready SQL version query but it is not working in c-tree database.
most of functions are not supported(like isnull,isnumeric,dateadd etc.)
help me to come out of this.
maulik kansaramaulik kansara
1 Answer
There is a developer's guide here for C#, as one of your tags is:.Net Guide
As well as a specific citing of your read example here:C# Read Example
Citing the example from the above link, your read code would look something like this:
jymbojymbo