I have a problem storing pictures in SQL Server database. I have no idea on how this is done. Can some good Samaritan guide me on how to do this.
God bless,
fbyk.
Programming
Last Comment
Éric Moreau
8/22/2022 - Mon
yronnen
Do NOT store pictures to SQL server!!!
This will KILL the database and it's performances.
A better solution is to store the pictures in a folder and keep the pointer to the pictures in the database. This will also allow you to query the database for the pictures.
I know this is not an answer, but it's a friendly advice.
Cliven
i agree what yronnen said. but i have try to use the VB to develop the program to store and retrived it from the SQL server.
but i don't know are you using the VB to do that or not.
mail me Clivenyong@hotmail.com
i will post the source code here
Cliven , I'm sure you have read the membership agreement,so for your information...in my university students are asked to do this as homework assignment in ....VB
fbyk, if it is homework assignment, try to do it on your own, with maybe some help of Experts when you are stuck on some problem, I'm sure you want to learn how to do it, not just blindly copy some code
To me storing the pictures outside of SQL server and only a reference to the path in a table is the best solution.
I'm using an intranet application (ASP pages and MS SQL 7 server). Users can select pictures from any location, these are then uploaded to a folder on a server and only the path is stored in the sql table.
I'm using AspUpload from Persists Software (www.persists.com) to store the picture in the central folder.
This will KILL the database and it's performances.
A better solution is to store the pictures in a folder and keep the pointer to the pictures in the database. This will also allow you to query the database for the pictures.
I know this is not an answer, but it's a friendly advice.