Creating a Database Connection
Once the installation routine is completed, you will need to create a 32-bit ODBC data connection to the database. You can find the 'Set up ODBC data sources (32-bit)' option in the Control Panel of the workstation.
You will need to add a ‘System’ DSN and you will also be asked for a SQL Server username and password to complete the connection. Please note that you can use SQL or Windows Authentication to connect to the SQL Server database. If using SQL authentication, all users must use the same SQL Server user name and the SQL user must have the ‘db_TR_USER’ role for the Troika database. If a windows user account is being used, the account must also have the ‘db_TR_USER’ role for the SQL database.
The language of the DSN must also be set to English and not US or British English. Check the default language of the SQL or Windows account on the SQL Server is set to English before creating the DSN for the user account or profile. This can be found in the properties of the user account in SQL Management Studio.
Use the following settings to create an ODBC data connection to the database:
- Microsoft SQL Server ODBC Driver Version
- Data Source Name: <Your Database Name>
- Data Source Description: <Your Database Name>
- Server: <Your Server Name>
- Database: <Your Database Name>
- Use ANSI quoted identifiers: Yes
- Use ANSI nulls, paddings and warnings: Yes
- Use the failover SQL Server if the primary SQL : No
- Language: (Default)
- Data Encryption: No
- Translate Character Data: Yes
- Use Regional Settings: No
- Log Long Running Queries: No
- Log Driver Statistics: No
After configuring the System DSN, you will need to use the test option to check for successful connection to your database.
If utilising 64-bit MSOffice, you will be required to create both a 32-bit ODBC data connection and 64-bit ODBC data connection to the database. Troika Desktop requires the 32-bit, and the programs require the 64-bit.
You will therefore need to repeat this process, this time to create a 64-bit ODBC data connection. You can find the 'Set up ODBC data sources (64-bit)' option in the Control Panel of the workstation.
It is important that both ODBC data connections use exactly the same name and login credentials.
Once done, revert to the installation instructions and continue.
This article was last reviewed 05/2025.