ODBC connection to the Oracle 10g Client

Generally, if you installOracleServerSoftwareOracle ODBC source is automatically added, so you do not need to do anything.

Now I will explain how to add Oracle ODBC source through the Oracle client.

Step 1, click this link http://www.oracle.com/technetwork/database/10201winsoft-095341.html (this is the official Oracle website) to download the client software.10gFor example, download the 10201_client_win32.zip file.

Step 2: Decompress 10201_client_win32.zip and double-click setup.exe. Then, select the instantclient type, continue to the next step, specify the name andInstallPath, and then click Next to install.

Step 3: Check whether the Oracle ODBC source is in the driver list.

Control Panel-> Administrative Tools-> data source (ODBC), under the 'user DSN 'option, click 'add' to display the following interface:

 

You will find that the name specified when installing the Oracle client, which defaults to oraclient10g_home1, will appear in the name list.

Select oraclient10g_home1 and click Finish. The following figure is displayed: Oracle ODBCDriverConfiguration interface,

Click the TNS service name drop-down box and you will find garbled characters. This indicates that you have not configured TNS.

 

Step 4: configure the tns_admin parameter. It will containDatabaseTnsnames of configuration information. ora, with sqlnet. the path of the ora file, which is set to the value of tns_admin. for example, I put my tnsnames. ora, sqlnet. ora is placed under F: \ oracle \ Network \ admin, then

My computer (right-click)-> system properties-> advanced-> environment variables-> system variables, add

Tns_admin = F: \ oracle \ Network \ admin

Make sure that the path of the system environment variable contains the path of sqora32.dll. For example:

Path:F: \ oracle \ product \ 10.2.0 \ client_1; % SystemRoot % \ system32; % SystemRoot % \ system32 \ WBEM; C: \ Program Files \ common files \ thunder Network \ Kankan \ codecs; % java_home % \ bin; C: \ Program Files \ QuickTime \ qtsystem \

Currently, my sqora32.dll exists in the installation directory of the Oracle client, that isF: \ oracle \ product \ 10.2.0 \ client_1Below.

At the same time, make sure that; % SystemRoot % \ system32; In path.

 

Step 5: After completing the preceding four steps, you can successfully Add the user data source to the ODBC data source.ManagementIn:

Control Panel-> Administrative Tools-> data source (ODBC), under the ''user DSN ''option, click 'add ',

1) Select oracle in your lient10g_home1 and click Finish'

2)DataSource Name. In TNS service name, select a value from the drop-down list box. only Step 4: Set the correct value for tns_admin and tnsnames. ora, sqlnet. when the ora file is correct, the value is displayed in the drop-down box, as shown below:

After adding values, click 'test connection'. On the displayed page, enter your password and press 'OK.

Note: In numeric settings, I chose 'use Microsoft regional settings '.

If you use the default 'use Oracle NLS settings', you need to add a variable to the system environment variable:

Nls_lang

The value depends on the NLS value configured in the database to be connected. You can execute the following in the database to be connected:SQLTo obtain the correct value of nls_lang:

Select userenv ('language') from dual;

For example, my value is:

Nls_lang = american_america.zhs16gbk

After setting this value, re-open the data source (ODBC) interface and add it again.