Why can I not get this mssql query to work?
Posted on 2007-11-28
I am getting this error below and wonder why and how to fix it can someone help please.
Warning: mssql_query() [function.mssql-query]: message: Unicode data in a Unicode-only collation or ntext data cannot be sent to clients using DB-Library (such as ISQL) or ODBC version 3.7 or earlier. (severity 16) in admin\closecase.php on line 25
Warning: mssql_query() [function.mssql-query]: Query failed in admin\closecase.php on line 25
Here is my code for that query from line 20- 25
$viewMyCasesII = mssql_query("SELECT caseID, customerEmail, SysName, problemDescription, SysLoc, SysType, customerPhone, SRDATETIMESTAMP, Owner, OwnDept, CaseState,
WHERE (Owner = '$STAFFNAME') AND (CaseState = 'OPEN')
ORDER BY caseID");