I've noticed that my SQL quarantine is growing and that messages are not being purged. I found that purging the quarantine on a SQL database is not yet implemented.

01/19/04 12:41:47:023 -- Exception occurred during DoDeleteExpiredQuarantineList: [Microsoft][ODBC SQL Server Driver]Optional feature not implemented

How can I purge the quarantine for anything older than say 2 days? I have that marked in the Settings Quarantine DB tab. It's set to purge older than 2 days every 6 hours. Obviously it's not.

bill

Roberto has responded, but just to add my two cents...

We have run into the "Optional feature not implemented" error message in the past, not with SpamFilter but with other applications that utilized an ODBC connection to SQL Server.  The issue usually involves compatibility issues that are introduced, or implicit data conversions that are not properly supported, by the ODBC driver itself.  Updating to a recent MDAC release "magically" resolves many of these issues.  If you're already on MDAC 2.7 SP1 or better, then you may need to look elsewhere... otherwise, you'd be well-advised to make this upgrade your next step in troubleshooting.

We are currently running MDAC 2.8 with a current licensed SpamFilter build, and having no problems at all with quarantine purge or any other database-related issues for that matter.

MDAC downloads, an article on how to check for your MDAC vesion, and other MDAC stuff can be found at: http://support.microsoft.com/default.aspx?scid=fh;EN-US;mdac

Hi Roberto,

I upgraded to MDAC 2.8 last night using Spam Filter x.206, the latest published/registered release, with SQL 2000. I updated the MDAC on the box running Spam Filter, but did not upgrade the MDAC on the SQL server, should I upgrade it there as well?

bill