By request of HCL support staff, regarding our support case "CS0387941 ", I herewith add an "Enhancement Request" to the ideas portal:
Please make it possible to add Connection String Parameters to a LCConnection in Lotus Script.
Here an example script:
Set LcCon = New Lcconnection("oledb")
LcCon.provider = strOLEDBProvider
LcCon.database = database
LcCon.Server = strPrincipal
LcCon.Userid = user
LcCon.Password = password
Call LcCon.Connect()
Background is:
In our customers web application we connect to an MS SQL server via an OLE DB connection. Therefore we want to try the newest OLE DB driver version 19 from Microsoft but we can´t use it because we have only self-signed certificates installed on our SQL servers. So we would like to use the "Trusted_Server" parameter for opening the connection.
https://www.connectionstrings.com/ole-db-driver-for-sql-server/
Extended Background:
Our customers webserver suffer of severe memory leaks triggered by the usage of the OLE DB connection of our customer web application. So the idea is to try out the newest version of OLE DB drivers.
Best regards
Mark Reiser
sirius-net GmbH, Germany
LSX, LSXLC
