I have VS 2008 on Win 7 Professional 64bit system and database is Oracle 11g r2 installed on the same machine.
In Data Source Configuration Wizard --> New Connection
Data Source: Oracle Database (Oracle Client)
When I click Test Connection after entering Service name, username, and password I get the following error:
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.
-- I have no oracle client installed because there is no need in this case, I have the same setup on my laptop Win 7 32bit Oracle 11g r2 32bit and everything is working fine.
Please let let me know if you guys have solution for this issue.