I want to connect an oracle database with an asp.net project in visual studio. when i create a data connection using
Server explorer-> data connections -> new data connection -> oracle client then i enter the credentials. it gives an error message saying running 64 bit client on 32 bit platform. although my oracle version is 64 bit.
n i m working on windows 8.1
even when i use oracle.dataaccess.dll
i get an error msg
Could not load file or assembly 'Oracle.DataAccess' or one of its dependencies. An attempt was made to load a program with an incorrect format.
kindly help as soon as possible its urgent.
do tell me some other way by which i can connect the database to the visual studio 2012
You must have both 32-bit and 64-bit Oracle DB Client installed on your machine. What is happening is that 32-bit ODP.NET looks for its dependent DLLs and finds the 64-bit Oracle Client ahead in the Windows Path. What you need to do is set the 32-bit ODP.NET DllPath in your machine.config file to point to where 32-bit Oracle Client bin directory is.