Oracle ODBC Configuration

Oracle ODBC Configuration

Win7 64-bit installation of Oracle ODBC you cannot install a data source by using the data source (OBDC) in Administrative Tools, Control Panel.

Instead, enter the C:\Windows\SysWOW64\odbcad32.exe installation data source in run.



Select Add


Select Oracle in oraclient11g_home1 click "Done"


Fill in the data, the TNS Server name format is "ip:port/database name" click "Test Connection"


Fill in the Password and click "OK".

Configuration complete

System variable settings, Chinese garbled solution

1 Viewing character set encoding, starting sqlplus on the database server side

Sql->select userenv (' language ') from dual
Simplified Chinese_china. Zhs16gbk

2 Adding a Nls_lang value to the environment variable of the system is also Simplifiedchinese_china. Zhs16gbk

Oracle ODBC Configuration