Previous Topic

Next Topic

Book Contents

Book Index

Connecting to MS SQL Server

Prerequisite Software

No software is needed in order to access a SQL Server server. The necessary ODBC Driver is present in the standard Windows install.

Configuring the Connection to SQL Server

The general process for configuring an ODBC datasource is described in Configuring a Database Connection.

To configure a SQL Server datasource, specify:

It is recommended that you click on Test Data Source to test that your connection has been configured correctly.