Spam Filter ISP Support Forum

  New Posts New Posts RSS Feed - 'concat' is not a recognized built-in function nam
  FAQ FAQ  Forum Search   Register Register  Login Login

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

 Post Reply Post Reply
Author
AccentPhil View Drop Down
Newbie
Newbie


Joined: 21 February 2008
Status: Offline
Points: 3
Post Options Post Options   Thanks (0) Thanks(0)   Quote AccentPhil Quote  Post ReplyReply Direct Link To This Post Topic: 'concat' is not a recognized built-in function nam
    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
Back to Top
LogSat View Drop Down
Admin Group
Admin Group
Avatar

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

LogSat Software

Spam Filter ISP
Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down



This page was generated in 0.047 seconds.