If you get the error:
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.
One of the errors, could be infact that the connector can’t understand some data types in the MSSQL table. These are generally:
sysname, uniqueidentifier, ntext and nvarchar.
The easiest way to fix that, is to select with a conversion in place straight away. For example, using the CAST function in mssql, we are able to extract sysname as a varchar:
SELECT CAST(job_id AS VARCHAR(255)) as element_name) FROM [dbo].[....]
You can cast any element as any other element. Just remember to not cast as something PHP doesn’t support!