1, 下载oracle client,解压到本地,例如:c:\installclient下
2, 单击“开始”->“设置”->“控制面板”->“系统”->“高级”->“环境变量”
3, 添加 PATH 值为 c:\installclient
4, 如果要使用tnsnames.ora还必须添加TNS_ADMIND值为c:\installclient;
5, 设置语言NLS_LANG 值为SIMPLIFIED CHINESE_CHINA.ZHS16GBK
Tnsnames.ora配置(复制该文件到c:\installclient)
localdb =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
)
(CONNECT_DATA =
(SID = mysid)
)
)