Configure odbc to connect to a remote oracle database

This document describes how to configure odbc to connect to the local oracle database by performing the following steps: 1. Enable the remote oracle database service. 2. On the local client, install the oracle database (the version is win32_11gr2_client, mainly to install the oracle odbc driver) through the PLSQL Client

This document describes how to configure odbc to connect to the local oracle Database in spss statistics 19.0. 1. Enable the remote oracle database service and enable the following two steps. 2. On the local client, install the oracle database (win32_11gr2_client is used to install the odbc driver of oracle) through the PL/SQL client

This document describes how to configure odbc to connect to a local oracle database using spss statistics 19.0. The procedure is as follows:

1. Enable the remote oracle database service. Enable the following two services:

2. on the local client, install the oracle database (win32_11gr2_client is used to install the oracle odbc driver) and remotely connect to the database through the PL/SQL client to test whether the database is normal. <喎?http: www.2cto.com kf ware vc " target="_blank" class="keylink"> VcD4KPHA + encrypt/decrypt/qosxnri3cjnz8kjuw.vcd4kpha + PC9wPgo8cHJlIGNsYXNzPQ = "brush: SQL;" ># tnsnames. ora Network Configuration File: D: \ app \ 1 \ product \ 11.1.0 \ client_1 \ network \ admin \ tnsnames. ora # Generated by Oracle configuration tools. MYORAL = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = 132.97.194.13) (PORT = 1521) (CONNECT_DATA = (SERVICE_NAME = MYORAL )))If it is normal, you can:

3. After enabling spss statistics, select File-Open Database-new query.

Select "add odbc Data Source ":

Click "add", and select the database you are using. Here, select "oracle in oradb... ", (because I installed the oracle11G database, there is a corresponding driver here ):

1. data Source Name (used later) 2. you can enter the description at will. 3. select the service name of the database (in tnsnames. if the ora file is correctly configured, the current file will be automatically matched.) 4. enter an existing database user. For the remaining default values, click test connection to enter the username and password of the database user. Click "OK". If the prompt is "successful", the configuration is successful. You can confirm the remaining steps.

The odbc Configuration window has another source, for example:

Finally, you can add the database data: