The driver transparently connects to Microsoft Azure Synapse Analytics and Microsoft Analytics Platform System (APS); however, the following limitations to features and functionality apply:

  • No support for connecting to an instance using an IP address for the server. A named instance must be specified for the Host Name (HostName) option.
  • 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.

    Refer to Locking and isolation levels in the Progress DataDirect for ODBC Drivers Reference for details.

  • 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

    Refer to String functions in the Progress DataDirect for ODBC Drivers Reference for more information.

  • 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

    Refer to Numeric functions in the Progress DataDirect for ODBC Drivers Reference for more information.

  • 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

    Refer to Date and time functions in the Progress DataDirect for ODBC Drivers Reference for more information.