Kh?c ph?c: "?i t?ng khng h?p l? ho?c khng c?n ?t" l?i v?i Microsoft Jet

D?ch tiu ? D?ch tiu ?
ID c?a bi: 304536
Bung t?t c? | Thu g?n t?t c?

TRI?U CH?NG

Khi m? v ng c?a cc k?t n?i ho?c recordsets b?ng cch s? d?ng tr?nh i?u khi?n ODBC Microsoft Access ho?c cc Microsoft OLE DB Provider cho my bay ph?n l?c, l?i sau y c th? ?c bo co:
?i t?ng khng h?p l? ho?c khng c?n ?t.
Sau khi l?i ny bo co, khng c nhi?u recordsets ho?c cc k?t n?i c th? ?c m? ra t? qu tr?nh.

Thng i?p l?i c th? khc thng bo l ?ng d?ng khch bao g?m:
Qu nhi?u b?ng m?.
Khng th? m? b?t k? bn nhi?u hn n?a.

GI?I PHP

? gi?i quy?t v?n ? ny, ci ?t Microsoft ph?n l?c 4,0 service pack m?i nh?t 6. bit thm thng tin, bm vao s bai vit sau xem bai vit trong C s Kin thc Microsoft:
239114Lm th? no ?: C ?c gi d?ch v? m?i nh?t cho c s? d? li?u Microsoft Jet 4,0

T?NH TR?NG

Microsoft ? xc nh?n r?ng y l m?t v?n ? trong cc s?n ph?m c?a Microsoft ?c li?t k ? ?u bi vi?t ny. V?n ? ny ? ?c c? ?nh trong my bay ph?n l?c 4,0 Service Pack 6 (SP6).

THNG TIN THM

? t?o l?i v?n ?, h?y ch?y sau Microsoft Visual Basic for Applications (VBA) code:
Public Sub Jet_TableID_Repro()
Dim conn As ADODB.Connection
Dim cmd As ADODB.Command
Dim rs As ADODB.recordset
Dim i As Long
    
    Set conn = New ADODB.Connection
    ' Modify this connection string to point to some blank database.
    conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\YourTestDatabase.mdb;"
    
    ' Drop and re-create test query.
    On Error Resume Next
    conn.Execute "drop procedure sp_param_test", , adExecuteNoRecords
    On Error GoTo 0
    conn.Execute "create procedure sp_param_test as " & _
                 "parameters iInput Long; " & _
                 "select iInput as iOutput;", , adExecuteNoRecords
    
    For i = 1 To 10000

        ' Code should fail at around 2000-3000 iterations.
        Set rs = New ADODB.recordset
        Set cmd = New ADODB.Command
        Set cmd.ActiveConnection = conn
        cmd.CommandType = adCmdStoredProc
        cmd.CommandText = "sp_param_test"
        cmd.Parameters.Append cmd.CreateParameter("iInput", adInteger)
        cmd.Parameters(0).value = 12

        ' This will fail at around 2000-3000 iterations.
        rs.Open cmd, , adOpenKeyset, adLockOptimistic
        Set cmd = Nothing
        Debug.Print i
        DoEvents
        rs.Close
        Set rs = Nothing

    Next i

End Sub
				

Thu?c tnh

ID c?a bi: 304536 - L?n xem xt sau cng: 27 Thang Tam 2011 - Xem xt l?i: 2.0
T? kha:
kbhotfixserver kbqfe kbjet kbprb kbmt KB304536 KbMtvi
My d?ch
QUAN TRONG: Bi vi?t ny ?c d?ch b?ng ph?n m?m d?ch my c?a Microsoft ch? khng ph?i do con ng?i d?ch. Microsoft cung c?p cc bi vi?t do con ng?i d?ch v c? cc bi vi?t do my d?ch ? b?n c th? truy c?p vo t?t c? cc bi vi?t trong C s? Ki?n th?c c?a chng ti b?ng ngn ng? c?a b?n. Tuy nhin, bi vi?t do my d?ch khng ph?i lc no c?ng hon h?o. Lo?i bi vi?t ny c th? ch?a cc sai st v? t? v?ng, c php ho?c ng? php, gi?ng nh m?t ng?i n?c ngoi c th? m?c sai st khi ni ngn ng? c?a b?n. Microsoft khng ch?u trch nhi?m v? b?t k? s? thi?u chnh xc, sai st ho?c thi?t h?i no do vi?c d?ch sai n?i dung ho?c do ho?t ?ng s? d?ng c?a khch hng gy ra. Microsoft c?ng th?ng xuyn c?p nh?t ph?n m?m d?ch my ny.
Nh?p chu?t vo y ? xem b?n ti?ng Anh c?a bi vi?t ny:304536
Khc t Ni dung trong C s Kin thc Khng con c h tr
Bi vi?t ny ni v? cc s?n ph?m m Microsoft khng c?n h? tr? n?a. Do , bi vi?t ny ?c cung c?p "nguyn b?n" v s? khng ?c c?p nh?t.

Cung cp Phan hi

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com