ActiveXperts Knowledge Base Article 7750010
Our mission at ActiveXperts Software is to deliver high quality Network Monitoring solutions and Windows Development components.
Our goal is to supplement these solutions with timely support resources that can help at many different levels.
The first thing you want to do is try to find the answer to your problem in the Knowledge Base.
If you cannot find an answer to your question in our Knowledge Base, or if you need additional information or assistance, please use our Contact Support form.
Q7750010 - Which database driver do you recommend to use with Microsoft SQL Server?
It is strongly recommended to use the Microsoft OLE DB Driver for SQL Server (MSOLEDBSQL). This provider will be updated by Microsoft with the most recent server features going forward. It also supports encryption standards, whereas other Microsoft providers don't. ActiveXperts fully supports MSOLEDBSQL.
To install the MSOLEDBSQL driver (if not installed yet), see FAQ #7750020.
In ActiveXperts Network Monitor version 2022 and lower, ActiveXperts recommended the 'SQL Server Native Client (SNAC)' driver, which was available from SQL Server 2005. However, 'SQL Server Native Client (SNAC)' has been removed from SQL Server 2022 (16.x) and SQL Server Management Studio 19 (SSMS). The driver can still be used, but is not recommended.
The legacy Microsoft OLE DB Provider for SQL Server (SQLOLEDB) can also be used, but is not recommended either. It isn't maintained anymore by Microsoft and it is not suitable to use with encryption and the latest encryption standards.
To see how a typical MS SQL Server based connection string would look like, see FAQ #7750024.
If you cannot find an answer to your question(s) in our Knowledge Base, or if you need additional information or assistance, please contact our Customer Support using our Contact Support Form