skip to main content
DataDirect Connect Drivers : Microsoft SQL Server Driver
  
Microsoft SQL Server Driver
The SQL Server driver supports the following versions:
Cloud:
*Microsoft Windows Azure SQL Database
Note: For the versions that are supported by the SQL Server driver, refer to the product matrix on the Progress DataDirect Web site: http://www.datadirect.com/products/jdbc/matrix/jdbcpublic.htm
On Premise:
*Microsoft SQL Server 2012
*Microsoft SQL Server 2008
*Microsoft SQL Server 2005
*Microsoft SQL Server 2000
*Microsoft SQL Server 2000 Desktop Engine (MSDE 2000)
*Microsoft SQL Server 2000 Enterprise Edition (64-bit)
*Microsoft SQL Server 7.0
To use JDBC distributed transactions through JTA, you must install stored procedures for Microsoft SQL Server. See JTA Support: Installing Stored Procedures for more information about JTA.
* Data Source and Driver Classes
* Connection URL
* J2EE Connector Architecture Resource Adapter Class
* Connection Properties
* Performance Considerations
* Connecting to Named Instances
* Data Types
* Returning and Inserting/Updating XML Data
* Authentication
* Data Encryption
* DML with Results (Microsoft SQL Server 2005 and Higher)
* Reauthentication
* Client Information for Connections
* SQL Escape Sequences
* Isolation Levels
* Using the Snapshot Isolation Level (Microsoft SQL Server 2005 and Higher)
* Using Scrollable Cursors
* Server-Side Updatable Cursors
* JTA Support: Installing Stored Procedures
* Distributed Transaction Cleanup
* Large Object (LOB) Support
* Batch Inserts and Updates
* Parameter Metadata Support
* ResultSet MetaData Support
* Rowset Support
* Auto-Generated Keys Support
* Null Values
* Configuring Failover
* Failover Properties
* Configuring Bulk Load