关于ASP与SQL Server 2000间图像文件存取的研究和实现

Research About Access of Image Files Between ASP and SQL Server 2000

利用VB的ADO Stream对象访问和修改SQL Server BLOB数据的技术,建立ActiveX服务器组件,实现了在ASP中对任意给定的gif/jpg图像文件上传至服务器并保存在SQL Server Image列中。用ASP中GetChunk方法读取SQL Server Image列中的图像数据,实现了在浏览器端图像与文字的混合显示。

This paper introduces the technology of access and modifyiag SQL Server BLOB data by using ADO Stream of VB to establish ActiveX Server Component, achieve any image file of JPG/GIF, upload to Server and then save to the row of image in SQL Server 2000 in order to read image data from the row of image in SQL Server using Get Chunk method and Append Chunk method which are provided by ADO object in ASP, and achieve image and text display in the browser document server.