Product: Sage 100
The Open Database Connectivity (ODBC) is a windows installed driver that allows Sage 100 and Transaction Manager to communicate with each other to query databases and pull/send information between the two systems. Running the setup.exe is designed to adjust the OBDC driver found in Windows.
However, often permission on your machine/network can prevent the installer from completing this setup properly. You may need to modify the ODBC settings manually
Note: Doing this requires the same level of permissions as properly running the installer. It is highly recommended that you re-run the installer under a local admin rather than modify the OBDC directly.
Configuring the ODBC Manually
Navigate: C:\Windows\SysWOW64
Open: odbcad32.exe
Select: User/System DSN → SOTAMAS90 → Configure
Under the Basic tab you'll need to set your Database Directory to the Sage Server (this is the same path set within your Transaction Manager → Integration Options settings).
Set: Database Directory
Restart the Integration Service
Once the Open Database Connection has been updated you'll need to restart the Integration Service in order for it to reflect the new changes for your integration with Transaction Manager.
rev 1/23/2024