Click here to Skip to main content
15,885,985 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
How does one save a file into an sql server database using ado in c++?
Posted
Comments
Peter Leow 5-Feb-14 7:49am    
Suggest save files to a file server and store the file names in the database, this way it is more efficient, manageable and scalable.

1 solution

As Peter mentioned the right way isnt to save the file in the db, but to copy and store the file somewhere on your db server and only save the path to the file.

This ensures that the db will not get bloted and you have good access times not only for the db but for the files. Another problematic szenario is backup for the db.

Think of it like a DMS
 
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