Using PHP to Connect to Microsoft SQL Server
If you see the following behaviors or error messages, this section describes what you can do to fix the problem.
The server returns a blank page or prompts you to download a file with the extension
This behavior is triggered when an incompatible datatype is passed to PHP from the MS SQL Server. Check your SELECT queries for incompatible datatypes (previously listed in the table of datatypes).
CAST incompatible datatypes as
You receive the following message.
Warning: 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)
You attempted to select a column of type