Spam Filter ISP Support Forum

  New Posts New Posts RSS Feed - Bug with built in Access DB
  FAQ FAQ  Forum Search   Register Register  Login Login

Bug with built in Access DB

 Post Reply Post Reply
Author
corymckee View Drop Down
Newbie
Newbie


Joined: 10 June 2007
Status: Offline
Points: 31
Post Options Post Options   Thanks (0) Thanks(0)   Quote corymckee Quote  Post ReplyReply Direct Link To This Post Topic: Bug with built in Access DB
    Posted: 10 June 2007 at 10:44am

I tried to connect to the access DB and I get an error on setup when pointing to the Access DB.

Error updading/checking TblReloadTableInfo - The Microsoft Jet database engine cannot find the input table or query 'tbl_localdomains'.  Make sure it exists and that its name is spelled correctly

ERROR - Some fields are missing from the tables!
Please proceed to Step 2-b to add missing fields
Done.

2b shows nothing and the activity log shows "Exception occurred during ChecktblReloadTableInfo: Syntax error (missing operator) in query expression 'tblreloadtableinfo where id > (select min(id) from tblreloadtableinfo t where (t.domainid = tblreloadtableinfo.domainid) and (t.tablename = tblreloadtableinfo.tablename))'"

Please advise.

Back to Top
LogSat View Drop Down
Admin Group
Admin Group
Avatar

Joined: 25 January 2005
Location: United States
Status: Offline
Points: 4065
Post Options Post Options   Thanks (0) Thanks(0)   Quote LogSat Quote  Post ReplyReply Direct Link To This Post Posted: 10 June 2007 at 11:26am
SpamFilter Enterprise does not support a MSAccess database. Only Microsoft SQL Server and MySQL are supported database platforms for SpamFilter Enterprise.

MS Access and Oracle can only be used by SpamFilter ISP in "Standard" mode (non-Enterprise mode).
Roberto Franceschetti

LogSat Software

Spam Filter ISP
Back to Top
corymckee View Drop Down
Newbie
Newbie


Joined: 10 June 2007
Status: Offline
Points: 31
Post Options Post Options   Thanks (0) Thanks(0)   Quote corymckee Quote  Post ReplyReply Direct Link To This Post Posted: 10 June 2007 at 11:28am
Thank you. I will test with MSSQL instead.
Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down



This page was generated in 0.078 seconds.