No support for unquoted identifiers. The driver always enforces ANSI rules regarding quotation marks for all ADW and APS connections (EnabledQuotedIdentifiers=1); therefore, the Enable Quoted Identifiers option is disabled.
No support for connection pooling reauthentication.
No support for Data Definition Language (DDL) queries within transactions.
No support for closing holdable cursors when a transaction is committed.
No support for server side cursors; therefore:
Scroll-sensitive result sets are not supported.
The Enable Server Side Cursors option is disabled. The driver always disables server side cursors (EnableServersideCursors=0).
No support for XA connections.
Support for isolation levels is limited to only the read uncommitted level. See "Locking and Isolation Levels" for more information.
Support for the varchar(max), nvarchar(max), varbinary(max) data types is limited to Heap and Clustered Index Tables.
No support for the following SQL Server data types:
|
decimal() identity
|
timestamp
|
|
image
|
tinyint() identity
|
|
numeric() identity
|
ntext
|
|
smallint identity
|
xml
|
|
text
|
Support for scalar string functions is limited to the following functions:
|
ASCII
|
LEFT
|
RTRIM
|
|
CHAR
|
LTRIM
|
SOUNDEX
|
|
CONCAT
|
REPLACE
|
SPACE
|
|
DIFFERENCE
|
RIGHT
|
SUBSTRING
|
Support for scalar numeric functions is limited to the following functions:
|
ABS
|
EXP
|
ROUND
|
|
ACOS
|
FLOOR
|
SIGN
|
|
ASIN
|
LOG
|
SIN
|
|
ATAN
|
LOG10
|
SQRT
|
|
CEILING
|
PI
|
TAN
|
|
COS
|
POWER
|
TRUNCATE
|
|
COT (ADW only)
|
RADIANS
|
|
|
DEGREES
|
RAND
|
Support for scalar date and time functions is limited to the following functions:
|
CURDATE
|
DAYOFWEEK
|
QUARTER
|
|
CURRENT_DATE
|
DAYOFYEAR
|
SECOND
|
|
CURRENT_TIME
|
HOUR
|
WEEK
|
|
CURTIME
|
MINUTE
|
YEAR
|
|
DAYNAME
|
MONTH
|
|
|
DAYOFMONTH
|
MONTHNAME
|