The connection parameters required to connect to ADO.Net Connectors can be found below:
Parameter | Value |
---|---|
Connection Name | Name for the connection. |
Description | Description of the connection. |
ADO.Net Provider | Choose your ADO.Net provider from the drop down list. You can choose from ODBC, OleDB, SQLClient, Oracle Client, and ODP.NET. |
Connection String | The connection string to connect to your chosen Database. |
SQL Identifier Start Character | The character to identify the start of the string. By default this is set to " . |
SQL Identifier End Character | The character to identify the end of the string. By default this is set to " . |
SQL Parameter Marker | The parameter marker. By default this is set to :{0} . |