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.