SQL Anywhere .NET Data Provider required files

The SQL Anywhere .NET Data Provider code resides in a DLL for each platform.

Windows required files

For Windows (except Windows Mobile), one of the following DLLs is required:

%SQLANY12%\V2\Assembly\V2\iAnywhere.Data.SQLAnywhere.dll
%SQLANY12%\V2\Assembly\V3.5\iAnywhere.Data.SQLAnywhere.v3.5.dll
%SQLANY12%\V2\Assembly\V4\iAnywhere.Data.SQLAnywhere.v4.0.dll

The choice of DLL depends on the version of .NET that you are targeting.

The Windows version of the provider also requires the following DLLs.

policy.12.0.iAnywhere.Data.SQLAnywhere.dll The policy file can be used to override the provider version that the application was built with. The policy file is updated by Sybase whenever an update to the provider is released. There are also policy files for the version 3.5 provider (policy.12.0.iAnywhere.Data.SQLAnywhere.v3.5.dll) and the version 4.0 provider (policy.12.0.iAnywhere.Data.SQLAnywhere.v4.0.dll).
dblgen12.dll This language DLL contains English (en) messages issued by the provider. It is available in many other languages including Chinese (zh), French (fr), German (de), and Japanese (jp).
dbcon12.dll The Connect to SQL Anywhere window support code is contained in this DLL.

Windows Mobile required files

For Windows Mobile, the following DLLs are required:

%SQLANY12%\CE\Assembly\V2\iAnywhere.Data.SQLAnywhere.dll This is the Windows Mobile version of the provider.
%SQLANY12%\CE\Arm.50\dblgen12.dll This language DLL contains English (en) messages issued by the provider. It is available in many other languages including Chinese (zh), French (fr), German (de), and Japanese (jp).
%SQLANY12%\CE\Arm.50\dbcon12.dll The Connect to SQL Anywhere window support code is contained in this DLL.

The Window Mobile version of the DLL is required for .NET Compact Framework version 2.0 or later applications.

Visual Studio deploys the .NET Data Provider DLL (iAnywhere.Data.SQLAnywhere.dll) to your device along with your program. If you are not using Visual Studio, you must copy the Data Provider DLL to the device along with your application. It can go in the same directory as your application, or in the \Windows directory.

The SQL Anywhere .NET Data Provider dbdata DLL
SQL Anywhere .NET Data Provider DLL registration

Discuss this page in DocCommentXchange.