ODBC Setup
When setting up EPASS or any of it's related features, an ODBC connection to the database is required.
After the installation of Cache 2011 or 2016 has been completed, you need to setup the ODBC connection(s).
The version of Cache you install depends on which version is installed on your server. If you are unsure, please contact the EPASS technical support team.
Configuring ODBC Settings
For 64-bit operating systems, the ODBC can be found in C:\Windows\sysWOW64\odbcad32.exe.
For 32-bit operating systems, the ODBC can be found in C:\windows\system32\odbcad32.exe.
You must use ODBC Data Source Administrator (32-bit) for EPASS to work.
Select the System DSN tab.
After selecting the add, ensure you are choosing the correct driver called InterSystems ODBC.
DO NOT use InterSystems ODBC35
After selecting finish, you will be take to a blank setup screen to configure the Data Source.
Once filled in correctly, your setup screen will resemble the image below.
- The port is 5641 by default; this can be changed on the server.
- Disable Query Timeout must be checked.
User Name and Password are left blank. If you need a User Name and Password for additional functionality, contact EPASS Support.
Now you can install and configure EPASS.
In EPASS, typically, COMPANY1 is your live company and COMPANY2 is your play company.
See Also
September 25, 2024