Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Retrieving FileStream from SQL Server
Message
From
12/07/2011 15:18:49
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP2
Database:
MS SQL Server
Miscellaneous
Thread ID:
01517970
Message ID:
01518004
Views:
53
>>>>Thanks :)
>>>>
>>>>Seriously, I got confused by the whole BULK and OPENROWSET stuff having never seen nor used them before.
>>>
>>>I'm thinking you're not using Filestream. You're using varbinary(max) to store data. Is it correct?
>>>
>>>In the meantime I got pointed to this
>>>http://msftdpprodsamples.codeplex.com/
>>>
>>>In this page scroll down to Ole Db and see FileStream there. However, I believe it is showing .NET example and I'm not sure it will be easy to adapt to VFP (if possible at all).
>>>
>>>I'll ask Gail (who is the documentation manager) if it's possible.
>>
>>Why do you think I am not using filestream?
>
>Because the samples on the filestream page are confusing. They are not using blob syntax.
>BOL reference about FileStream

I was following this example:

http://www.sqlservercentral.com/articles/FILESTREAM/67668/

However, I am a little concerned now. I thought that I should see a file in the folder that I set up as the path for the files to get stored that I can then open with Adobe reader. There is a file there but when I try to open with Adobe Reader it says it can't.
Frank.

Frank Cazabon
Samaan Systems Ltd.
www.samaansystems.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform