> For the complete documentation index, see [llms.txt](https://docs.theconfigteam.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.theconfigteam.com/codingcontrol/configuration/core-application-configuration/server-application-configuration/odbc-connection.md).

# ODBC Connection

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.

1. Select ‘Administrative tools’.
2. The screen will update to display a list of available options.
3. Right-click and select ‘Run as administrator’ on the ‘ODBC Data Sources (32-bit)’ option.
4. A detailed configuration window will now be displayed, Select the ‘System DSN’ tab.<br>

   <figure><img src="https://2225346189-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FvPS6W3uRgFnSjekeJfYT%2Fuploads%2FLkjuDmJmuB8ZIbn88ZT4%2Fimage.png?alt=media&amp;token=ec190592-27cf-4225-bf2b-3b7390a855d0" alt=""><figcaption></figcaption></figure>
5. Select ‘ADD’ and find and select ‘SQL Server’ from the presented list.
6. 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.)<br>

   <div align="left"><figure><img src="https://2225346189-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FvPS6W3uRgFnSjekeJfYT%2Fuploads%2FnDxTmHkG7cIbW6ERx71f%2Fimage.png?alt=media&amp;token=8cbee2a1-abb8-4ed2-a86f-2a119d086e5e" alt=""><figcaption></figcaption></figure></div>

   :information\_source: 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.<br>
7. Once all values have been entered select 'Next'.
8. Enter the login credentials for the configured SQL server and select 'next'.\
   \
   :information\_source: 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. <br>

   <div align="left"><figure><img src="https://2225346189-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FvPS6W3uRgFnSjekeJfYT%2Fuploads%2FbfGKyu6nnekjKGWs9gap%2Fimage.png?alt=media&amp;token=b23810fd-e06d-45ef-bed5-cfe44b0c2496" alt=""><figcaption></figcaption></figure></div>
9. Select 'Next' to continue.
10. Select and change the 'default' database to be the required CodingControl database name.&#x20;
11. Select 'Next'.<br>

    <div align="left"><figure><img src="https://2225346189-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FvPS6W3uRgFnSjekeJfYT%2Fuploads%2FnV0Zf7rctmjtHjoTcPjc%2Fimage.png?alt=media&amp;token=c58a049c-4fe1-4bdc-a87f-80024aedd354" alt=""><figcaption></figcaption></figure></div>
12. Select 'Finish' on the proposed language and log file configuration screen, unless specific values and configuration are required to be set. <br>

    <div align="left"><figure><img src="https://2225346189-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FvPS6W3uRgFnSjekeJfYT%2Fuploads%2FY6GIC3tb8ipRoSF26EjB%2Fimage.png?alt=media&amp;token=eb88f7b2-471c-4357-a499-5c3da4b8a8ab" alt=""><figcaption></figcaption></figure></div>
13. Select ‘Test Data Source’ button to carry out the connection test to the SQL database.\ <br>

    <div align="left"><figure><img src="https://2225346189-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FvPS6W3uRgFnSjekeJfYT%2Fuploads%2F9KgIRKAgWkogczwvO3Uk%2Fimage.png?alt=media&amp;token=87b80ad9-1717-421b-adf7-5620fb1e483a" alt=""><figcaption></figcaption></figure></div>
14. A message screen will be displayed providing either a success message or details if any connection issues encountered.\
    \
    :information\_source:Revisit the process steps and data submitted for any issues returned.<br>
15. Select 'OK' to complete and save the connection configuration.&#x20;