Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Returning a file through a stored procedure
Message
From
12/05/2017 15:37:14
Antonio Lopes (Online)
BookMARC
Coimbra, Portugal
 
 
To
12/05/2017 15:16:34
Walter Meester
HoogkarspelNetherlands
General information
Forum:
Visual FoxPro
Category:
Client/server
Environment versions
Visual FoxPro:
VFP 9 SP2
Database:
MS SQL Server
Miscellaneous
Thread ID:
01651070
Message ID:
01651076
Views:
79
>>>@All,
>>>
>>>We are investigating whether it would be possible to return a file somewhere that the SQL server service has access to by calling a stored procedure.
>>>We do not want to store the file itself in the database, but we want to return and store the through simple calls through ODBC.
>>>
>>>Is there anything like that possible ? Wihtout using CLR ?
>>>
>>>Walter,
>>
>>Perhaps this can be of help: https://www.mssqltips.com/sqlservertip/1643/using-openrowset-to-read-large-files-into-sql-server/
>
>Its interesting for reading files, but how to write them?

Hum. http://kbase.icbconsulting.com/sql-server/create-text-files-from-sql-server-data (disclaimer: just googling around...).
----------------------------------
António Tavares Lopes
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform