Oracle Run Time Error'2147467259（80004005）'ORA-12541：TNS：没有听众 [英] Oracle Run Time Error'2147467259(80004005)' ORA-12541: TNS: no listener

问题描述

我正在将vb6.0应用程序与Oracle 11Gg DB连接，产生错误：



运行时错误'2147467259（80004005）'ORA-12541：TNS：没有听众，



我已经开始使用听众服务但是仍然无法正常工作

 私有  Sub  Form_Load（）
  Dim  rs  As   New  ADODB.Recordset 
 设置 oconn = 新 ADODB.Connection 
 oconn.Open   Provider = msdaora.1; Data Source = 192.168.1.46; User Id = MaintBr_Electric; Password = sa; Persist Security Info = True 
 rs.CursorType = adOpenStatic 
 
 rs.CursorLocation = adUseClient 
 rs.LockType = adLockOptimistic 
 rs.Open strSQL，oconn ,,, adCmdText 
 设置 DataGrid1.DataSource = rs 

解决方案

我几乎可以肯定你的连接字符串是错的，或者服务器是没有回应。



如需了解更多信息，请参阅：

http://www.connectionstrings.com/oracle/ [ ^ ]

**疑难解答**'ORA- 12541：TNS：没有监听器错误，例如在事件日志中[ ^ ]

ORA-12541：TNS：没有听众 [ ^ ]

ORA -12541_TNS_no_listener [ ^ ]

与Oracle的ADO连接会收到侦听器错误，但仅限于前几次尝试 [ ^

I am connecting vb6.0 application with Oracle 11Gg DB, generating an error:

Run Time Error'2147467259(80004005)' ORA-12541: TNS: no listener,

I Have Started Listener services but it still not working

Private Sub Form_Load()
Dim rs As New ADODB.Recordset
Set oconn = New ADODB.Connection
oconn.Open "Provider=msdaora.1;Data Source=192.168.1.46;User Id=MaintBr_Electric;Password=sa;Persist Security Info=True"
rs.CursorType = adOpenStatic

rs.CursorLocation = adUseClient
rs.LockType = adLockOptimistic
rs.Open strSQL, oconn, , , adCmdText
Set DataGrid1.DataSource = rs

解决方案

I'm almost sure your connection string is wrong or server does not respond.

For further information, please see:
http://www.connectionstrings.com/oracle/[^]
** Troubleshooting ** 'ORA-12541: TNS:no listener' errors, for example inside Event Log[^]
ORA-12541: TNS: no listener[^]
ORA-12541_TNS_no_listener[^]
ADO connection to Oracle gets a listener error, but only on the first few attempts[^]

这篇关于Oracle Run Time Error'2147467259（80004005）'ORA-12541：TNS：没有听众的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！