請問各位大大:目前我採用VB結合MySQL當我的table建立完成並且寫入兩筆資料第一筆資料的位元數比第二筆還少的時後會出現-2147217887項的錯誤不知道是否有人遇到過這樣的問題,還請各位大大為告訴我我是使用ado2.0並安裝mysqlodbc之驅動程式我的程式片段如下
Dim strConnect As String
On Error GoTo err
strConnect = "driver={MySQL};server=" & GSystemVar.ServerIP & ";uid=" & GSystemVar.LoginName & ";pwd=" & GSystemVar.Passwd & ";database=" &GSystemVar.DataBaseName
 Set adoDataConn = New ADODB.Connection
 adoDataConn.CursorLocation = adUseClient
 adoDataConn.Open strConnect
 Set rsRecordSet = New ADODB.Recordset
 rsRecordSet.CursorType = adOpenDynamic
 rsRecordSet.CursorLocation = adUseClient
 rsRecordSet.LockType = adLockOptimistic
 rsRecordSet.Source = "Select * From tRyan"
 rsRecordSet.ActiveConnection = adoDataConn
 rsRecordSet.Open
 rsRecordSet.AddNew
 rsRecordSet.Fields("LoginName") = "123456"
 rsRecordSet.Update
 adoDataConn.Close
 Set adoDataConn = Nothing
Exit Function

err:
MsgBox "資料庫處理發生錯誤" & err.Number, vbOKOnly
 Exit Function

arrow
arrow
    全站熱搜

    vbqa 發表在 痞客邦 留言(2) 人氣()