The genericADO2 and ODP drivers supports integrated security. However, the MySQL, the Advantage Database Server, the SQL Anywhere Server and the Firebird Server backends do not support integrated security.
Integrated Security is specified as shown in the following example (excerpt from app.config file):
|
 Copy Code |
|
<connections>
<connection id="DatabaseConnection1">
<databasename>MyDatabase</databasename>
<servername>MyServer</servername>
<integratedSecurity>True</integratedSecurity>
<backendconfigurationname>mssqlConfiguration</backendconfigurationname>
</connection>
</connections> |
It is strongly recommended to specify integrated security explicitly, since security related decisions should always be explicitly set. However, the combination of genericADO2–MSSQL2005 defaults to True.