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

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

作　　者：潘建新[1] 

机构地区：[1]湖州师范学院网络教学中心,浙江湖州313000

出　　处：《湖州职业技术学院学报》2006年第4期80-84,共5页Journal of Huzhou Vocational and Technological College

摘　　要：利用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.

关 键 词：ASP SQL SERVER 2000 图像 IMAGE数据类型 

分 类 号：TN911.73[电子电信—通信与信息系统]