We run SpamFilter (latest build 206, registered version), quarantining to a Microsoft SQL 7 database server.  MDAC 2.7 SP1.  We run the app, not the service.  Our connect string is saved in a .udl file, as per SpamFilter guidelines.

Every time that we shutdown SpamFilter for any reason -- server reboot, shutdown to install the latest executable, etc. -- we must manually reconnect to the database after we start SpamFilter.  Sure, it's easy to do (just 3 clicks)... click Quarantine DB, click the "Step 3" tab, then click the "Save & Activate Conn String" button.  Still, it's just another thing that we have to remember to do after starting the application.  The other day, I forgot, and until I discovered my mistake a half-hour later, messages were being rejected but not quarantined.

My question is this: is there a way to set SpamFilter up to connect automatically to the database, using the connect string saved in the .udl file... as soon as the application is started, WITHOUT having to click -- click -- click to reactivate the connection to the database?

If there's already a way to do this, and I've somehow missed it, let me know... but if there's not currently a way to do this, could a "connect automatically on program launch" option be added in a near-future release?

Thanks

Dan,

Thanks for the info... but everything appears to be OK here.  tblServersServerID=1, and there is a single record in tblServers that matches (ServerID = 1, ServerName = 'SF1').  We run only this single SpamFilter server.

Jim

Roberto,

I just now took the following steps.

1. Shut down the SpamFilter app., and waited approximately 15 seconds.
2. Restarted the SpamFilter app.
3. Navigated to the Settings - Quarantine DB page.  The text on the right side of this page reads "The Quarantine DB is not active" and the other controls in this window (number of days, quarantine interval) are disabled (grayed out).
4. Clicked on the "Step 3" tab on the left side of the screen.
5. Clicked the "Save & Activate Conn String" button.
6. The text on the right side of the page immediately changes to "The Quarantine DB is active" and the controls are enabled.

Thanks,

Jim

Roberto,

Actually, there was not a problem with the table schema, but somehow SELECT permission did not get set on tblServers.  The "Step 2" screen did indeed detect this problem.  Once I corrected the permissions on the table, everything works great.

Thanks,

Jim