Microsoft SQL Server Access Module

SourcePro : Installing and Building Your SourcePro® Products : Buildspec Details : Module-Specific Questions : SourcePro DB Access Modules : Microsoft SQL Server Access Module

For MS SQL Access Module, there is an extra option, SQL Server Client, which can have following values:

1. SQL Server – For building SourcePro applications with the MS SQL Server driver provided by MDAC.

2. ODBC Driver for SQL Server – For building applications with ODBC Driver for SQL Server. The ODBC Driver for SQL Server SDK is required for this option, generally installed at the following location:

C:\Program Files\Microsoft SQL Server\Client SDK\ODBC\<version>\SDK

3. SQL Server Native Client – For building applications with SQL Server Native Client Driver shipped with Microsoft SQL Server. SQL Server Native Client SDK is required for this option, generally installed at the following location:

C:\Program Files\Microsoft SQL Server\<version>\SDK

If the last two options are selected, the path to the SDK needs to be entered on the following screen.

On Linux Platforms

On Linux, the SQL Server Client line on the screen above does not display; rather, provide client location information on an additional dialog:

When specifying the absolute paths, be sure to provide the path up to, but not including, the required directories. For example, use /nfs/sqlserver instead of /nfs/sqlserver/lib.