How do I setup ODBC on a computer?

Before using ODBC it will require the relevant setup to be done. This setup has to be done on every computer that will be used to run ODBC reports.

This article will guide you through installing ODBC on a Windows 64-bit Operating System. It is very important that no one is accessing the payroll application or running reports at the time of the installation.

The installation requires local administrative rights on both the workstation and the payroll application directory.

We have a video available on Youtube to guide you through the installation process on Windows 10 64-bit, which is applicable to Windows 11 as well.

Step 1: Local Administrative Rights

NOTE: Please confirm with your IT department that you are a local administrator on the PC and the payroll application directory.

• If you are a domain administrator, this will need to be changed.
• Restart the computer before proceeding to Step 2. 

Step 2: Checking User Account Control

• Click on Start control Panel > User Accounts > Change User Account Control Settings
• Change to NEVER NOTIFY (if not) and restart the machine

Step 3: Changing the Data Sources

• Click on Start > Control Panel > Administrative Tools
• Right-click on Data sources (ODBC)
• Select Properties. Make sure the Target and start in is changed to match the print screen below

• Click on Security > Click on each profile name > Tick Full control > Apply 

Step 4: Installation ODBC

- Copy the .dll files from the ODBC folder

• Right-click on the payroll application icon on your desktop
• Click on Properties, and click on Open File Location.   
• Locate the ODBC folder and access the open

• Right-click in the folder and select to sort by "Type"
• Select to copy all the .DLL files (there will be a minimum of 8)

• Minimize the screen  

- Paste copied.dll files in c:\Windows\System32 folder

• Open File Explorer, locate the C:\ Drive
• Locate and access the Windows folder
• Locate and access the System32 folder
• Paste the copied .DLL files (overwrite when prompted)

- Paste copied .dll files in c:\Windows\SysWOW64 folder

• Open File Explorer, locate the C:\ Drive
• Locate and access the Windows folder
• Locate and access the SysWOW64 folder
• Paste the copied .DLL files (overwrite when prompted
• Close the screen

Create c:\TEMP folder

• Open File Explorer, locate the C:\ Drive
• Explore the drive and check if there is a TEMP folder
• If there is not a Temp folder:
  • Rright click in the c:\ drive
  • Select New, then select Folder
  • Rename the New Folder to TEMP

 Once completed, you can run the ODBC Configuration tool (Main Menu > Utilities > ODBC Configuration)

Read more: How do I apply my ODBC changes

Read more: How do I enter my Site Code when calling Sage Customer Support