This topic provides technical details on embedding license information into your applications. This is a special resource that must be present in every application that uses dotConnect for SQL Server.
The article consists of following sections:
dotConnect for SQL Server uses .NET component licensing. To build an application dotConnect for SQL Server requires valid license. If no license is available, dotConnect for SQL Server does not work.
License information is a specially formed embedded resource. Usually you do not have to care about embedding license in your application. When you install dotConnect for SQL Server, the system is configured so that licensing is done transparently. End-users of your software do not require any additional license.
dotConnect for SQL Server includes License Wizard that helps you configure license information. The wizard analyzes the current project, informs you about problems found, and performs some actions needed to fix the problems.
To invoke the wizard choose SqlServer | License Information from the Visual Studio Tools menu. Then click the Fix buttons in the dialog and follow the wizard's instructions. In most cases this is enough to configure .NET component licensing.
The following table helps get started quickly with dotConnect for SQL Server licensing. Find your type of application and follow links to corresponding sections of the article.
Diagram | Explanation |
---|---|
This is general case of licensed .NET Framework application. Whatever the type of application you develop, read carefully sections Adding License Automatically and Adding License Manually. | |
These two diagrams show how you can use dotConnect for SQL Server through a class library. In addition to Adding License Automatically and Adding License Manually please read section Class Libraries Support. | |
These are two modes of accessing dotConnect for SQL Server within ASP.NET application. In addition to Adding License Automatically and Adding License Manually please read section Licensing ASP.NET Applications. | |
Some applications that have no licensing information embedded, and use DbProviderFactory to operate dotConnect for SQL Server, require the product installed on the computer. Refer to section DbProviderFactory Notes for more information. |
License is automatically added to project when you drop a SqlConnection component from Toolbox onto a form designer.
In some cases you have to manually add license. It is necessary for console applications and class libraries. In this case perform the following steps:
If IDE fails to compile the license automatically, you can do it yourself as described in section Compiling License Manually.
In case where it is impossible to put the license information straight to executable file, dotConnect for SQL Server allows you to create class libraries that can be used with certain executable files. To do this perform the following steps:
You do not have to add the file licenses.config to project.
Licensing a library without specifying the executables that will use it is possible by agreement with Devart. For details on this, please mail to [email protected] or [email protected].
There are two types of web projects depending on the type of licensing.
Applications that call dotConnect for SQL Server through DbProviderFactory require registration in DbProviderFactory. This registration can be performed either by launching installer of dotConnect for SQL Server with the compact install type (the licenses.licx file is not required in this case), or manually as it is described in the Deployment topic.
The license resource cannot be compiled automatically when your project does not have reference to Devart.Data.SqlServer.dll or dotConnect for SQL Server is not installed on your build server. This section describes how to compile the required resource manually.
Generate licensing resource file using following command line:
"%Compiler Path%\lc.exe" /target:MyApplication.exe /complist:licenses.licx /i:"%Assembly Path%\Devart.Data.SqlServer.dll"
Where
License compiler will generate 'MyApplication.exe.licenses' resource file. You should add this file to your project as an embedded resource. Note that you should not add licenses.licx to the project because the *.licenses file already includes all the necessary license information.
If the default namespace of your project is not an empty string, it must be the same as the target assembly name (in this case - 'MyApplication'). IDE adds the default namespace to the resource name when building application, so you have to rename 'MyApplication.exe.licenses' to 'exe.licenses' before adding it to project. If the default namespace of your project is not set (is an empty string) you do not have to rename the resource file before adding it to project.
You can also generate the license resource manually for the class library assembly (*.dll) in the same way. Just place licenses.config in the folder with your licenses.licx (and change /target:MyApplication.exe to /target:YourClassLibraryName.dll).
When something's wrong with license information you get one of the following exceptions on connecting to server:
Exception text | Possible reasons and what to do |
---|---|
License not found... |
This generally indicates that license information could not be found, or you try to apply it in some way that does not suit the kind of application. This problem may occur over one of the following reasons:
To fix the problem determine type of your application and read corresponding section in this topic. This exception can be thrown by SqlDataAdapter.Fill method, in case when SqlConnection had never been opened. To avoid the problem just open (or open and close) any connection before calling the SqlDataAdapter.Fill method. |
License not valid... |
This means that license information was found but it is incorrect. It usually happens in the following cases:
If you encounter one of these problems, do the following (the numbers of actions correspond to the numbers of the problems in the above list):
If this does not help, send a small compiled binary with sources to our support address, so we can investigate the problem in more details. |
Sorry, your trial period has expired... |
This exception indicates that you used trial version of dotConnect for SQL Server, and the 30 days trial period is expired. To continue using dotConnect for SQL Server register it or uninstall from your machine. You can also see this message if the application was compiled with registered version of dotConnect for SQL Server, but deployed with trial assembly Devart.Data.SqlServer.dll. If this is the case, replace old files with latest assemblies. |