Notes -> SQL Server using LS

HCL Domino Domino Forum
1

Domino/Notes Version: 12.0.2

I am trying to connect from Domino (a scheduled LS agent) to SQL Server. This article

is pretty clear on how to do it, but the MS driver referred to, using provider name “MSOLEDBSQL”, appears to work only with version 18 of the driver. Searching for it on MS site takes me here:

but that gives me version 19 - it installs MSOLEDBSQL19.DLL instead of MSOLEDBSQL.DLL, and I cannot get it to work, either using “MSOLEDBSQL” or “MSOLEDBSQL19” as the provider name.

Can anybody help me with either:
A trustworthy source for the version 18 driver or

How to get LS to use the version 19?

2

Have you tried dctest.exe? I’m not sure which dll dctest is using

Testing Connectivity to External Data Sources with DCTEST

C:\Temp>where MSOLEDBSQL19.DLL
C:\Windows\System32\msoledbsql19.dll

C:\Temp>where MSOLEDBSQL.DLL
C:\Windows\System32\msoledbsql.dll

This utility will verify connectivity from this machine to the

specified OLE DB provider.

At the prompt, enter a valid OLE DB provider name. Then enter the data

source, provider string, authentication service, username, and password

as required per the OLE DB provider.

     Provider Name: MSOLEDBSQL

       Data Source: (LocalDb)\\MSSQLLocalDB

   Provider String:

Authentication Service:

          Username: ls-user (sql server authentication)

          Password: \*\*\*\*\*\*

Successfully Connected

Successfully Disconnected

Connectivity to OLE DB Verified.