Distributed Transactions
You can use the Adaptive Server ADO.NET Data Provider to participate in two-phase commit
transactions. This feature requires the use of .NET Enterprise Services, which manages
the distributed transactions.
- Programming Using Enterprise Services
Services in unmanaged code are known as COM+ services. The COM+ services infrastructure can be accessed from managed and unmanaged code. In .NET, these services are referred to as Enterprise Services. Working with transactions in Enterprise Services using ADO.NET is straightforward.
- Directory Services
With directory services, Adaptive Server ADO.NET Data Provider can get connection and other information from a central LDAP server, to connect to an Adaptive Server server. It uses Directory Service URL (DSURL), which indicates which LDAP server to use.
- Microsecond Granularity for Time Data
The Adaptive Server ADO.NET Data Provider provides microsecond-level precision for time data by supporting the SQL datatypes bigdatetime and bigtime.
- Password Encryption
The Adaptive Server ADO.NET Data Provider supports symmetrical and asymmetrical password encryption. You can use this feature to change the default behavior and encrypt your password, before they are sent over the network.
- Password Expiration Handling
Every company has a specific set of password policies for its database system. Depending on the policies, the password expires at a specific date and time.
- Secure Sockets Layer (SSL)
SSL is an industry standard for sending wire- or socket-level encrypted data over client-to-server and server-to-server connections.
- Failover in a High-Availability System
A high availability cluster includes two or more machines that are configured so that if one machine (or application) is brought down, the second machine assumes the workload of both machines.
- Kerberos Authentication
Kerberos is an industry standard network authentication system that provides simple login authentication as well as mutual login authentication. Kerberos is used for single sign-on across various applications in extremely secure environments.
Created June 6, 2013. Send feedback on this help topic to Technical Publications:
pubs@sybase.com