C# With Oracle During Insert I Am Getting Error Like As

Question

0.00/5 (No votes)

See more:

hi
i am using VS2012 and oracle 11G 64 bit when i am going to connect the database via C# ASP.net then i am getting following error

Quote:
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.

so what should i do for this issue?
i don't want to install 32 bit oracle

Posted 20-Jan-16 21:13pm

Member 10192073

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2016-01-20T21:25:00

Solution 1

"i don't want to install 32 bit oracle"
That isn't what the error message is saying: it says that you have installed 32 bit Oracle components and are trying to use them from a 64 bit application.
Either check the Oracle setup - and possibly re-install - or change your app to 32 bit mode.

Posted 20-Jan-16 21:25pm

OriginalGriff

Comments

Member 10192073 21-Jan-16 3:31am

how we can check that my oracle is 32 bit or not?actually i have installed 64 bit oracle because my operating system was 32 bit then i had to install the window 64 bit and then i installed oracle 11 G 64 bit

OriginalGriff 21-Jan-16 3:45am

If you installed Oracle on a 32bit system, then it wouldn't install a working 64 bit copy - the OS doesn't support it, so it would install a 32 bit version instead. If you later installed a 64bit OS over the top of your 32 bit, then the chances are that you got a mixed up installation going on!
You can check what you have pretty easily:
http://stackoverflow.com/questions/13188670/how-to-know-installed-oracle-client-is-32-bit-or-64-bit
Look at all the answers - I suspect you have both 32 and 64 bit versions!

Member 10192073 21-Jan-16 7:12am

i found in above link is

A simple way to find this out in Windows is to run SQLPlus from your Oracle homes's bin directory and then check Task Manager. If it is a 32-bit version of SQLPlus, you'll see a process on the Processes tab that looks like this:

sqlplus.exe *32
If it is 64-bit, the process will look like this:

sqlplus.exe

so in processes it looks as sqlplus.exe
it means its 64 version
now what should i do?

OriginalGriff 21-Jan-16 7:20am

Did you look at ALL the answers?

Member 10192073 21-Jan-16 7:27am

in comps.xml

<dep_list>
<dep name="oracle.rdbms" ver="11.2.0.1.0" plat="NT_AMD64">
<dep name="oracle.dbjava.jdbc" ver="11.2.0.1.0" plat="NT_AMD64">

Member 10192073 21-Jan-16 7:29am

- <dep_list>
<dep name="oracle.network.aso" ver="11.2.0.1.0" plat="NT_AMD64">
<dep name="oracle.rdbms.partitioning" ver="11.2.0.1.0" plat="NT_AMD64">
<dep name="oracle.sdo" ver="11.2.0.1.0" plat="NT_AMD64">
<dep name="oracle.rdbms.lbac" ver="11.2.0.1.0" plat="NT_AMD64">
<dep name="oracle.rdbms.numa" ver="10.1.0.1.0" plat="ALL_PLATFORMS">
<dep name="oracle.oraolap" ver="11.2.0.1.0" plat="NT_AMD64">
<dep name="oracle.ntmgmtobjs" ver="11.2.0.1.0" plat="NT_AMD64">
<dep name="oracle.rdbms.dm" ver="11.2.0.1.0" plat="NT_AMD64">
<dep name="oracle.clrintg.ode_net_2" ver="11.2.0.1.0" plat="NT_AMD64">
<dep name="oracle.rdbms.dv" ver="11.2.0.1.0" plat="NT_AMD64">
<dep name="oracle.rdbms.rat" ver="11.2.0.1.0" plat="NT_AMD64">

Member 10192073 21-Jan-16 7:29am

ya its 64 bit

it shows only
PLAT="NT_AMD64

Member 10192073 21-Jan-16 7:19am

actually i want to tell you that first i had 32 bit version of window and then my 64 bit version of oracle was not installing in my computer then i format the system and reinstall 64 bit OS in my computer and then i installed oracle 64 bit in my computer.
it means my OS is 64 bit and my oracle is also 64 bit.so now why its showing the error