应该是rs.open "select * from aa",cn,adOpenDynamic,adLockOptimistic ,adcmdtext 试试看
应该是:rs.open "select * from aa",cn,adOpenDynamic,adOptimistic ,adcmdtext 试试看
说当前recordset不支持更新,或选定的锁定类型限制的
用sql 语句呀 添加 sql="Insert Into aa values (...)" cn.execute sql,,adcmdtext
Public Function oracleconnect(sServer As String, sLoginID As String, sPassword As String) As ADODB.Connection On Error GoTo erroracleconnect Dim cn As New ADODB.Connection Dim mystring As String mystring = "Provider=OraOLEDB.Oracle.1;Password='" & sPassword & "'; " & _ "Persist Security Info=True;User ID= " & _ " '" & sLoginID & " '" & _ ";Data Source=""" & sServer & """" cn.ConnectionString = mystring cn.Open Set oracleconnect = cn Exit Function erroracleconnect: MsgBox Error, vbInformation End Function
Dim myrec As ADODB.Recordset dim sql as string Set G_cn2 = oracleconnect(is_service2, is_sysname, is_syspassword) sql = "select name ,deputy,jfz,jfh,...from " & tableuser & ".serv," & tableuser & ".serv_indiv where serv.serv_id=serv_indiv.serv_id " myrec.Open sql, G_cn2, adOpenDynamic
rs.open "select * from aa",cn,adOpenDynamic,adLockBatchOptimistic ,adcmdtext
不知对不?
试试看
试试看
添加 sql="Insert Into aa values (...)"
cn.execute sql,,adcmdtext
On Error GoTo erroracleconnect
Dim cn As New ADODB.Connection
Dim mystring As String
mystring = "Provider=OraOLEDB.Oracle.1;Password='" & sPassword & "'; " & _
"Persist Security Info=True;User ID= " & _
" '" & sLoginID & " '" & _
";Data Source=""" & sServer & """"
cn.ConnectionString = mystring
cn.Open
Set oracleconnect = cn
Exit Function
erroracleconnect:
MsgBox Error, vbInformation
End Function
dim sql as string
Set G_cn2 = oracleconnect(is_service2, is_sysname, is_syspassword)
sql = "select name ,deputy,jfz,jfh,...from " & tableuser & ".serv," & tableuser & ".serv_indiv where serv.serv_id=serv_indiv.serv_id "
myrec.Open sql, G_cn2, adOpenDynamic
接下去的操作(如增加、修改等)与连接到SQLSERVER数据库的操作是一样的。另外请注意,sqlserver与oracle两者的SQL描述差别很大。
Rs.CursorLocation = adUseClient