# 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="/files/Z3yG4lPCW4hzIprIgh2S" 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="/files/Uw60oJkezPq4D0P1SwIi" 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="/files/qLDWPi9xlRIZFZiLyez4" 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="/files/OBkcy5PVJktyeEqcd2Jk" 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="/files/qu43Xue8A9NwuutnsXMS" 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="/files/fnVVEJTifCSoExB1neDa" 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;


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.theconfigteam.com/codingcontrol/configuration/core-application-configuration/server-application-configuration/odbc-connection.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.