dotConnect for SQL Server is provided as a single setup package that contains all required files for Full .NET Framework and documentation.

By default dotConnect for SQL Server installs all files in "Program Files\Devart\dotConnect\SQL Server" folder. The setup program also adds the necessary assemblies to the Global Assembly Cache by default. You can omit adding assemblies to GAC by selecting the Do not install assemblies in the GAC check box on the Additional Tasks installation wizard page. To install only *.dll files needed to run applications that use dotConnect for SQL Server, you can select "Minimal" install in the setup program.

Some files are shared by Devart data providers. These assemblies are copied to the "\Program Files\Common Files\Devart\dotConnect\5.00\Net2\" folder. If you have several Devart data providers, make sure they use same version of the Devart.Data.dll assembly.

There are some limitations in Express Editions of Visual Studio. Particularly, the automatic toolbox components registration and Server Explorer integration are not available. You can, however, install components into toolbox manually as described below. As an exclusion, Visual Web Developer supports Server Explorer integration features.

Command Line Installation Keys

dotConnect for SQL Server installer is created with Inno Setup. Its standard setup command line parameters article is available at http://www.jrsoftware.org/ishelp/topic_setupcmdline.htm.

Also there are additional installation keys:

• /nomachineconfig - no provider factory registration in DbProviderFactories section of machine.config.
• /verysilent and /silent - besides standard Inno Setup functionality, no FAQ page is shown after installation is finished.
• /nofeedback - no Feedback page is opened after uninstall.
• /nomergepackage - not install menu item and toolbox components into Visual Studio.
• /mergehelp - merge Devart documentation to MS Help collection.
• /disablegac - omit adding assemblies to GAC.

Example:

• the minimal type installation (only run-time assemblies and registration in machine.config)

   dcsqlserver.exe /TYPE=COMPACT /VERYSILENT /NOICONS

• uninstall

  \Program Files\Devart\dotConnect\SQL Server\Uninstall\unins000.exe /VERYSILENT /NOFEEDBACK

The following table contains the list of components, that can be used with the /COMPONENTS key.

Component name	Parameter
Visual Studio integration *	VsIntegration
ASP.NET Web Providers	WebProviders
SQL Server Business Intelligence Solutions	SSIS
Enterprise Library Data Access Block	EntLib
Samples	Samples
Help files	HelpFiles

* You may use the "*VsIntegration" parameter (with asterisk) to integrate the provider to all the installed Visual Studio versions, which are supported by dotConnect for SQL Server. To install it only to Visual Studio 2010, for example, use "VsIntegration\VS2010" parameter.

Microsoft Visual Studio

dotConnect for SQL Server components are automatically registered in Toolbox when you start the Visual Studio first time after successful installation of dotConnect for SQL Server. If automatic registration fails, do the following steps to install the components manually:

• In Visual Studio open the Toolbox window;
• Add a 'SQL Server' tab by right-clicking the Toolbox window and then clicking Add Tab;
• Right-click the added tab and then click Choose Items...;
• In the opened Choose Toolbox Items dialog box switch to the .NET Framework Components tab;;
• Select the components the Namespace column of which starts with "Devart";
• Click OK.

Since now dotConnect for SQL Server components are available from toolbox.

CodeGear Delphi 2007

Because of the IDE restrictions design time is not available.