0

I have a situation in which data (mostly images) is stored in a BLOB. As you know data in BLOB are guid like which I cannot relate to any file. My question is, is there a way by which I can extract the real path, file name etc of that particular BLOB. The idea behind this question is to create an extra table in which I will list the blob values and associate with them the file name etc... EXAMPLE:

BLOB Value1| ASCII Value1|BLOB Value2| ASCII Value2|BLOB Value3|ASCII Value3
1123123    |  C:\        | 324234    | picture     |345345453  | .jpg

Please note I am a newbie in this area just finished installing my first BLOB

1 Answer 1

2

What is the purpose behind the table? Accessing the BLOB data directly outside of the SP API is not supported.

That being said, MS has a sample RBS implementation and details how it works which may help you out.

http://msdn.microsoft.com/en-us/library/cc905212(v=sql.100).aspx

6
  • thanks for your answer, basically i need to create an xml file with data of blob and real data, basically imagine the table above in xml.
    – IanCian
    Jul 14, 2011 at 13:55
  • @IanCian As @JesusShelby has said, accessing BLOB data directly outside of the API is not supported.
    – Alex Angas
    Jul 14, 2011 at 23:23
  • Hi there can you please help me and give me some examples, useful links for me to understand this API in order to be able to get the content in a database + blob information
    – IanCian
    Jul 15, 2011 at 7:29
  • Example: I want to make a C# application which reads information from the content_database of sharepoint and read the blob data as well in order to display it outside of sharepoint
    – IanCian
    Jul 15, 2011 at 7:53
  • I don't think you will find any specific examples. Here are more examples of the RBS provider: sqlrbs.codeplex.com Jul 15, 2011 at 12:41

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.