64-bit operating system with odp.net access to Oracle 11g

Summary: 64-bit operating systems when you deploy a. NET program to access Oracle, you cannot connect to the problem. (Note: The client is a 64-bit system, whether the server is 64-bit or 32-bit independent.) ）

1. Search for the relevant version of the ODAC URL on the Oracle website: http://www.oracle.com/cn/solutions/midsize/index-090165.html We need to access the database is 11.2.02.1 version then download this:64-bit Odac 11.2 Release 3 (11.2.0.2.1) Xcopy for Windows x64

2. Download it later is a zip file: odac112021xcopy_x64.zip

3.

Extract the odac112021xcopy_x64.zip to a directory on the disk, such as "D:\odac112021xcopy_x64", and enter the directory at the command line (cd/d d:\ Odac112021xcopy_x64), enter the following command: "Install.bat all C:\odp.net myhome (Install all components)".

4. After running the above command, all files will be automatically copied to the C:\odp.net directory, then the command line into the C:\odp.net directory (cd/d C:\odp.net),

Run the command: "Configure.bat all MyHome (Configure all component)". The above command will automatically want the GAC to register odp.net related DLLs, while adding references in vs2010 to see the version of Oracle.DataAccess.dll.

5. Finally, you need to add the system environment variable path, c:\odp.net;c:\odp.net\bin;

This step is not required if you are only able to access Oracle on the server for a 64-bit operating system. Test it, you can access it on the line.

Complete

64-bit operating system with odp.net access to Oracle 11g