xp安装oragle 10g客户端精简版(带odbc驱动),sqlplus ,pl/sql dev均可以正常连接oracle。但配置odbc时提示Unable to connect
SQL State=S1000
[Orcale][ODBC][Ora]ORA-12560: TNS: 协议适配器错误10g客户端精简版没有Net Configuration Assistant配置程序tnsnames.ora,配置如下:
bk =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.222.111.66)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE = DEDICATED)
(SERVICE_NAME = gzxzdb)
)
)
odbcl连接Oracle
SQL State=S1000
[Orcale][ODBC][Ora]ORA-12560: TNS: 协议适配器错误10g客户端精简版没有Net Configuration Assistant配置程序tnsnames.ora,配置如下:
bk =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.222.111.66)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE = DEDICATED)
(SERVICE_NAME = gzxzdb)
)
)
odbcl连接Oracle
很经典的错误。
还有,你自安装后,有无连接成功过??
若,安装后,从未连接成功过,则说明,你的安装有问题有。或有多次安装失败经历。