SitePoint Sponsor

User Tag List

Results 1 to 10 of 10
  1. #1
    SitePoint Enthusiast
    Join Date
    Jan 2007
    Posts
    25
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Internal OLE Automation Error

    Hello

    I'm getting following error in some of my asp scripts:

    80040e07|[Microsoft][ODBC_Microsoft_Access_Driver]_Internal_OLE_Automation_error
    (it was taken out of IIS error log)

    and in every case it points to an SQL query. But all of these queries seem to work fine when I execute them directly in MS Access. Here are some of them:

    for example these 2 work fine:
    Code VB:
    rs.open "SELECT *, t_users.n_id as user_id FROM t_users, t_groups, t_departments, t_rights " &_
            "WHERE t_departments.n_id = t_groups.n_department AND t_users.n_group = t_groups.n_id AND " &_ 
            "t_users.n_rights = t_rights.n_id AND s_login = '" & logon & "';", dc
    rs.open "SELECT * FROM t_rights WHERE t_rights.n_id = " & n_rights & ";", dc
    and this one caused the error(the one that was mentioned in the error log):
    Code VB:
    rs.open "SELECT * FROM t_symbols WHERE n_access <= " & n_rights & ";", dc

    It's driving me crazy, I would really appreciate any kind of help.
    Thanks

  2. #2
    SitePoint Wizard bbolte's Avatar
    Join Date
    Nov 2001
    Location
    The Central Plains
    Posts
    3,304
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    do you have correct permissions to read the Access DB? what kind of connection are you using to the db?

  3. #3
    SitePoint Enthusiast
    Join Date
    Jan 2007
    Posts
    25
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    security permissions are set to read,write,modify,read&execute for "Everyone".

    I connect to db like this:
    Code VB:
    Set dc = server.CreateObject("ADODB.Connection")
    dc.open "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Session("serverDataPath") &"\attendance.mdb"
    Set rs = server.CreateObject("ADODB.Recordset")
    rs.open ...

    Thanks

  4. #4
    SitePoint Enthusiast
    Join Date
    Jan 2007
    Posts
    25
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    anyone?

  5. #5
    SitePoint Guru SSJ's Avatar
    Join Date
    Jan 2007
    Posts
    830
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Which Error are you getting on your ASP page?

  6. #6
    SitePoint Enthusiast
    Join Date
    Jan 2007
    Posts
    25
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Microsoft OLE DB Provider for ODBC Drivers error '80040e07'

    [Microsoft][ODBC Microsoft Access Driver] Internal OLE Automation error

    /"filename".asp , line "linenumber"

    linenumber always points to an SQL query, examples above

  7. #7
    SitePoint Guru SSJ's Avatar
    Join Date
    Jan 2007
    Posts
    830
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Try This Code:

    rs.open "SELECT * FROM t_symbols WHERE n_access <= " & n_rights & "", dc

  8. #8
    SitePoint Enthusiast
    Join Date
    Jan 2007
    Posts
    25
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    nah, thats not it, but thanks for an advice

  9. #9
    SitePoint Enthusiast
    Join Date
    Jan 2007
    Posts
    25
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    anyone else?

  10. #10
    SitePoint Enthusiast
    Join Date
    Jan 2007
    Posts
    25
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    this problem seems to be fixed now
    I believe the problem was in IIS settings in application pool


Bookmarks

Posting Permissions

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