ODBC Connection
Last updated
Was this helpful?
Last updated
Was this helpful?
The ODBC connection provides the connection layer between the CodingControl server service and the database data store.
On the server navigate to the Control Panel.
Select ‘Administrative tools’.
The screen will update to display a list of available options.
Right-click and select ‘Run as administrator’ on the ‘ODBC Data Sources (32-bit)’ option.
A detailed configuration window will now be displayed, Select the ‘System DSN’ tab.
Select ‘ADD’ and find and select ‘SQL Server’ from the presented list.
Enter the following information in the Data source fields. - Name: (The name of the data source to be created.) - Description: (A brief description of the data source created) - Server: (The SQL server that the CodingControl database is installed.)
If the server is not displayed in the drop-down list the name can be entered manually, the value entered is case-sensitive and must match the SQL server details exactly.
Once all values have been entered select 'Next'.
Enter the login credentials for the configured SQL server and select 'next'. Depending on how the authorization and security if configured on the ODBC server and database will determine if windows authentication or specific ODBC logon credentials are required to access the data.
Select 'Next' to continue.
Select and change the 'default' database to be the required CodingControl database name.
Select 'Next'.
Select 'Finish' on the proposed language and log file configuration screen, unless specific values and configuration are required to be set.
Select ‘Test Data Source’ button to carry out the connection test to the SQL database.
A message screen will be displayed providing either a success message or details if any connection issues encountered. Revisit the process steps and data submitted for any issues returned.
Select 'OK' to complete and save the connection configuration.
