Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Retrieving FileStream from SQL Server
Message
De
12/07/2011 15:18:49
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9 SP2
Database:
MS SQL Server
Divers
Thread ID:
01517970
Message ID:
01518004
Vues:
54
>>>>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform