LinkSolv 8.3 Help Pages and User Guide

How to Use SQL Server

  1. SQL Server Availability. SQL Server is available from Microsoft Corporation. Access 2002 and Access 2003 include a free copy of SQL Server Express Version as the Microsoft Data Engine (MSDE). Free copies of the current SQL Server Express Version can be downloaded from the Microsoft website.
  2. SQL Server Databases. All data tables for a linkage project are constructed in the same SQL Server database -- the database specified in the ODBC DSN. Consequently, you must create and specify a different database for each linkage project or prior linkage tables will be overwritten. Databases are limited in size to 2 GB with SQL Server Express Version. You must copy all original data tables that you plan to use for linkage to the SQL Server database before starting the linkage project. You must use the ODBC DSN when creating Access links to original tables in the Prepare Data dialog.
  3. SQL Server Processing. In general, all SQL processing for a linkage project takes place on the specified server and SQL commands for standardizing and comparing data values for linkage use native SQL Server functions. There are a few exceptions. First, a few custom user functions are created in the SQL Server database for calculations not handled by native functions such as Delta Miles. Second, the simulation program creates each simulated data record on your computer and then transfers it to the SQL Server database. This could mean heavy network traffic while creating the tables. Third, StdAddress and StdName methods are not available for projects using SQL Server. In order to use either of these methods you must standardize your original data in a linkage project using Access databases and then transfer the results to the SQL Server database.
How to Use SQL Server -- Step by Step
  1. Prepare SQL Server. Install an instance of SQL Server. Configure SQL Server to allow Windows NT Authentication. Create a SQL Server database for your linkage project.
  2. ODBC Data Source. Open the ODBC Data Source Administrator dialog by starting Data Sources (ODBC) in the Windows Control Panel.
  3. System DSN. Open the System Data Sources dialog by selecting the System DSN tab.
  4. DSN=STMT_ODBC. Configure a System DSN with name STMT_ODBC that connects to SQL Server.
  5. NT Authentication. Configure STMT_ODBC to use Windows NT Authentication.
  6. Default Database. Configure STMT_ODBC with an existing SQL Server database as the default database (initial catalog). If necessary, have a database administrator create a new database. Use a different database for each project because tables with the same name will be overwritten.
  7. Test Connection. Test the STMT_ODBC connection to SQL Server. Copy all raw data tables to the new database.
  8. Data Provider. Set Data Provider to SQL in the Welcome Dialog, Options tab.
Authored with help of Dr.Explain