Print Page | Close Window

Spamfilter Enterprise & SQL Server 2005

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=6535
Printed Date: 15 March 2025 at 7:58am


Topic: Spamfilter Enterprise & SQL Server 2005
Posted By: ceshe@interyx.net
Subject: Spamfilter Enterprise & SQL Server 2005
Date Posted: 07 August 2008 at 7:14pm
I have a new install of server 2003 with a new install of ms sql 2005. I have setup a spamfile database in SQL and created an odbc connection. when I check connection all is good. when i follow the three steps in setting up the data base I get a bunch of errors. is there any new scripts for 2005 or a better set of setup instructions im missing? 

-------------
Clay



Replies:
Posted By: LogSat
Date Posted: 07 August 2008 at 9:46pm
Clay,

Can you please try using OLE DB to connect to the Microsoft SQL database, and not the older ODBC driver? We provide a sample UDL file:
\SpamFilter\database\SpamFilterMSSQL.UDL
That can be used as a starting point to specify the database connection to your SQL Server.
You can then specify that UDL file in SpamFilter's database connection string.


-------------
Roberto Franceschetti

http://www.logsat.com" rel="nofollow - LogSat Software

http://www.logsat.com/sfi-spam-filter.asp" rel="nofollow - Spam Filter ISP



Print Page | Close Window