Last post Jul 03, 2015 02:29 AM by philips11
Nov 13, 2014 01:35 PM|sabconq89|LINK
I am trying to connect to Oracle database from Visual Studio 2012 but I am getting the error as "attempt to load oracle client libraries threw badimageformatexception this problem will occur when running in 64 bit mode with the 32 bit Oracle client components
The software configuration on my machine is
Visual Studio 2012 Professional 64 bit
Oracle SQL Developer 32 bit.
Even though, I changed the target platform from "Any CPU" to "x86" while debugging the code.
Any suggestions on this?
Nov 13, 2014 04:51 PM|Lannie|LINK
You have to install the 64-bit Oracle ODP.NET with CLient Install in ANOTHER Oracle_Home directory
Or migrate to the new MANAGED DRIVER ODAC with client built into DLL, which is relatively new and I have trouble with it in FIPS140 compliant environments but no troubles in non-FIPS140 compliant environments. Reading Required for understanding how it is
different from historic UNMANAGED ODAC , how to use and configure.
Jan 21, 2015 06:19 AM|Zhi Lv - MSFT|LINK
attempt to load oracle client libraries threw badimageformatexception this problem will occur when running in 64 bit mode with the 32 bit Oracle client components installed
As for this issue, as
Lannie said, you need install the 64-bit Oracle ODP.NET with client, you could refer to this article.
Jul 03, 2015 02:29 AM|philips11|LINK
Pathing hang - Make sure that your Oracle environment variables are properly set ($ORACLE_HOME)
External hang - The network being down, Kerberos security issues, SSO or a firewall issue can cause an Oracle connection to hang. One way to test this is to set sqlnet.authentication_services=(none) in your sqlnet.ora file and retry connecting.
Listener down/hanging - Start by checking the listener (check lsnrctl stat). Also, see my notes on diagnosing Oracle network connectivity issues.
RAM shortage hang - Over allocation of server resources, usually RAM, whereby there is not enough RAM to spawn another connection to Oracle.
Data hanging - It is not uncommon for an end-user session to “hang” when they are trying to grab a shared data resource that is held by another end-user.
iff all given solution do not work with your issues/errors then simply for some third party tool
i would suggest to go for Oracle File Repair Tool