Sub connectTOORACLE()
Dim strconnt As String
Dim connt As ADODB.Connection
Set connt = New ADODB.Connection
Dim rs As Object
Set rs = New ADODB.Recordset
Dim sevip, Db, user, pwd As String
'设服务器地址、所连数据,及登录用户密码
sevip = "192.168.10.251"
Db = "test251"
user = "test0804"
pwd = "hr654"
strconnt = "rovider=OraOLEDB.Oracle;sevip=192.168.10.251assword=hr654;User ID=test0804;Data Source=test251;"
connt.ConnectionString = strconnt
connt.Open
Dim rsPubs As ADODB.Recordset
Set rsPubs = New ADODB.Recordset
With rsPubs
' Assign the Connection object.
.ActiveConnection = connt
' Extract the required records.
.Open "select * from sm_user where user_name like '刘%'"
' Copy the records into cell A1 on Sheet1.
Sheet3.Range("A1").CopyFromRecordset rsPubs
' Tidy up
.Close
End With
connt.Close
Set rsPubs = Nothing
Set connt = Nothing
End Sub用Provider=OraOLEDB.Oracle能够连接ORACLE,并查询出数据;而用DRIVER={Microsoft ODBC for Oracle}代替却无法连接ORACLE.请教是什么原因?