ODBC连结问题
我用vb通过ODBC连接oracle9.2.0.1数据库,总是报ODBC连接失败,sqlnet.log文件中包含如下错误***********************************************************************
Fatal OSN connect error 12545, connecting to:
(DESCRIPTION=(CONNECT_DATA=(SID=czcard)(CID=(PROGRAM=vb6.exe)(HOST=CAO_ELSIE)(USER=CAO_ELSIE)))(ADDRESS_LIST=(ADDRESS=(PROTOCOL=ipc)(KEY=czcard))(ADDRESS=(PROTOCOL=TCP)(HOST=44p170)(PORT=1521))))
VERSION INFORMATION:
TNS for 32-bit Windows: Version 2.3.2.1.0 - Production
Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 2.3.2.1.3 - Production
Time: 20-JAN-04 13:42:51
Tracing not turned on.
Tns error struct:
nr err code: 12206
TNS-12206: TNS:在进行导航时接收到 TNS 错误
ns main err code: 12545
TNS-12545: 因目标主机或对象不存在而连接失败
ns secondary err code: 12560
nt main err code: 515
TNS-00515: 因目标主机或对象不存在而连接失败
nt secondary err code: 93
nt OS err code: 0
***********************************************************************
Fatal OSN connect error 12203, connecting to:
(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle80)(ARGV0=oracle80ORCL)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')))(CONNECT_DATA=(SID=ORCL)(CID=(PROGRAM=vb6.exe)(HOST=CAO_ELSIE)(USER=CAO_ELSIE))))
VERSION INFORMATION:
TNS for 32-bit Windows: Version 2.3.2.1.0 - Production
Time: 20-JAN-04 13:42:51
Tracing not turned on.
Tns error struct:
nr err code: 12203
TNS-12203: TNS:不能连接到目标
ns main err code: 12538
TNS-12538: TNS:没有这样的协议适配器
ns secondary err code: 12560
nt main err code: 508
TNS-00508: 没有这样的协议适配器
nt secondary err code: 0
nt OS err code: 0
ODBC driver用的是Microsoft的,通过access连接没问题,请各位高手指教