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.
You can't load 32 bits dll's into a 64 bits process, possible work arounds would be installing the 64 bits components (if available) or change your application from 'any cpu' to 'x86' in the project options to force a 32 bit process.
Proposed as answer byPaul ZhouTuesday, July 12, 2011 9:33 AM
Marked as answer byPaul ZhouMonday, July 18, 2011 9:44 AM