Ibatis issues when accessing 64-bit Oracle

Ibatis provides access to Oracle in many ways

1.ODBC

No attempt

2.OLEDB

The report does not register ORAOLEDB.ORACLE.1 provider error, do not use Ibatis Direct use OleDbConnection this issue does not occur

3.oracle.client

This is a Microsoft-provided connectivity program, Microsoft has indicated that it will not continue to provide support, because the connection is 64-bit Oracle, so the generated project must choose to generate 64-bit,

Otherwise it will prompt "{BadImageFormatException is raised when attempting to load the Oracle client library. This problem occurs if you are running in 64-bit mode with the 32-bit Oracle client component installed. }”。

Finally, the underlying calls to SQL and main call the underlying project are changed to 64-bit, only to resolve. It's impossible to debug ....

4.odp.net

Using the Oracle Oracle.Access.dll Access database, the number of bits and the number of Oracle bits installed is the same, so the 64 bit under the ORACLE.ACCESS.DLL is also 64 bit, if the item is 32 bit will prompt

Otherwise you will be prompted "Unable to load ORACLE.ACCES.DLL version=xx. Xx. Xx. XX public key=0ea8127128ba2d43 "error,

Finally, the underlying calls to SQL and main call the underlying project are changed to 64-bit, only to resolve. This will still be impossible to debug,

Can be modified according to Oracle's available Oracle.Access.dll version under the providers.config of the underlying