Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - Programming » .NET application programming » SQL Anywhere .NET Data Provider » SQL Anywhere .NET Data Provider deployment


SQL Anywhere .NET Data Provider DLL registration

The Windows version of the SQL Anywhere .NET Data Provider DLL (%SQLANY16%\Assembly\V2\iAnywhere.Data.SQLAnywhere.dll) is registered in the Global Assembly Cache when you install the SQL Anywhere software. On Windows Mobile, you do not need to register the DLL.

If you are deploying the SQL Anywhere .NET Data Provider, you can register it using the gacutil utility that is included with the Microsoft SDK.

To register the SQL Anywhere .NET Data Provider as a DbProviderFactory instance when deploying the provider, you must add an entry to the .NET machine.config file. An entry similar to the following must be placed in the <DbProviderFactories> section.

<add invariant="iAnywhere.Data.SQLAnywhere" 
name="SQL Anywhere 16 Data Provider" 
description=".Net Framework Data Provider for SQL Anywhere 16" 
type="iAnywhere.Data.SQLAnywhere.SAFactory, iAnywhere.Data.SQLAnywhere.v3.5, 
    Version=, Culture=neutral, PublicKeyToken=f222fc4333e0d400"/>

The version number must match the version of the provider that you are installing. The configuration file is located in \WINDOWS\Microsoft.NET\Framework\v2.0.50727\CONFIG. For 64-bit Windows systems, there is a second configuration file under the Framework64 tree that must also be modified.