ODBC connections to be used in Orbis TaskCentre can be set up from within TaskCentre itself. This ensures that they are configured correctly for the application.
Log into TaskCentre
Browse to Manage, Tools, Input, Database Query (ODBC)
Click Add
Select the "SQL Server" driver under "ODBC Drivers", enter the relevant server and log in details and click OK to save OR choose the relevant server under "Data Sources", enter the relevant log in details and click OK to save. Additional options can be edited under the "Options >>" button if required
Once saved, you will be taken back to the main ODBC screen
Highlight your new ODBC connection and click Test to check the connection is working
You can make any changes necessary by highlighting the connection and clicking Properties