ADO.NET Microsoft SQL Server

This section describes changes to the PowerBuilder ADO interface for Microsoft SQL Server:

The following new features are supported:

• Large value types:

  • varchar(max)

  • nvarchar(max)

  • varbinary(max)

  xml, varchar(max) and nvarchar(max) are mapped to the PowerBuilder string type; varbinary(max) is mapped to the PowerBuilder blob type.

• PowerBuilder supports SQL Server database mirroring, and a DBNotification event is fired when failover occurs.

  A new DBParm parameter, FailoverPartner, enables you to set the SQL Server failover partner server, as in the SQL Native Client (SNC) interface.

Query notifications are not supported by the PowerBuilder ADO interface for SQL Server.

The following SQL Server 2008 features are supported:

• New datatypes:

  • date

  • time

  • datetime2

  • varbinary(max) (filestream)

  The SQL Server date, time and datetime2 datatypes are mapped to PowerBuilder date, time and datetime types. varbinary(max) (filestream ) is mapped to the PowerBuilder blob type. The maximum scale of time or datetime2 is 6.

• The new T-SQL commands support:

  • MERGE statement

  • Grouping sets

  • Row constructors

  • Table hints

  • The new T-SQL command works in the PowerBuilder ADO interface for SQL Server, as in the SNC interface.

These SQL Server 2008 features are not supported:

• datetimeoffset datatype

• Table-valued parameters