Kofax TotalAgility - Unable to connect to an Oracle database using KTA DAS

(https://techsupport.kofax.com/knowledge-base/) Question / Problem

When attempting to connect to an Oracle (msdaora.dll) and database using KTA DAS (Data Access Service), the standard TNS data source is reporting that the connection string is invalid.

(https://techsupport.kofax.com/knowledge-base/) Answer / Solution

Microsoft OLEDB Provider for Oracle (msorcl32.dll) are built utilising OCI (Oracle Call Interface) version 7.

Oracle no longer supports applications that use OCI version 7 calls, and the technologies are deprecated.

We would suggest using Oracle X64 client drivers and Provider OraOLEDB.Oracle eg : Provider=OraOLEDB.Oracle;Data Source=[DBIntanceName];User Id=[TASchema];Password= [password];