Results 1 to 7 of 7
  1. #1
    Join Date
    Dec 2003
    Posts
    5

    Unanswered: ADODB.Recordset error '800a0e7d'

    I am trying to cretae a tools that accesses the 200 2003 eventlogs from WMI and keep running into this error I know it has to do with my connction to the msaccess db yet the string is corect and permissions are wide open any ideas?

    <%
    Const adOpenStatic = 3
    Const adLockOptimistic = 3
    Const adUseClient = 3
    Set objConnection = CreateObject("ADODB.Connection")
    Set objRecordset = CreateObject("ADODB.Recordset")
    objConnection.Open "DSN=eventlogs;"
    objRecordset.CursorLocation = adUseClient
    objRecordset.Open "SELECT * FROM EVENTLOG WHERE RECID = RECID) (objConnection) "
    adOpenStatic, adLockOptimistic
    Set colNTLogEvent = GetObject("winmgmts:").ExecQuery _
    ("Select * from Win32_NTLogEvent")
    For Each wmiRecord In wmiResultSet
    objRecordset.AddNew
    objRecordset("EDATE") = dtDate
    objRecordset("ETIME") = dtTime
    objRecordset("sourceName") = wmiRecord.SourceName
    objRecordset("eventcode") = wmiRecord.EventCode
    objRecordset("MESSAGE") = wmiRecord.Message


    objRecordset.Update
    Next
    objRecordset.Close
    objConnection.Close
    %>

  2. #2
    Join Date
    Mar 2003
    Location
    Atlanta, GA
    Posts
    191

    Re: ADODB.Recordset error '800a0e7d'

    [i]objRecordset.Open "SELECT * FROM EVENTLOG WHERE RECID = RECID) (objConnection) "
    adOpenStatic, adLockOptimistic
    %>

    Don't know if this is your only issue... but try...

    objRecordset.Open "SELECT * FROM EVENTLOG WHERE RECID =" & RECID, objConnection, adOpenStatic, adLockOptimistic

    assuming that RecID is a numeric value rather than a string.
    Tim

  3. #3
    Join Date
    Dec 2003
    Posts
    5

    Red face Re: ADODB.Recordset error '800a0e7d'

    Originally posted by MrWizard
    Don't know if this is your only issue... but try...

    objRecordset.Open "SELECT * FROM EVENTLOG WHERE RECID =" & RECID, objConnection, adOpenStatic, adLockOptimistic

    assuming that RecID is a numeric value rather than a string.
    Itried it still didn't work so I went a different way and I get this even though everything is correct even the database.

    any suggestions

    Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

    [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression ''Windows saved user VERIZON-WMIDEV\Administrator registry while an application or service was still using the registry during log off. The memory used by the user's registry has not been freed. The registry will be unloaded when it is no longer in use. '.

    /admin/getevents.asp, line 26

    And this is my code next reply

  4. #4
    Join Date
    Feb 2002
    Posts
    2,232
    What happens if you handle this error and continue the code ?

  5. #5
    Join Date
    Dec 2003
    Posts
    5
    The forum would not let me post more information about this problem
    I am capturing eventlogs to an access 2002 db it completes its purpose and errors out with the error I can look in the database and my information is there yet I still recieve the error.

  6. #6
    Join Date
    Feb 2002
    Posts
    2,232
    According to what I have seen from ms, you can ignore this message ...

  7. #7
    Join Date
    Dec 2003
    Posts
    5
    Yes I heard this too yet it leaves a nasty error on the page.
    Is there a way for me to tell it when it completes to write something to the page that would hide this error I am seeing.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •