In the last years we have Oracle Client 11 Software on our PC-Clients and we had a successfully Connection to a Oracle 12 Database for Example with the following Code:
oCon = CreateObject("ADODB.Connection")
oCon.Provider = "MSDAORA.1"
oCon.Properties("Data Source") = "XYZ"
oCon.Properties("User ID") = "ABC"
oCon.Properties("Password") = "JKL"
oCon.Open
RsT = CreateObject("ADODB.Recordset")
RsT.ActiveConnection = oCon
We want to install a Oracle 19 Database in January, now we installed on the first PC-Client the Oracle Client 19 Software. The Connection to the Oracle 12 Database did not work with the old Code. Error-Message: ORA-12557: TNS: Protokoll-Adapter do not load
What must we change in the Code to Connecting to the Oracle 12 Database with the Oracle Client 19 Software?
Greetings,
Stefan