I have been using this script to connect to my server/db. It has been working for years. My company recently disabled TLS1.0/1.1. I am getting SSSL security error now. what can I do to make it work?
Microsoft OLE DB Provider for SQL Server
[DBNETLIB][ConnectionOpen (SECDoClientHandshake().]SSL Security error
oCN = ObjectOpen('ADODB.Connection')
oCN.Provider = 'SQLOLEDB'
oCN.Properties('Data Source').Value = MySource
oCN.Properties('Initial Catalog').Value = '%MyCatalog%'
oCN.Properties('User ID').Value = MyUserID ;use for non integrated
oCN.Properties('Password').Value = MyPassword ;use for non integrated"
oCN.Open()
Thanks in advance for any feedback
Charles
update: all fixed - I changed the provider to new provider. oCN.Provider = 'SQLNCLI11'
Not sure, but there are additional parameters you can add to the connection string, like 'Trusted_Connection = Yes' or 'Integrated Security = Yes'
If you are using MSFT' SQL server you could use the native SQL client provider and set the "DataTypeCompatibility" property to 80.