Print Page | Close Window

TAddToQuarantineThread - String data, right trunca

Printed From: LogSat Software
Category: Spam Filter ISP
Forum Name: Spam Filter ISP Support
Forum Description: General support for Spam Filter ISP
URL: http://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6968
Printed Date: 16 December 2017 at 5:44pm


Topic: TAddToQuarantineThread - String data, right trunca
Posted By: Rothnie
Subject: TAddToQuarantineThread - String data, right trunca
Date Posted: 07 July 2011 at 3:29am
Good day.
 
The error below keeps showing up in our Spamfilter activity log and there are a queue of files building up in the Quarantine directory.
 
TAddToQuarantineThread when accessing the quarantine database: [Microsoft][ODBC SQL Server Driver]String data, right truncation ( 1 83 84 85 86 86a 86b 86c 87 88 89 90 91 92 93 94 94b)
 
How do I resolve this?
 
Regards,
Rothnie Oosthuizen



Replies:
Posted By: LogSat
Date Posted: 07 July 2011 at 10:43pm
From the description, this may be an issue caused by the ODBC driver for SQL Server (your connection string appears to use the "Microsoft OLE DB Provider for ODBC Drivers"). Instead of creating an ODBC DSN entry in the ODBC Data Sources, can you please change your database connection string to use the "Microsoft OLE DB Provider for SQL Server" instead (see screenshot)? This will bypass the ODBC DSNs, and will allow you to specify directly the SQL connection settings.

Alternatively, you could use a UDL file to specify the connection. However, in the UDL file please make sure you select the OLE DB Provider for SQL Server to avoid causing the same issues. There is a sample UDL file for SQL Server you can use as a template to customize in the \SpamFilter\database folder.




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

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

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


Posted By: Rothnie
Date Posted: 08 July 2011 at 5:34am

Thanks Roberto, that seems to have fixed the problem.

Regards,
Rothnie Oosthuizen



Print Page | Close Window