Saving images in a SQL Server DB using ADO 
Author Message
 Saving images in a SQL Server DB using ADO

How can i save images in a SQL Server database using ADO??
What is the SQL Server data type that i must use in this situation??

any help appreciated,
Gon?alo Bolo, Portugal



Tue, 28 Jan 2003 03:00:00 GMT  
 Saving images in a SQL Server DB using ADO
use the BLOB data type, you must get the image from the database using
GetChunk and usually the size of your chuck is equal to or less than 4096

But SQL server wasn't designed to store images in the database, it should be
slow, all the books I've read on SQL say don't do it


Quote:
> How can i save images in a SQL Server database using ADO??
> What is the SQL Server data type that i must use in this situation??

> any help appreciated,
> Gon?alo Bolo, Portugal



Tue, 28 Jan 2003 03:00:00 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. How to retrieve a bitmap-image from a SQL Server image field using ADO

2. Saving Images in SQL Server DB

3. Saving images to SQL Server using VB.net

4. Visual Basic App using Foxpro DB vs Access DB vs SQL Server DB

5. Visual Basic App using Foxpro DB vs Access DB vs SQL Server DB

6. Saving images out of SQL 7 to disk using ADO

7. Saving images out of SQL 7 to disk using ADO

8. VB6 application using SQL Server 2000 migrating db to SQL Server 2

9. Assigning a picture to an Image field in SQL server, using ADO

10. How to store images using ADO in SQL Server 2000

11. how to upload image to sql server by using ADO

12. Save image in Sql Server and retrieve image from sqlserver to vb

 

 
Powered by phpBB® Forum Software