Spam Filter ISP Support Forum

  New Posts New Posts RSS Feed - TAddToQuarantineThread - String data, right trunca
  FAQ FAQ  Forum Search   Register Register  Login Login

TAddToQuarantineThread - String data, right trunca

 Post Reply Post Reply
Author
Rothnie View Drop Down
Newbie
Newbie
Avatar

Joined: 31 October 2007
Status: Offline
Points: 3
Post Options Post Options   Thanks (0) Thanks(0)   Quote Rothnie Quote  Post ReplyReply Direct Link To This Post Topic: TAddToQuarantineThread - String data, right trunca
    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
Back to Top
LogSat View Drop Down
Admin Group
Admin Group
Avatar

Joined: 25 January 2005
Location: United States
Status: Offline
Points: 4104
Post Options Post Options   Thanks (0) Thanks(0)   Quote LogSat Quote  Post ReplyReply Direct Link To This Post 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

LogSat Software

Spam Filter ISP
Back to Top
Rothnie View Drop Down
Newbie
Newbie
Avatar

Joined: 31 October 2007
Status: Offline
Points: 3
Post Options Post Options   Thanks (0) Thanks(0)   Quote Rothnie Quote  Post ReplyReply Direct Link To This Post Posted: 08 July 2011 at 5:34am

Thanks Roberto, that seems to have fixed the problem.

Regards,
Rothnie Oosthuizen
Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down



This page was generated in 0.086 seconds.