The OpenEdge DataServer for MS SQL Server has certified operating with the following drivers:
  • OpenEdge Wire Protocol driver for MS SQL Server®
  • SQL Server® driver
  • SQL Native Client 11 driver (SNAC)
  • ODBC driver 18 for SQL Server®

The following table lists the functional differences between the certified DataServer drivers:

OpenEdge Wire Protocol Driver SQL Server Driver SQL Native Client 11 Driver ODBC Driver 18 for SQL Server
Shipped with OpenEdge Installation Provided by Microsoft® Provided by Microsoft® Provided by Microsoft®
Bundled with OpenEdge DataServer for MS SQL Server. Available as part of Windows operating system. No third-party software required on the OpenEdge DataServer server to create the schema holder. Bundled with MS SQL Server database. As this is a third-party product, you must install it separately to use this driver. SNAC contains both the SQL OLE DB provider and SQL ODBC driver to support native connectivity to MS SQL Server. A single dynamic-link library (DLL) with run-time support for native-code APIs to connect to the SQL server. You must install this driver separately.
Does not support reading LOB data using the where clause. Does not support reading LOB data using the where clause. Supports reading LOB data such as varchar(max), nvarchar(max), varbinary(max). Supports reading the long data types as max data types by setting ON or OFF the keyword LongAsMax. When ON, the SQL LONGVARCHAR, SQL LONGVARBINARY, and SQL LONGWVARCHAR are sent as varchar(max), varbinary(max), and nvarchar(max) instead of text, image, and ntext.
Does not support the new datetime data types provided with MS SQL Server 2008 and later versions. Does not support the new datetime data types provided with MS SQL Server 2008 and later versions. Supports all new datetime data types such as date, time, datetimeoffset, datetime2, provided with MS SQL Server 2008 and later versions. Supports all new datetime data types such as date, time, datetimeoffset, datetime2, provided with MS SQL Server 2008 and later versions.
Note: The values for the DRIVER-CHARS property may differ for each certified driver:
  • OpenEdge Wire Protocol Driver— DRIVER-CHARS "11,13,14,20,23,33,36,39,"
  • SQL Server Driver— DRIVER-CHARS "11,13,14,20,23,33,35,36,38,"
  • SQL Native Client 11 Driver— DRIVER-CHARS "11,13,14,20,23,33,35,36,"
  • ODBC Driver 18 for SQL Server— DRIVER-CHARS "11,13,14,20,23,33,35,36,"
Note: The default value of Encrypt for the ODBC driver 18 is Yes (mandatory).