Click here to Skip to main content
15,886,258 members
Please Sign up or sign in to vote.
5.00/5 (1 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.

HTML
<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?

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/
 
Share this answer
 
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 ;)
 
Share this answer
 

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



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900