Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users
COURSE of the MONTH
14 days, 4 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Inserting pictures in SQL database
Posted on 2003-02-18
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.
God bless,
fbyk.
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
2
2- +3
8 Comments
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.
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.
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
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
Follow this link there are some discussions about that
http://www.sqlmag.com/forums/messageview.cfm?catid=12&threadid=8719
you can do it, but if you can store just paths, it would be much better.
http://www.sqlmag.com/forums/messageview.cfm?catid=12&threadid=8719
you can do it, but if you can store just paths, it would be much better.
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
good luck
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
good luck
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.
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.
Gula, This is not my home work pliz! I'm working on a project that requires the record of employee's pictures kept.
Otherwise, thanx for your comments.
Otherwise, thanx for your comments.
Featured Post
Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Whether you've completed a degree in computer sciences or you're a self-taught programmer, writing your first lines of code in the real world is always a challenge. Here are some of the most common pitfalls for new programmers.
Whether you’re a college noob or a soon-to-be pro, these tips are sure to help you in your journey to becoming a programming ninja and stand out from the crowd.
In this fourth video of the Xpdf series, we discuss and demonstrate the PDFinfo utility, which retrieves the contents of a PDF's Info Dictionary, as well as some other information, including the page count. We show how to isolate the page count in a…
- Document Management
- Document Imaging
- Programming
- Adobe Acrobat
- Scripting Languages
- Printers and Scanners, OCR, *Scripts, *PDF, *text file
Suggested Courses
Course of the Month14 days, 4 hours left to enroll
800 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.