Creating an ODBC Data Source for HDM

The next task is to create an ODBC data source on the PC where the SQL Express database is installed.

Because Windows Vista is a 64 bit system, a 32 bit ODBC driver must be installed to run with the 32 bit IGSS software. This is done by running the ODBC 32 bit data source application in Vista. This is found in the path Windows\Syswow64\ODBCad32.exe. Follow the on screen wizard to complete the creation of a 32 bit ODBC data source. The steps to follow are the same as described below for creating an ODBC data source in Windows XP.

In Windows XP,  go Start - All Programs - Control Panel - Administrative Tools - Data Sources (ODBC) and continue as follows:

  1. In the ODBC Data Source Administrator dialog box select the tab System DSN.
  2. Click the button ADD and the Create New Data Source wizard appears. In the list displayed, find the entry SQL Server, highlight it, and click the button Finish.
  3. The Create a New Data Source to SQL Server dialog box appears. In the field Name: be sure to type in HDM and in the field Server: use the drop down box to find the name of the PC being used as the SQL Express server. Select the PC name and then add \SQLExpress directly after the PC name; cClick Next.
  4. In the dialog box  now appearing, choose the authentication method you wish to use, either NT or SQL. Click Next.
  5. In the dialog box now appearing, select the check box Change the default database to: and in the drop down box select HDM. Click Next.
  6. In this dialog box simply click Finish to continue.
  7. In this last dialog box, ODBC Microsoft SQL Server Setup, click on the button Test Data Source…. If the setup has been successful, a message will appear confirming this. Click OK to finish and exit.

To continue to the final procedure, click here.