About the 64-bit SQL Server Remote connection Oracle problem

For work reasons, this new need to read Oracle data remotely from 64-bit SQL Server, these days from the Internet to find a variety of solutions, the general meaning can understand (through the ODBC data source access), but the actual application will always have such a problem, In fact, you are too thought highly the new ability of the reason. Fortunately after two days of pondering, I in some articles help to figure out the doorway, in order to help more of the same Moe, below I will list the specific operation method:

first , I wanted to start with a local Oracle client, but an article from a big guy woke me up (http://blog.sina.com.cn/s/blog_ 72d3486f0102w4n1.html), you do not need to install the client, download the relevant basic files and ODBC file combination. But here are a few questions: one, you need to pay attention to the download from the official website or other places, the official website of the 12.2.0.1.0 version of the new ODBC data source will be reported

The wrong, do not know is not my computer system problem; Second, there is no network folder in the downloaded file, here directly on my good version, I 11.2.0.4.0 version (https://pan.baidu.com/s/ 1NMR96E2ZJGA3G8KH8XBRRG, Password: 35JZ). After download unzip, the directory instantclient_11_2\network\admin under the file Sqlnet.ora and Tnsnames.ora inside the

Change to your own data source name, the Oracle database IP you want to connect to, and the port number, all two. Change the whole folder into the C:\Program files directory, and create a new environment variable (right click on My Computer-Properties-Advanced system settings-environment variables-the next New button) variable name: tns_admin, the path is: C:\Program Files\instantclient_11_2\network\admin

The second step , after configuring the environment variables, it is time to install the ODBC64-bit driver, the recommended DOS command installation, you can see the specific installation information (success or not): Win key +r--input cmd Enter-switch to English input method, enter "CD." Enter two times back to the C packing directory, enter the address Cd\program files\instantclient_11_2 Enter this directory, and then enter Odbc_install.exe carriage return to install, successful words will be prompted.

The third step , after the driver installation is complete, is the process of configuring the ODBC64 bit data source. It is important to note that 64-bit SQL Server cannot create a new 32-bit ODBC data source for linked servers, so be sure to double-click on the (Control Panel-System and Security-admin tool--odbc64 bit data source)

Here you must find the ODBC driver for 11_2, click System DNS, add a new 11_2 data source:

Click Finish (My Computer 12_2 will error, mentioned above)

These four fill in, Other no tube, click Test Connection,

Enter the password test connection, success will prompt connection successful, otherwise you need to ping the database IP, check whether the network connection problem. Click Ok-ok, you are done.

The Fourth step , open SQL Server login to the local database, here is relatively simple, find the server object point open, right click on the linked server new, linked server, product name and data source are filled with your new ODBC data source name, the following fill, Security fill in the login name and password, the server option check RPC and RPC out (set to True), click Finish basically OK. You can in the link server in your new data source name, see you need to connect to the Oracle database of the entire content, as for the operation of SQL statement how to write, suggest Baidu, here do not repeat, can refer to https://www.cnblogs.com/galeno/p/5230992.html.

About the 64-bit SQL Server Remote connection Oracle problem