Last post Apr 26, 2015 09:50 AM by fsidrak2008
Apr 21, 2015 10:39 AM|fsidrak2008|LINK
I'm beginner in using visual studio with oracle db, I read a lot of articles about this subject then I decided to take the trial,
I have a strong machine called pc runs on windows 7 - 64bit , I installed microsoft visual studio 2013 on pc, then I installed oracle vm (virtual box) to make a virtual server.
I succeeded to create a virtual server (for testing) runs on ms windows 2008 server,
I installed oracle 11g on the virtual server.
then I installed oracle forms 6i runtime & sqlplus 8i on pc (my windows 7 machine), I created my tnsnames file then I could connect from forms 6i runtime & sqlplus 8i with the oracle 11g server in the virtual server
till now everything is ok.
I made download for the package ODAC112040Xcopy_64bit from oracle site, then I installed oracle 11g R2 x64 client on pc (my client) then I could register the dll's of the package ODAC112040Xcopy_64bit into the oracle client and the libraries added to the
(Global Assembly Cash of MS Vsual studio) by te help of the following article
I made restart , then
I opened visual studio 2013 ,
from the server explorer , from the data connection, I tried to add new connection,
I changed the data source to oracle database, I selected the data provider to be:
.Net framework Data Provider for oracle, I wrote the Ip address of the virtual server and the username & pass for my db and make test for the connection, I got the following error
Attempt to load oracle client libraries threw BadImageFormat Exception.
This problem will occur when running in 64 bit mode with the 32 bit oracle client components installed
Thanks in Advance.
your help will be appreciated.
Apr 21, 2015 04:20 PM|Lannie|LINK
Yes you must install the 64-bit 11g or 12c Oracle Data Access DLL and Client if you are compiling/using 64-bit applications.
The 64-bit client must be installed in a new Oracle Home to avoid conflict with your installed 32-bit client.
Apr 26, 2015 09:50 AM|fsidrak2008|LINK
Thanks a lot, every thing is ok now