Win7 Workarounds for configuring DSN after installing Oracle instantclient ODBC driver SQORAS32

Installation process Brief

The Oracle website has downloaded

instantclient-odbc-nt-12.2. 0.1. 0-2. Zip instantclient-basic-nt-12.2. 0.1. 0. Zip

I am a 32-bit version of Win7, download the corresponding version as needed.

Extract two compressed packets to the same folder Instantclient_12_2 (right-unzip to current folder)

Copy to the "C:\Program files\" folder (this will be placed in the path you need)

Add system environment variable "Oracle_home" (Reference)

The following error occurred while adding DSN:

Workaround :

Download and install: Microsoft Visual C + + 2005 Service Pack 1 Redistributable Package ATL security update

PostScript :

On the environment variables see the online tutorial there are said add 3 article

The test found that only add oracle_home, if there is garbled and Gaga character set environment variables, the second seems to be nothing to use, not set at all

3 environments, respectively, are described above

1.Oracle_home

2.Tns_admin

C:\Program Files\instantclient_12_2\network\admin

3.Nls_lang (Oracle's character set)

Do not know the Oracle language of the remote database, can ssh or telnet to the remote machine, in the command interface input, use the command line to connect to the database to view the command

Select userenv ('language') from dual;

Win7 Workarounds for configuring DSN after installing Oracle instantclient ODBC driver SQORAS32