'Why does "Microsoft OLE DB Driver for SQL Server" need to be installed on client PC?
My application has a reporting component with Crystalreports. The Reports uses the "Microsoft OLE DB Driver for SQL Server" (MSOLEDBSQL) to connect to a local SQL Server. I have installed the MS OLE Driver 18.6. The Connection is encrypted (by "Use Encryption for Data" = -1), it works on local mashine. On testing to a SQL Server on a VM (OLE Driver 18.6 installed) and deinstalling the OLE Driver 18.6 on local mashine I got a login window by calling the reports. This means I have install the OLE Driver 18.6 on all client PC of our customers. What makes me wonder is that earlier with Crystall Reports and SQLOLEDB we didn't need the installation. So what's the difference here?
Is it possible to install the OLE Driver with the SQL Server installation, keyword client connectivty?
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|