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
Printed Date: 19 December 2018 at 5:24am

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?

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:
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" rel="nofollow - LogSat Software" rel="nofollow - Spam Filter ISP

Print Page | Close Window