Namespace and DLL Issue - VS Projects Cannot Find Microsoft.Data.SqlRemoteBlobs

Mar 10, 2010 at 9:32 PM

Hello,

I installed SQL Server 2008 RC2 and the RBS Sample provider on my development box (Windows Server 2008).  I see the  Microsoft.Data.SqlRemoteBlobs and Microsoft.Data.BlobStores.FilestreamBlobStore in the GAC however I cannot import the namespaces or assembles (e.g. I cannot even add the references) into projects and cannot successfully use

using Microsoft.Data.SqlRemoteBlobs;
using Microsoft.Data.BlobStores;
 

Is there something I'm missing?

  • Installed SQL Server 2008 RC2
  • Installed SQL Server 2009 RC2 Management Studio
  • Installed Remote Blob Storage (.msi)
  • Edited the InstallProvider.cmd file to reflect my system/environment's set-up
  • Ran the RBS Samples InstallProvider.exe
  • Opened the RBS_Samples solution
    • See "squiggly" lines under the namesace imports

My machine.config may have issues, the references to the RBS Samples and namespaces that I see in it are:

<sectionGroup name="RemoteBlobStorage" type="System.Configuration.ConfigurationSectionGroup, System.Configuration, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a">
 
<RemoteBlobStorage>
		<Logging>
			<add key="EventViewerLog" value="4"/>
			<add key="FileLog" value="0"/>
			<add key="ConsoleLog" value="0"/>
			<add key="CircularLog" value="0"/>
			<add key="DatabaseTableLog" value="0"/>
		</Logging>
		<InstalledVersions>
			<add key="Count" value="1"/>
		</InstalledVersions>
		<Providers>
			<filestream>
				<add key="BlobStoreType" value="Filestream"/>
				<add key="DllFile" value="C:\Program Files\Microsoft SQL Remote Blob Storage 10.50\Provider Libraries\Filestream Provider\\Microsoft.Data.BlobStores.FilestreamBlobStore.dll"/>
				<add key="ClassName" value="Microsoft.Data.BlobStores.FilestreamBlobStore.FilestreamStoreLibrary"/>
				<add key="ProviderVersion" value="1.0.0.0"/>
				<add key="MinSupportedBackEndStoreVersion" value="1.0.0.0"/>
				<add key="BlobStoreAbstractClassVersion" value="10.50.0.0"/>
				<add key="EnumerationOptimizationLevelImplemented" value="2"/>
				<add key="ConsistencyCheckLevelImplemented" value="2"/>
			</filestream>
		</Providers>
		<ProviderSpecificConfigKeys>
			<filestream>
				<add key="schema_suffix" value="Name"/>
				<add key="max_size_inband_read" value="Number"/>
				<add key="tran_pool_size" value="Number"/>
				<add key="tran_pool_tran_lifetime" value="Duration"/>
				<add key="async_read_disabled" value="Boolean"/>
				<add key="filegroup_name" value="Name"/>
				<add key="data_filegroup_name" value="Name"/>
				<add key="max_pool_size" value="Number"/>
				<add key="max_size_inband_write" value="Number"/>
				<add key="max_size_inline_blob" value="Number"/>
				<add key="write_allocation_size" value="Number"/>
				<add key="async_write_disabled" value="Boolean"/>
			</filestream>
		</ProviderSpecificConfigKeys>
	</RemoteBlobStorage>

 

 

Mar 10, 2010 at 9:54 PM
Edited Mar 25, 2010 at 6:14 PM

The locations of the client dlls may be different on your machine. In the relevant VS project, expand the references listing and delete the existing SqlRemoteBlobs / FilestreamBlobStore entries if they are there. You can then right click and add reference, then hit the Browse tab and navigate to the location you installed RBS to and re-add the .dll files.

 

Let me know if this doesn’t resolve the issue or if you have any other questions.

 

Thanks

 

mike

 

Mar 10, 2010 at 11:07 PM

I re-ran the InstallProvider.cmd file from an administrator command prompt and noticed it gave me the following message.  I am using SQL Server 2008 Express RC2 and I have no way to get the Developer (not on MSDN) or Enteprise Editions.

C:\Binaries>InstallProvider.cmd
-------------------------------------
Registering File Store Provider
SQL Server Instance: [HiddenServerName]\SQLEXPRESS
Database: LargeFileStorage
File Store Library Binary Location: C:\Binaries\
ProviderName: FileStoreProvider_1
Data Location: L:\RBSFileStoreData\

SQL Remote Blob Storage Provider Installation Utility

Checking connection to database and installation state of RBS.
Current RBS State: 2
Checks to see if the blob store name <FileStoreProvider_1> is currently installe
d.
Registering the provider configuration into the .NET machine.config file.
Add blob store with information:
 RegistrationFile C:\Binaries\RegisterFileBlobStore.sql, BlobStoreName FileStore
Provider_1, Location c:\rbs_test_data.
Blob store type <File> cannot be use with this edition of SQL Server. Upgrade th
e server to Enterprise or Developer Edition.
Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMM
IT statements. Previous count = 1, current count = 0.

Mar 10, 2010 at 11:13 PM

Yes, this is a licensing requirement of RBS. You need to have Developer, Enterprise or higher edition of SQL Server to be able to use any provider other than the local Filestream provider. If you cannot get a developer edition, you can use the local Filestream provider that ships with RBS.

Thanks,

Pradeep.

Mar 11, 2010 at 12:19 AM

Thanks.  Do you happen to know how long the SQL Server 2008 R2 Enterprise Evaluation November CTP lasts for?  I need to build a POC that uses SQL Server Remote Blob Storage.

Mar 15, 2010 at 8:27 PM

The CTPs are good til June 30th 2010.