Our analytical lab (chemistry) has an information management system (LIMS) that uses an MSSQL database. Technicians interact with the system through a Windows form application that is closed-source and permits only SQLOLEDB.1, MSOLEDBSQL, and SQLNCLI11.1 (Native Client 11) connections (choices are picked from a dropdown box at login). Our production server is MSSQL 2016 running on Windows Server 2012.
The lab has several analytical instruments that are constrained to Win 7 and Win XP for data acquisition. This is an immutable constraint.
On the production setup, all machines make a connection with legacy SQLOLEDB.1 but Win 10 Machines can alternatively connect with MSOLEDBSQL, and SQLNCLI11.1 as well. Win 7 and XP machines cannot.
I am prototyping an MSSQL Server 2019 upgrade on a Ubuntu server. As configured, no machines can connect to it using the legacy SQLOLEDB.1 connection. The LIMS application is able to connect to it from Win 10 using either MSOLEDBSQL or SQLNCLI11.1. The Win 7 and XP machines cannot connect with any of the protocols.
If this is to work, I have two choices:
- Somehow configure MSSQL on the Ubuntu server to accept SQLOLEDB.1 connections.
- Somehow configure XP and Win 7 machines to make MSOLEDBSQL or SQLNCLI11.1 connections.
I cannot figure out how to do either one. Please help.