TNS service names ODBC dropdown box garbled, messed up, gibberish
来源:互联网 发布:金贵软件 编辑:程序博客网 时间:2024/06/05 21:11
2011-09
本文仅记录下我解决ODBC 中向 TNS Service Name 下拉框添加数据库服务器选项的问题。
For example, an Oracle 10 client is installed or Oracle XE is installed. Both contain a home folder with tnsnames.ora. Later, the Oracle 11g instant client + ODBC compontents is added. Now there are two home folders.
In this case, the TNS_ADMIN environment variable needs to exist:
- Create TNS_ADMIN variable via control panel -> system -> advanced -> environment variables -> system variables
- Set is to one of the admin folders, eg.:
TNS_ADMIN=D:/Database_installation/oracle/product/10.2.0/db_1/NETWORK/ADMIN
picturce as
- Note: make sure it contains the tnsnames.ora, sqlnet.ora and listener.ora files.
- Create a ODBC connection using the Oracle driver and check if the "tns service name" dropdown box contains readable entries.
below is my original files
--- tnsnames.ora file------
# tnsnames.ora Network Configuration File: D:/oracle/product/10.2.0/db_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
PROJ35 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.50.0.35)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = proj35)
)
)
dbs107 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.50.0.107)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = dbs107)
)
)
--------------------listener.ora file-----------------
# listener.ora Network Configuration File: D:/oracle/product/10.2.0/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:/Database_installation/oracle/product/10.2.0/db_1)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = ORACLE)
(ORACLE_HOME = D:/Oracle/Oracle10g)
(SID_NAME = ORACLE)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = tidemark.achievo.com)(PORT = 1521))
)
)
- TNS service names ODBC dropdown box garbled, messed up, gibberish
- Dropdown Box Using AJAX
- all the mess, fucking messed up all the fuck things
- Spring MVC dropdown box example
- Blank space issue in tns names ora
- dropdown
- SAP ABAP 使用 Dropdown List Box 的方法
- SAP ABAP 使用 Dropdown List Box 的方法
- @Responsebody utf8 Chinese gibberish
- Net service name, Service name, Sid, TNS
- Garbled character in Vim
- names
- ORA-12519、TNS-12519: TNS:no appropriate service handler found
- ORA-12162: TNS:net service name 解决方案
- jdbc连接数据库sid、service name tns
- Service Principal Names (SPNs) SetSPN Syntax (Setspn.exe)
- Oblivious transfer and Garbled circuits
- Set up Memcached as a service
- 有关rowNum
- 百度 跟 腾讯 谁 更危险?
- OleLoadPicture解释
- 数据库水平切分的原理探讨、设计思路--数据库分库,分表,集群,负载均衡器
- Annotation的Struts2.0+Hibernate3.3+Spring2.5整合开发(1)
- TNS service names ODBC dropdown box garbled, messed up, gibberish
- 关于接口的传递
- 分布式数据库拆表拆库的常用策略
- 非模态对话框的特点与使用
- 多重继承派生类的构造函数
- 【shell 】传递参数中包括引号
- win7中安装11gR2注意事项
- 创建二叉树
- 北京nec药局管理系统