TAddToQuarantineThread - String data, right trunca |
Post Reply |
Author | |
Rothnie
Newbie Joined: 31 October 2007 Status: Offline Points: 3 |
Post Options
Thanks(0)
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
|
|
LogSat
Admin Group Joined: 25 January 2005 Location: United States Status: Offline Points: 4104 |
Post Options
Thanks(0)
|
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. |
|
Rothnie
Newbie Joined: 31 October 2007 Status: Offline Points: 3 |
Post Options
Thanks(0)
|
Thanks Roberto, that seems to have fixed the problem. Regards,
Rothnie Oosthuizen
|
|
Post Reply | |
Tweet
|
Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |
This page was generated in 0.086 seconds.