Skip to main content

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

Article # 301869 - Page views: 487



( 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.

( 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];

Keywords: oracle, data access, das, KTA, Totalagility, Unable, Database