Microsoft SQL Server target-specific issues

This section describes issues relating to ECDA Option for ODBC accessing Microsoft SQL Server.


Service Pack version

If your Microsoft SQL Server is not at Service Pack 3 or later, set QuotedIdentifiers=yes for the DSN entry for accessing Microsoft SQL Server.


NCHAR and NVARCHAR datatype support

Microsoft NCHAR and NVARCHAR datatypes are not supported but are translated to the single-byte character set of the operating system. Unicode characters that cannot be mapped are translated to a default character for the operating system.


Insert failures with ASE/CIS

(CR 275506) ASE/CIS is not correctly mapping the timestamp datatype, resulting in insert failures.


Read-only cursors fails to return error messages

(CR 425343) An update of read-only cursors fails to return errors against Microsoft SQL Server 2005.