'concat' is not a recognized built-in function nam |
Post Reply 
|
| Author | |
AccentPhil 
Newbie 
Joined: 21 February 2008 Status: Offline Points: 3 |
 Post Options
 Thanks(0)
 Quote Reply
 Topic: 'concat' is not a recognized built-in function namPosted: 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 |
|
 |
|
|
LogSat
Admin Group 
Joined: 25 January 2005 Location: United States Status: Offline Points: 4104 |
Post Options
Thanks(0)
Quote Reply
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. |
|
|
|
Topic Options|
Post Reply
|
|
Tweet
|
| Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |
This page was generated in 0.195 seconds.