Announcement

Collapse

Contacting HomeSeer This Week

HomeSeer is open and operational this week. All orders are being processed and shipped as usual. However, some staff are working from home. If you need to contact HomeSeer for support or customer service, please use our Email or Chat options. https://homeseer.com/contact-us/
See more
See less

Database errors...

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Database errors...

    Blade,

    I've just installed the router traffice monitor plug-in and I'm having trouble getting it setup. I have a WRT54G and I'm using Hyperwrt. I'm using HS 2.0.2020.0. Any suggestions as to why I'm getting this error???

    Thanks for your help,
    Jerry


    <TABLE cellSpacing=2 cellPadding=0 width="100%" border=0><TBODY><TR><TD class=LOGDateTime0 noWrap align=left>11/28/2005 6:33:56 AM </TD><TD class=LOGType0 align=left colSpan=3>Router Traffic Monitor Error </TD><TD class=LOGEntry0 align=left colSpan=8>DatabaseFunctions.PerformDatabaseMultiSelect(): An error has occurred during database select query: ERROR [42S02] [Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot find the input table or query 'tblComputers'. Make sure it exists and that its name is spelled correctly.</TD></TR><TR><TD class=LOGDateTime1 noWrap align=left>11/28/2005 6:33:56 AM </TD><TD class=LOGType1 align=left colSpan=3>Router Traffic Monitor Error </TD><TD class=LOGEntry1 align=left colSpan=8>DatabaseFunctions.PerformDatabaseMultiSelect(): DatabasePathAndName: C:\Program Files\HomeSeer 2\Data\RouterTrafficMonitor\RouterTrafficMonitor.mdb</TD></TR><TR><TD class=LOGDateTime0 noWrap align=left>11/28/2005 6:33:56 AM </TD><TD class=LOGType0 align=left colSpan=3>Router Traffic Monitor Error </TD><TD class=LOGEntry0 align=left colSpan=8>DatabaseFunctions.PerformDatabaseMultiSelect(): connString: DSN=RouterTrafficMonitor</TD></TR><TR><TD class=LOGDateTime1 noWrap align=left>11/28/2005 6:33:56 AM </TD><TD class=LOGType1 align=left colSpan=3>Router Traffic Monitor Error </TD><TD class=LOGEntry1 align=left colSpan=8>DatabaseFunctions.PerformDatabaseMultiSelect(): selectQueryString: SELECT txtName,txtIPAddress FROM tblComputers ORDER BY txtIPAddress</TD></TR></TBODY></TABLE>

  • #2
    Hi Jerry

    It sounds like you are missing the tblComputers table. Not sure how that is.

    Try going into Microsoft Access and create a query and execute this SQL from the query. This will create the tblComputers table

    CREATE TABLE tblComputers (txtIPAddress TEXT(20) Constraint txtIPAddress Primary Key, txtName TEXT(40) NOT NULL, txtLocation TEXT(60), txtMacAddress TEXT(25), txtOnImage TEXT(100), txtOffImage TEXT(100), txtCustom TEXT(5) NOT NULL, txtEmailNotify TEXT(5) NOT NULL, txtPingFailures TEXT(5) NOT NULL )


    Let me know if this fixes the issue.
    Cheers,
    Bob
    Web site | Help Desk | Feature Requests | Message Board

    Comment


    • #3
      Jerry,

      Did you get this resolved?
      Cheers,
      Bob
      Web site | Help Desk | Feature Requests | Message Board

      Comment


      • #4
        I haven't had a chance to get into it, but I thought I would take the .mdb file out of the zip file and install it over the other one. That should work okay.

        Thanks for asking.

        Jerry

        Comment

        Working...
        X