Click here to Skip to main content
15,891,916 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Good Day

I am trying to figure out a way to be able to store files on a SQL Server
SQL database to store the file name and path
File to reside on the Server
User to be able to Login to SQL Server and Retrieve File
I Do not want to store files as Byte(s) in a Field
So want to be able to connect to SQL Server - Send and receive Byte file information
But the Byte info to be saved back as a file on the SQL Server

What I have tried:

Have researched this for a while - at one stage i did find an article that in SQL Express 2014 that this could be Done, I sadly lost the article but never went through it to be sure that it could be done? Have researched TCP IP examples - but is one is already using SQL - creates a dual system? Not too sure if this would be the correct approach to load and retrieve files from a server and let the SQL database manage it?
Posted
Updated 17-Apr-18 3:14am

1 solution

Seems like you are looking for FILESTREAM (SQL Server) | Microsoft Docs[^].
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900