DirectConnect for Microsoft SQL Server

Following are issues relating to DirectConnect for 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.