To connect to Microsoft SQL Server from an ArcGIS client, install a supported Microsoft SQL Server ODBC driver on the ArcGIS client machine and connect to the database from the ArcGIS client. Once the SQL Server ODBC driver is configured on all your ArcGIS client machines, create a database connection file. To publish ArcGIS Server web services. When you search for the latest version of SQL Server Native Client, it will show you the version 11.4.7001.0, and some servers are the version 11.4.7462.6 (It contains run-time support for applications using native-code APIs (ODBC, OLE DB and ADO) to connect to Microsoft SQL Server 2005, 2008, 2008 R2, and SQL Server 2012). In SQL Server 2016 there have been several significant changes to the SQL Client Tools. Central to these changes are two primary goals: The ability to ship tooling updates on a regular, monthly cadence A single version of tools that work with all supported SQL Server versions on-premises or in a Virtual Machine, Azure SQLRead more.
-->Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
Classes
ActiveDirectoryAuthenticationProvider | This class implements SqlAuthenticationProvider and is used for active directory federated authentication mechanisms. |
SqlAuthenticationInitializer | Called from constructors in derived classes to initialize the SqlAuthenticationInitializer class. |
SqlAuthenticationParameters | Represents AD authentication parameters passed by a driver to authentication providers. |
SqlAuthenticationProvider | Defines the core behavior of authentication providers and provides a base class for derived classes. |
SqlAuthenticationToken | Represents an AD authentication token. |
SqlBulkCopy | Lets you efficiently bulk load a SQL Server table with data from another source. |
SqlBulkCopyColumnMapping | Defines the mapping between a column in aSqlBulkCopyinstance's data source and a column in the instance's destination table. |
SqlBulkCopyColumnMappingCollection | Collection of SqlBulkCopyColumnMapping objects that inherits from CollectionBase. |
SqlBulkCopyColumnOrderHint | Defines the sort order for a column in aSqlBulkCopyinstance's destination table, according to the clustered index on the table. |
SqlBulkCopyColumnOrderHintCollection | Collection of SqlBulkCopyColumnOrderHint objects that inherits from CollectionBase. |
SqlClientFactory | Represents a set of methods for creating instances of theMicrosoft.Data.SqlClientprovider's implementation of the data source classes. |
SqlClientLogger | Represents a SQL client logger. |
SqlClientMetaDataCollectionNames | Provides a list of constants for use with the GetSchema method to retrieve metadata collections. |
SqlClientPermission | Enables the .NET Framework Data Provider for SQL Server to help make sure that a user has a security level sufficient to access a data source. |
SqlClientPermissionAttribute | Associates a security action with a custom security attribute. |
SqlColumnEncryptionCertificateStoreProvider | The implementation of the key store provider for Windows Certificate Store. This class enables using certificates stored in the Windows Certificate Store as column master keys.For details, see Always Encrypted. |
SqlColumnEncryptionCngProvider | The CMK Store provider implementation for using the Microsoft Cryptography API: Next Generation (CNG) withAlways Encrypted. |
SqlColumnEncryptionCspProvider | The CMK Store provider implementation for using Microsoft CAPI based Cryptographic Service Providers (CSP) withAlways Encrypted. |
SqlColumnEncryptionKeyStoreProvider | Base class for all key store providers. A custom provider must derive from this class and override its member functions and then register it usingRegisterColumnEncryptionKeyStoreProviders(IDictionary<String,SqlColumnEncryptionKeyStoreProvider>),RegisterColumnEncryptionKeyStoreProvidersOnConnection(IDictionary<String,SqlColumnEncryptionKeyStoreProvider>) orRegisterColumnEncryptionKeyStoreProvidersOnCommand(IDictionary<String,SqlColumnEncryptionKeyStoreProvider>).For details see, Always Encrypted. |
SqlCommand | Represents a Transact-SQL statement or stored procedure to execute against a SQL Server database. This class cannot be inherited. |
SqlCommandBuilder | Automatically generates single-table commands that are used to reconcile changes made to aDataSetwith the associated SQL Server database. This class cannot be inherited. |
SqlConfigurableRetryFactory | Provides different retry logic providers with a common list of transient errors. |
SqlConnection | Represents a connection to a SQL Server database. This class cannot be inherited. |
SqlConnectionStringBuilder | Provides a simple way to create and manage the contents of connection strings used by the SqlConnection class. |
SqlCredential | SqlCredential provides a more secure way to specify the password for a login attempt using SQL Server Authentication. SqlCredential is comprised of a user id and a password that will be used for SQL Server Authentication. The password in a SqlCredential object is of type SecureString. SqlCredential cannot be inherited. Windows Authentication ( |
SqlDataAdapter | Represents a set of data commands and a database connection that are used to fill the DataSet and update a SQL Server database. This class cannot be inherited. |
SqlDataReader | Provides a way of reading a forward-only stream of rows from a SQL Server database. This class cannot be inherited. |
SQLDebugging | Included to support debugging applications. Not intended for direct use. |
SqlDependency | The SqlDependency object represents a query notification dependency between an application and an instance of SQL Server. An application can create a SqlDependency object and register to receive notifications via the OnChangeEventHandler event handler. |
SqlError | Collects information relevant to a warning or error returned by SQL Server. |
SqlErrorCollection | Collects all errors generated by the .NET Framework Data Provider for SQL Server. This class cannot be inherited. |
SqlException | The exception that is thrown when SQL Server returns a warning or error. This class cannot be inherited. |
SqlInfoMessageEventArgs | Provides data for the InfoMessage event. |
SqlNotificationEventArgs | Represents the set of arguments passed to the notification event handler. |
SqlParameter | Represents a parameter to a SqlCommand and optionally its mapping to DataSet columns. This class cannot be inherited. For more information on parameters, see Configuring parameters. |
SqlParameterCollection | Represents a collection of parameters associated with a SqlCommand and their respective mappings to columns in a DataSet. This class cannot be inherited. |
SqlRetryingEventArgs | Represents the set of arguments passed to the Retrying event. |
SqlRetryIntervalBaseEnumerator | Generates a sequence of time intervals. |
SqlRetryLogicBase | Retrieves the next time interval with respect to the number of retries if a transient condition occurs. |
SqlRetryLogicBaseProvider | Applies retry logic on an operation through the |
SqlRetryLogicOption | Provides the retry logic parameters to create an instance of the SqlRetryLogicBaseProvider class by using SqlConfigurableRetryFactory methods. |
SqlRowsCopiedEventArgs | Represents the set of arguments passed to the SqlRowsCopiedEventHandler. |
SqlRowUpdatedEventArgs | Provides data for the RowUpdated event. |
SqlRowUpdatingEventArgs | Provides data for the RowUpdating event. |
SqlTransaction | Represents a Transact-SQL transaction to be made in a SQL Server database. This class cannot be inherited. |
Enums
ApplicationIntent | Specifies a value for ApplicationIntent. Possible values are |
PoolBlockingPeriod | Specifies a value for the PoolBlockingPeriod property. |
SortOrder | Specifies how rows of data are sorted. |
SqlAuthenticationMethod | Describes the different SQL authentication methods that can be used by a client connecting to Azure SQL Database. For details, see Connecting to SQL Database By Using Azure Active Directory Authentication. |
SqlBulkCopyOptions | Bitwise flag that specifies one or more options to use with an instance of SqlBulkCopy. |
SqlCommandColumnEncryptionSetting | Note that these settings cannot be used to bypass encryption and gain access to plaintext data. For details, see Always Encrypted (Database Engine). |
SqlConnectionAttestationProtocol | Specifies a value for Attestation Protocol. |
SqlConnectionColumnEncryptionSetting | Note that these settings cannot be used to bypass encryption and gain access to plaintext data. For details, see Always Encrypted (Database Engine). |
SqlConnectionIPAddressPreference | Specifies a value for IP address preference during a TCP connection. |
SqlConnectionOverrides | Specifies a value for Overrides. |
SqlNotificationInfo | This enumeration provides additional information about the different notifications that can be received by the dependency event handler. |
SqlNotificationSource | Indicates the source of the notification received by the dependency event handler. |
SqlNotificationType | Describes the different notification types that can be received by an OnChangeEventHandler event handler through the SqlNotificationEventArgs parameter. |
Delegates
Microsoft Sql Client
Microsoft Sql Client Linux
OnChangeEventHandler | |
SqlInfoMessageEventHandler | Represents the method that will handle the InfoMessage event of a SqlConnection. |
SqlRowsCopiedEventHandler | Represents the method that handles the SqlRowsCopied event of a SqlBulkCopy. |
SqlRowUpdatedEventHandler | Represents the method that will handle the RowUpdated event of a SqlDataAdapter. |
SqlRowUpdatingEventHandler | Represents the method that will handle the RowUpdating event of a SqlDataAdapter. |