vba连接Oracle问题
vba连接Oracle10g后执行SQL语句,没有数据!代码如下:
Private conConnection As ADODB.Connection
Public rct As New ADODB.Recordset
Set conConnection = New ADODB.Connection
conConnection.ConnectionString = "ODBC;DRIVER={Oracle in OraDb10g_home1};UID=FAIR;PWD=fair;Data Source=fair;Persist Security Info=True"
conConnection.ConnectionTimeout = 30
conConnection.Open
Set rct = conConnection.Execute("SELECT levelID,levelName FROM abilitylevel")
MsgBox "Records:" & rct.RecordCount
执行后,显示的RecordCount为-1,但是用Oracle客户端查询表里是有记录的!该怎么解决阿??请指教,谢谢!