Pre-Requisites for Connections to Microsoft SQL Server

Basic DBMS & DBMS Version Support

• Do OpenLink drivers connect to Microsoft SQL Server?
  
• Microsoft SQL Server version support
  
• Detecting the Microsoft SQL Server DBMS version

Database Native Client Requirements

• Understanding the Microsoft SQL Server native client
  
• When do I need the Microsoft SQL Server native client?
  
• Obtain the Microsoft SQL Server native client (also known as "NetLib") Note: Not required for Release 4.x and later!
  
• Configure the Microsoft SQL Server native client

Key Database Native Variables (Set Before OpenLink Install)

• DSQUERY
  
• TDSHOST
  
• TDSPORT
  
• TDSVER

Database Native Settings You Need to Know

• Identify the Microsoft SQL Server Instance Name
  
• Identify the Microsoft SQL Server Listen Port

Database Configuration for Unicode

• Unicode Configuration

Database Configuration for XA Support

• XA Configuration