No provider of type <Filestream> found. Check the server configuration or install the provider on the client.

Nov 11, 2011 at 8:59 AM

 

Hi ,

I have installed RBS.msi on  Window 7 32-bit machine and tried to do a simple BLOB store in a website. Below is the code snippet.

string connectionString = ConfigurationManager.ConnectionStrings["TestDBConnectionString" ].ToString();

 InitializeDatabase();

 using (SqlConnection conn = new SqlConnection 

(connectionString)) (conn);

 using (SqlRemoteBlob

blob = blobContext.CreateNewBlob()) {

 

byte[] blobData = Encoding.Unicode.GetBytes("Remote Blob Storage Sample Application Store Simple Test Data"

);

blob.Write(blobData, 0, blobData.Length);

 

blob.Commit();

}

}

But getting below error:

No provider of type  <Filestream> found. Check the server configuration or install the provider on the client.

I checked even machine.config it has the all required config sections related to RBS .

Please help on this what might be the wrong?



{

conn.Open();

 SqlRemoteBlobContext blobContext = new SqlRemoteBlobContext

 
Nov 12, 2011 at 12:23 AM

Hi,

What CLR version are you running currently? We have had issues in the past where .Net 4.0+ applications hit this error.

Also, can you post the complete call stack for this exception? This will give us more idea about the possible root cause.

Thanks,

Vijendra.

Nov 13, 2011 at 10:56 AM

The Dotnet framework is 4.0.. By pointing to 3.5 framework..the issue will be solved ?

 

Nov 13, 2011 at 10:26 PM

It should. If you are still facing issues, then having a complete call stack will help.

Thanks,

Vijendra.

Nov 14, 2011 at 5:44 AM
Edited Nov 14, 2011 at 6:27 AM

Hi Vijendra,

Thanks for your reply.

Below is the call stack

   at Microsoft.Data.SqlRemoteBlobs.ProviderSession.Connect()
   at Microsoft.Data.SqlRemoteBlobs.RemoteBlobCommand.LocateAndInitializeProvider()
   at Microsoft.Data.SqlRemoteBlobs.RemoteBlobCommand.ExecuteInternal()
   at Microsoft.Data.SqlRemoteBlobs.RemoteBlobCommand.Execute()
   at Microsoft.Data.SqlRemoteBlobs.SqlRemoteBlob.OpenWritableBlobStream()
   at Microsoft.Data.SqlRemoteBlobs.SqlRemoteBlob.InitializeForWrite(Byte[] buffer, Int32 offset, Int32 count)
   at Microsoft.Data.SqlRemoteBlobs.SqlRemoteBlob.Write(Byte[] buffer, Int32 offset, Int32 count)
   at _Default.Button1_Click(Object sender, EventArgs e) in d:\VSProjects\RBSSample\Default.aspx.cs:line 45

Thanks,

Prasad N

 

Nov 15, 2011 at 1:35 AM

So should I assume that it didn't work with .Net 3.5?

Nov 15, 2011 at 8:26 AM

Yes ..its worked with Dotnet 3.5

Nov 15, 2011 at 8:22 PM

That's good to know. We already have a fix ready for this issue which will be shipped with a later version. We'll update codeplex as it becomes available.

Thanks,

Vijendra.