Adding pictures to my Database

Hello everyone!,
I'm a new user of SQL 2000 and I would like to build a database that contains pictures. This database will be used to store information regarding my products and of course I would like to show the user what I'm referring to. Any and
replies are welcomed!
Santiago Ortiz
Santiago,
many people just hold the image paths in varchar fields and the actual files
on the OS, but if you do ant to do this programatically, these articles will
help:
HOWTO: Retrieve and Update a SQL Server Text Field Using ADO
http://support.microsoft.com/?kbid=180368
HOWTO: Access and Modify SQL Server BLOB Data by Using the ADO Stream Object
http://support.microsoft.com/?kbid=258038
Using Textcopy.exe
http://www.databasejournal.com/featu...le.php/1443521
HTH,
PAul Ibison
|||Santiago,
many people just hold the image paths in varchar fields and the actual files
on the OS, but if you do ant to do this programatically, these articles will
help:
HOWTO: Retrieve and Update a SQL Server Text Field Using ADO
http://support.microsoft.com/?kbid=180368
HOWTO: Access and Modify SQL Server BLOB Data by Using the ADO Stream Object
http://support.microsoft.com/?kbid=258038
Using Textcopy.exe
http://www.databasejournal.com/featu...le.php/1443521
HTH,
PAul Ibison

Adding pictures to my Database

Hello everyone!,
I'm a new user of SQL 2000 and I would like to build a database that contain
s pictures. This database will be used to store information regarding my pro
ducts and of course I would like to show the user what I'm referring to. Any
and
replies are welcomed!
Santiago OrtizSantiago,
many people just hold the image paths in varchar fields and the actual files
on the OS, but if you do ant to do this programatically, these articles will
help:
HOWTO: Retrieve and Update a SQL Server Text Field Using ADO
http://support.microsoft.com/?kbid=180368
HOWTO: Access and Modify SQL Server BLOB Data by Using the ADO Stream Object
http://support.microsoft.com/?kbid=258038
Using Textcopy.exe
http://www.databasejournal.com/feat...cle.php/1443521
HTH,
PAul Ibison

Adding pictures to my Database

Hello everyone!,
I'm a new user of SQL 2000 and I would like to build a database that contains pictures. This database will be used to store information regarding my products and of course I would like to show the user what I'm referring to. Any and replies are welcomed!
Santiago OrtizSantiago,
many people just hold the image paths in varchar fields and the actual files
on the OS, but if you do ant to do this programatically, these articles will
help:
HOWTO: Retrieve and Update a SQL Server Text Field Using ADO
http://support.microsoft.com/?kbid=180368
HOWTO: Access and Modify SQL Server BLOB Data by Using the ADO Stream Object
http://support.microsoft.com/?kbid=258038
Using Textcopy.exe
http://www.databasejournal.com/features/mssql/article.php/1443521
HTH,
PAul Ibison