Print Page | Close Window

'concat' is not a recognized built-in function nam

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=6398
Printed Date: 26 December 2024 at 7:39pm


Topic: 'concat' is not a recognized built-in function nam
Posted By: AccentPhil
Subject: 'concat' is not a recognized built-in function nam
Date Posted: 21 February 2008 at 9:01pm
 
Hello - I just installed the trial version.  I'm pointing the program to a SQL Server 2005 box.  After the install i kept getting different table not found errors in the activity log.  To overcome the issue i excuted the 4 SQLENT queries in sequence. That seemed to resolve all of the problems except the one below.
  
 
Exception occurred during ChecktblReloadTableInfo: [Microsoft][ODBC SQL Server Driver][SQL Server]'concat' is not a recognized built-in function name
 
It acts as if the database is a MYSQL.  I have selected MS SQL Server option a number of times and saved the connection and settings.
 
Any suggestions or ideas?
 
Thanks


Replies:
Posted By: LogSat
Date Posted: 21 February 2008 at 10:33pm
The error appears to indicate that the  wrong driver is being used to connect to the database. Can you please ensure you are 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