I am also getting the microsoft.sqlserver.types error. Mine comes up when I try to create a table adapter in a VS2008 project.
I have a reference to this assembly in my config file: <add assembly="Microsoft.SqlServer.Types, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845DCD8080CC91"/> I use the assembly because I'm working with spatial data types, and it is much easier to access their functions by using a type. Unfortunately after uploading the new config file, I receive this error: Could not load file or assembly 'Microsoft.SqlServer.Types, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified. Does anyone have any advice on what to do? Is there a way to copy the dll file, or does it need to be installed in the GAC? Cheers, David
Just needed to copy the Microsoft.SqlServer.Types.dll to the bin folder and upload it. Surprised that the SqlServer assemblies are not in the servers GAC, though. Cheers, David