Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Retrieving FileStream from SQL Server
Message
 
 
To
12/07/2011 14:25:25
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:
01518003
Views:
46
>>>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
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform