Print Page | Close Window

access database through odbc become nonresponsive

Printed From: LogSat Software
Category: Spam Filter ISP
Forum Name: Spam Filter ISP Support
Forum Description: General support for Spam Filter ISP
URL: https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=1089
Printed Date: 26 December 2024 at 6:28pm


Topic: access database through odbc become nonresponsive
Posted By: dcook
Subject: access database through odbc become nonresponsive
Date Posted: 25 June 2003 at 10:44am

I installed the new Spamfilter v1.20.167 this morning -- love the new features.

I found a glitch in the quarantine database area.  I fully intend to use mysql but started with access.  I set up an odbc connection and connected spam filter. It ran great, much faster!  I later released (delivered) a quarantined item and then I noticed the buttons are greyed out so that items can not be sorted, deleted or delivered.

 


Replies:
Posted By: Guests
Date Posted: 25 June 2003 at 11:24am

take a look at:

http://www.logsat.com/spamfilter/forums/showmessage.asp?messageID=955" CLASS="ASPForums" TITLE="WARNING: URL created by poster. - http://www.logsat.com/spamfilter/forums/showmessage.asp?messageID=955" CLASS="ASPForums" TITLE="WARNING: URL created by poster. - http://www.logsat.com/spamfilter/forums/showmessage.asp?messageID=955


Posted By: dcook
Date Posted: 25 June 2003 at 11:35am
Thanks -- I didn't see that. 

Posted By: dcook
Date Posted: 25 June 2003 at 11:45am

I tried updating the MDAC to 2.7 and my buttons are still unavailable.

 

Posted By: LogSat
Date Posted: 25 June 2003 at 12:23pm

There are some issues with the MDAC components and Access when there are fewer than 50-100 elements in the quarantine. We'll try to fix this as soon as possible.

Roberto F.
LogSat Software

Posted By: dcook
Date Posted: 25 June 2003 at 1:45pm

You should know that I have over 275 entries in the quarantine.  If I restart the spamfilter service I get all 3 buttons.  After I refresh, I see quarantined files but can't sort and the buttons are greyed out.

Thanks.

 

Posted By: Guests
Date Posted: 25 June 2003 at 4:01pm
I set up mysql and the problems went away. It works.

Posted By: Guests
Date Posted: 26 June 2003 at 12:31pm

For what it's worth, I had the same problem.

I switched to MS SQL Server, works fine now.


Print Page | Close Window