I've installed phpbb on a Windows 2003 Server box with a ODBC connection to a Microsoft SQL Server 2005 Enterprise SQL-server. The boards works fine until I click the search button, which gives me:

SQL ERROR [ mssql_odbc ]

[Microsoft][ODBC SQL Server Driver][SQL Server]The data types text and varchar are incompatible in the not equal to operator. [37000]

SQL

SELECT TOP 5 search_time, search_keywords FROM phpbb_search_results WHERE search_keywords <> '' ORDER BY search_time DESC

BACKTRACE

FILE: includes/db/mssql_odbc.php
LINE: 131
CALL: dbal_mssql_odbc->sql_error()

FILE: includes/db/mssql_odbc.php
LINE: 189
CALL: dbal_mssql_odbc->sql_query()

FILE: search.php
LINE: 888
CALL: dbal_mssql_odbc->sql_query_limit()