ThingWorx Edge ADO Service > Configuring the ADO Service > How to Configure the Settings for an SQL Database Connection
  
How to Configure the Settings for an SQL Database Connection
In this section you will configure the settings for the connection between the ADO service and the SQL database that is installed on the same computer.
1. If it is not still open, open the AdoThing.config file.
2. In the Settings element, edit the following parameters, based on the configuration for the connection to the SQL database:
"rows": [
{
"ConnectionType": "OleDb",
"ConnectionString": "",
"AlwaysConnected": false,
"QueryEnabled": true,
"CommandEnabled": false,
"CommandTimeout": 60
}
]
The following table provides details for these parameters:
Name
Description
Default Value
ConnectionType
Type of connection: OleDb or Odbc.
OleDb
ConnectionString
Connection string used to connect the database.
Sample Connection String for SQL Server (OleDb):
Provider=SQLNCLI11;Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;
* 
www.connectionstrings.net provides possible connection strings.
None
AlwaysConnected
Is this client always connected to the database? True or False
false
QueryEnabled
Is query enabled (SELECT)? True or False.
true
CommandEnabled
Are commands enabled (CREATE, UPDATE, DELETE)? True or False.
false
CommandTimeout
Number of seconds to wait before a query times out.
60
3. After setting these parameters, save the file.
What’s Next?
For a production environment or to test with a self-signed certificate, you need to set up the certificate(s) for a secure connection.