Microsoft SQL Server Target

Following are issues pertaining to ECDA Option for ODBC.


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.


Service Pack version

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


Read-only cursors fails to return error messages

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