Dim psCN As New ADODB.Connection
server_name = "mis"
db_pas = "new1"
db_user = "new1"
Set psCN = New ADODB.Connection
psCN.Provider = "MSDAORA"
sConn = "DATA SOURCE=" & server_name & ";"
With psCN
.ConnectionTimeout = 10
.CursorLocation = adUseClient
.Open sConn, db_user,db_pas
End WithpsCN.Open
就这几句话,为什么总是提示出错,Err.Description提示未指定的错误,我真不知错在哪了?
以前连SQL_SERVER时也就是改一下Provider 也就行了。可为啥连ORACLE就不行了,客户端是8.17
,服务端是9I不在本机上。请高手赐教
server_name = "mis"
db_pas = "new1"
db_user = "new1"
Set psCN = New ADODB.Connection
psCN.Provider = "MSDAORA"
sConn = "DATA SOURCE=" & server_name & ";"
With psCN
.ConnectionTimeout = 10
.CursorLocation = adUseClient
.Open sConn, db_user,db_pas
End WithpsCN.Open
就这几句话,为什么总是提示出错,Err.Description提示未指定的错误,我真不知错在哪了?
以前连SQL_SERVER时也就是改一下Provider 也就行了。可为啥连ORACLE就不行了,客户端是8.17
,服务端是9I不在本机上。请高手赐教
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货