Click here to Skip to main content
14,426,057 members
Rate this:
Please Sign up or sign in to vote.
I have a program that uses an outside MS Access database to grab information and manipulates using an internal dataset, then displays it using a report viewer. This function works perfectly well on my computer which has SQL Server 2008 R2 and SQL Server 2012 installed. However, when I try to install, it requires assemblies Microsoft.SqlServer.Types versions 10.0.0.0 and 11.0.0.0.

I tried using the add reference gui in Visual Studio, but since they are same name, the compiler did not accept adding the two references. Digging into it a little, I tried to add the references through the vbproj file.

<Reference Include="Microsoft.SqlServer.Types, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91, processorArchitecture=MSIL">
      <SpecificVersion>True</SpecificVersion>
      <HintPath>C:\Program Files (x86)\Microsoft SQL Server\100\SDK\Assemblies\Microsoft.SqlServer.Types.dll</HintPath>
<Aliases>testing1</Aliases>      
<Private>True</Private>
    </Reference>
    <Reference Include="Microsoft.SqlServer.Types, Version=11.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91, processorArchitecture=MSIL">
      <SpecificVersion>True</SpecificVersion>
      <HintPath>C:\Program Files (x86)\Microsoft SQL Server\110\SDK\Assemblies\Microsoft.SqlServer.Types.dll</HintPath>
      <Aliases>testing</Aliases>
      <Private>True</Private>
    </Reference>


I am trying to use aliases testing and testing1. However, when I try to deploy the project, I notice that version 11.0.0.0 gives me no issues, however 10.0.0.0 is not recognized.

I am not sure how to include this without having to install the libraries in GAC through installing SQL Server 2008 R2 - I do not have install permissions for that installation for whatever reason.

Thanks for the help.
Posted
Comments
Chamadness 1-Apr-14 1:30am
   
I am not sure about how much your project depends on 2008 R2, but try to remove your dependency on R2 and reference only SQL 2012 components, if that is applicable.
ayaraneri3 1-Apr-14 7:39am
   
The issue is i'm not sure what components of my code require 10.0.0.0 and what requires 11.0.0.0. I'm hesitant in going through process of elimination with an almost complete project. Is there a way of knowing this through Visual Studio?
Rate this:
Please Sign up or sign in to vote.

Solution 1

Hi
I second that you should remove dependencies to older SQL implementation MSSQL server is generally backwards compatible. Anyway check out this dependency tracker for project files and see in more detail.

Incidently although your project is almost finished, nothing is stopping you from copying entire root folder to somewhere safe AND use a repository to keep your rollback options open :)

http://dependencyfinder.codeplex.com/
   
Rate this:
Please Sign up or sign in to vote.

Solution 2

I had simmilar Problem with log4net

this helped me[^]
to have 2 Versions of it running at a time.
it hope it fits your problem ;)
   

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100