Versions Compared

Version Old Version 5 New Version Current
Changes made by

Matthew Garrett

Sam Pitts

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Important: If Microsoft SQL Native Client is already installed, proceed to Step 3 - ODBC DSN Configuration. If unsure, re-install the software.

...

Critical: Microsoft Windows 64-Bit Operating Systems include two executable files to open ODBC Data Source Administrator. To connect to The Finance Shop, please use the secondary location listed below: 
  • Main Location: \\%SystemRoot%\system32\odbcad32.exe is used to create and maintain data source names for 64-bit applications.
  • Secondary Location: \\%SystemRoot%\SysWOW64\odbcad32.exe is used to create and maintain data source names for 32-bit applications, including 32-bit applications that run on 64-bit operating systems.


Procedures

Configuring The Finance Shop ODBC DSN (32 Bit)

  1. Open Data Sources (ODBC) 32 Bit.
  2. Select the System DSN tab.
  3. Click the Add button. The Create New Data Source dialog will be displayed.
  4. Select SQL Server Native Client.
  5. Click Finish. The Create a New Data Source to SQL Server dialog will be displayed.
  6. Enter the following details: 
    • Name: TFSMain
    • Description (optional): Enter a description for the database connection.
    • Server: Select the SQL server from the drop down list.

...

Important: This step is ONLY required if Step 7 - The Finance Shop System Configuration was skipped.

Procedures

Staring The Finance Shop

...