Spam Filter ISP Forums : 'concat' is not a recognized built-in function nam

Spam Filter ISP Forums : 'concat' is not a recognized built-in function nam https://www.logsat.com/spamfilter/forums/ Sun, 19 Apr 2026 07:06:38 +0000 Thu, 21 Feb 2008 22:33:30 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 11.04 360 https://www.logsat.com/spamfilter/forums/RSS_post_feed.asp?TID=6398 <![CDATA[Spam Filter ISP Forums]]> https://www.logsat.com/spamfilter/forums/forum_images/web_wiz_forums.png https://www.logsat.com/spamfilter/forums/ <![CDATA['concat' is not a recognized built-in function nam : The error appears to indicate...]]> https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6398&PID=11746&title=concat-is-not-a-recognized-builtin-function-nam#11746 Author: LogSat
Subject: 6398
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.
]]> Thu, 21 Feb 2008 22:33:30 +0000 https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6398&PID=11746&title=concat-is-not-a-recognized-builtin-function-nam#11746 <![CDATA['concat' is not a recognized built-in function nam : Hello - I just installed...]]> https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6398&PID=11744&title=concat-is-not-a-recognized-builtin-function-nam#11744 Author: AccentPhil
Subject: 6398
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

]]> Thu, 21 Feb 2008 21:01:24 +0000 https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6398&PID=11744&title=concat-is-not-a-recognized-builtin-function-nam#11744