I have a new compiuter that I am setting up. It was origionally installed as a 32 bit. However, a problem resulted in a re-build and OS 64 bit was installed. Now I am trying to install the ODBC 64 bit version and connect to Visual Studio. I have tried several times and I can create the ODBC connection fine,but when I try to use it from Visual Studio it gives me an error stating:
Attempt to load Oracle Client libraries threw BadImageFormatException. This problem will occur when running 64 bit mode with the 32 bit Oracle client components installed.
I have tried the Instant client x 64 11.2.2
and several lower versions, but with the same results.
When I create the ODBC connection I do see that the driver is SQOAR32.dll
64 bit clients can be downloaded from here: http://www.oracle.com/technetwork/topics/dotnet/downloads/index.html
That said, Visual Studio itself is 32 bit, so if you want the developer tools to work, you'll need a 32 bit client. If you're not using the developer tools in your project and you're compiling your project for AnyCPU or x64, the 64 bit client will work. If you're compiling for x86, you need the 32 bit client. (If you want to do both, you'll need two clients installed.)
edit - Actually, it looks like in this case you might be running into a problem of needing a 32 bit client & ODBC connection. The error mesage could be misleading here as Visual Studio itself is 32 bit. Did you create the ODBC connection using control panel? If so, that's a 64 bit connection.
32 bit ones are created using c:\windows\syswow64\odbcad32.exe
I'm just trying to get the reports projects working. That's where I get the error on the Datasource.
So I uninstalled the 64 bit version and dowloaded the most recent 32 bit version, but it won't install. I run throught the same process of extracting all the files and running the Instal, but when I go to setup the ODBC connection I do not see the Oracle version listed.
c:\windows\syswow64\odbcad32.exe is the 32 bit version of the ODBC control panel. It's what you use to create the connection (instead of the one in control panel) after you already install the ODBC driver. So you'll have to do the installation steps first. :)
First, I would really like to thank you for all your help!!!
Now I was able to get the ODBC connection setup and from the ODBC test it works fine. However from the Data source when I test the connection I am now getting an 'Invalid user name/Password'. I am using the same on both.