Deploying .NET clients

The simplest way to deploy .NET assemblies is to use the Deployment Wizard. For more information, see Using the Deployment Wizard.

If your end users will be developing .NET applications, then consider integrating the SQL Anywhere .NET tools into Microsoft Visual Studio. On the client computer, you must do the following.

  • Ensure Visual Studio is not running.

  • Run install-dir\Assembly\v2\SetupVSPackage.exe /install.

If you want to create your own installation, this section describes the files to deploy to the end users. There are several message files each supporting a different language. If you want to install support for different languages, you have to include the resource files for these languages. Replace [LL] with the language code (for example, en, de, jp, etc.).

Each .NET client computer must have the following:

  • A working .NET 2.0, 3.0, 3.5 or 4.0 installation   Microsoft .NET assemblies and instructions for their redistribution are available from Microsoft Corporation. They are not described in detail here.

  • SQL Anywhere provider for .NET 2.0/3.0 Framework   The SQL Anywhere installation places the Windows assemblies for the .NET Framework versions 2.0 and 3.0 in the Assembly\V2 subdirectory of your SQL Anywhere installation directory. The other files are placed in the operating-system binaries directory of your SQL Anywhere installation directory (for example, bin32 or bin64). The following files are required. 
    iAnywhere.Data.SQLAnywhere.dll
policy.12.0.iAnywhere.Data.SQLAnywhere.dll
dblg[LL]12.dll
dbcon12.dll

  • SQL Anywhere provider for .NET 3.5 Framework   The SQL Anywhere installation places the Windows assemblies for the .NET Framework version 3.5 in the Assembly\V3.5 subdirectory of your SQL Anywhere installation directory. The other files are placed in the operating-system binaries directory of your SQL Anywhere installation directory (for example, bin32 or bin64). The following files are required. 
    iAnywhere.Data.SQLAnywhere.v3.5.dll
policy.12.0.iAnywhere.Data.SQLAnywhere.v3.5.dll
dblg[LL]12.dll
dbcon12.dll

  • SQL Anywhere provider for .NET 4.0 Framework   The SQL Anywhere installation places the Windows assemblies for the .NET Framework version 4.0 in the Assembly\V4 subdirectory of your SQL Anywhere installation directory. The other files are placed in the operating-system binaries directory of your SQL Anywhere installation directory (for example, bin32 or bin64). The following files are required. 
    iAnywhere.Data.SQLAnywhere.v4.0.dll
policy.12.0.iAnywhere.Data.SQLAnywhere.v4.0.dll
dblg[LL]12.dll
dbcon12.dll
SSDLToSA12.tt

    SSDLToSA12.tt is used for generating database schema DDL for Entity Data Models. The SQL Anywhere installer copies this file to the Visual Studio 2010 directory. The user should set the DDL Generation property to this file when generating database schema DDL for Entity Data Models.

  • SQL Anywhere provider for .NET 2.0 Compact Framework   The SQL Anywhere installation places the Windows Mobile assemblies for the .NET Compact Framework in CE\Assembly\V2. The other file is placed in the Windows Mobile binaries subdirectory of your SQL Anywhere installation directory (for example, CE\Arm.50). The following files are required. 
    iAnywhere.Data.SQLAnywhere.dll
iAnywhere.Data.SQLAnywhere.gac
dblg[LL]12.dll

For more information about deploying the SQL Anywhere .NET provider, see Deploying the SQL Anywhere .NET Data Provider.

Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0