Jet Reports Homepage |  Community Forum |  Downloads |  Submit A Ticket |  Jet Express Support
Feedback

Error: Could not load file or assembly 'Microsoft.SqlServer.ConnectionInfo'


Symptoms

When trying to connect to a database on a remote server the following error message may appear:


Could not load file or assembly 'Microsoft SqlServer.ConnectionInfo, Version=9.0.242.0, Culture=neutral,PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.

Resolution

The Jet Data Manager uses SQL Server Management Objects (SMO), which is a collection of objects that are designed for programming all aspects of Microsoft SQL Server. To ensure proper installation:

  • SMO objects need to be of the same version (e.g.: SQL 2005, SQL 2008, etc.) as the destination SQL Server (The server where the project repository, stage and data warehouse reside)
  • SMO objects need to have the same bit rate (32-bit or 64-bit) as the Jet Data Manager

Before Installing SMO Objects

To properly install SMO objects you may need to install these additional components.

  • Microsoft Core XML Services (MSXML)
  • Microsoft SQL Server Native Client
  • Microsoft SQL Server System CLR Types

These components are part of the SQL Server feature pack, which is a collection of stand-alone installation packages that provide additional value for SQL Server. Make sure you select the feature pack that corresponds to your version of SQL Server.

Note: SMO objects will not install properly until all additional components are installed.

Note: The additional components may differ between SQL Server versions. For example SQL Server 2005 doesn't require CLR Types.

Installing SMO Objects

To install SMO objects find the feature pack that corresponds to your version of SQL Server. Then choose the SMO Objects that correspond to your version of the Jet Data Manager (32-bit or 64-bit). In this example we are downloading the 64-bit version of:

  • Microsoft Core XML Services (MSXML)
  • Microsoft SQL Server Native Client
  • Microsoft SQL Server System CLR Types
  • SMO Objects


Once the files has been download run the setup files and follow the installation wizard.

Enabling ADO.NET

Once SMO objects have been installed on the server you will want to enable ADO.NET.

1. Right click on the top node of the project tree and click Edit Project .


2. Deselect the check boxes for Use Integration Services .

3. Click OK .


Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments