Advanced Features

The driver supports the following advanced features:

■

Failover

■

Security

■	Connection Pooling

■	DataDirect Bulk Load

Failover

The driver supports failover and its related connection options. Failover connection options are located on the Failover tab of the driver Setup dialog box. See “Using Failover” for a general description of failover and its implementation.

Security

The driver supports authentication and encryption. Security connection options are located on the Security tab of the driver Setup dialog box. See “Using Security” for a general description of security and its implementation.

Authentication

If you are using Kerberos, verify that your environment meets the requirements listed in Table 11-3 before you configure the driver for Kerberos authentication.

Table 11-3. Kerberos Authentication Requirements for the SQL Server Wire Protocol Driver 

Component	Requirements
Microsoft SQL Server database server	The database server must be administered by the same domain controller that administers the client and must be running one of the following databases: ■ Microsoft SQL Server 2008 ■ Microsoft SQL Server 2005 ■ Microsoft SQL Server 2000 ■ Microsoft SQL Server 2000 Enterprise Edition (64-bit) Service Pack 2 or higher
Kerberos server	The Kerberos server is the machine where the user IDs for authentication are administered. The Kerberos server is also the location of the Kerberos KDC. Network authentication must be provided by Windows Active Directory on one of the following operating systems: ■ Windows Server 2003 ■ Windows 2000 Server Service Pack 3 or higher
Client	The client must be administered by the same domain controller that administers the database server.

Connection Pooling

The driver supports connection pooling and its related connection options. Connection pooling connection options are located on the Pooling tab of the driver Setup dialog box. See “Using DataDirect Connection Pooling” for a general description of connection pooling and its implementation.

DataDirect Bulk Load

The driver supports DataDirect bulk load and its related connection options. Bulk load connection options are located on the Bulk tab of the driver Setup dialog box. See “Using DataDirect Bulk Load” for a general description of DataDirect bulk load and its implementation.

For optimal performance, you must enable minimal logging and Table Locking. Please refer to the following Web site for more information on minimal logging:

http://msdn.microsoft.com/en-us/library/ms190422.aspx

Table Locking, one of the Bulk Options, is enabled by default. This prevents other transactions from accessing the table during bulk load. See “Bulk Options” for details about this option.