i can't connect to oracle from windows 2008 R2 (connect from visual studio)
i have installed oracle client x64 , but still can't connect
“Oracle client and networking components were not found. These components are supplied by Oracle Corporation and are part of the Oracle Version 7.3.3 or later client software installation”
also i tried to connect trough ODBC but i couldn't
any ideas please
This isn't a pretty problem. You will likely need to recompile your code with the Oracle data provider instead.
"Microsoft OLEDB Provider for Oracle and Microsoft ODBC driver for Oracle If you are using Oracle data sources, you should migrate to the Oracle-supplied provider and driver. Microsoft OLEDB Provider for Oracle (msdaora.dll) and Microsoft ODBC driver for Oracle (msorcl32.dll) are built by using Oracle Call Interface (OCI) version 7. Oracle no longer supports applications that use OCI version 7 calls, and these technologies are deprecated. " --Microsoft
http://social.msdn.microsoft.com/Forums/en/sqldataaccess/thread/96048ef5-ef9e-4b1c-b8a3-5d7b91d55adb https://connect.microsoft.com/SQLServer/feedback/details/267677/x64-version-of-msdaora-driver-please
Oracle ODAC http://www.oracle.com/technetwork/developer-tools/visual-studio/downloads/index.html