General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Thanks Vlad
That could work I guess, but as you say pity it is so messy.
I also considered storing the scans on the WAN somewhere and just storing links to them in SQL Server. However a lot the scanned mail will be confidential. Perhaps I could get our network guys to set up a secure area on the WAN and get VFP to look in that area for them. I would have to embed a paasword into the app.
If I did this would my user then be able to gain access to all the scans from Explorer or something. This of course would not be desirable.
>
>The best way to store binary data on SQL Server is to use image field on SQL Server. You're asking right question about general field - it is quite messy to handle it. There are workaround to use Memo field in VFP to store binary data and than map it to image field on SQL server. See following
>FAQ#7995713 in Frequently Asked Questions section -> Client/server -> "How to work with Image field type on SQL Server?"
>
>
>>We are hoping to scan all incoming post using a VFP Frontend.
>>
>>We want the results of these scans to be stored in a SQL Server backend and accessed over our WAN (Kilostream so pretty slow)
>>
>>1. Does SQL Server support the General Fields neccesary to store our scans.
>>
>>2. Is our WAN too slow.
>>
>>3. Is this a good idea or is their a better way we dont know about.
>>
>>Many Thanks
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only