Use SQLServer to provide images for Web browsers. The Microsoft SQLServer database server can store images and a large amount of text in the SQL database. The image and text data types are image and text respectively. Let us assume that the Microsoft SQL Server database Server can save images and a large amount of text in the SQL database. The image and text data types are image and text respectively. If you use VB or VC to develop a front-end application and run it on a windows operating system, you can easily extract image data from the SQL database and put it into a file, and displayed on the screen. However, it is not easy to get an image from SQL Server and display it in a Web browser. Although Web assistants and storage processes sp_makewebtask and sp_runwebtask are provided in Microsoft SQL Server 6.5, they can convert data in the SQL database into HTML files, but we have better solutions. One problem with Web assistant is that it does not accept fields of the image data type. On the other hand, the storage process sp_makewebtask has too many parameters and is difficult to use. it is also difficult to customize Web pages.
Here we provide a solution to load images from SQL data to a Web browser, which is better than sp_makewebtask. We developed a Web project using an ActiveX dynamic link library and an ASP page. The dynamic link library is responsible for opening the connection to the SQL database that saves images, extracting images from the database, and saving them in temporary files. ASP communicates with the dynamic link library to obtain the location of the temporary image file. In this way, when a visitor clicks a Web site, the image will be downloaded to his browser. In this article, we will introduce how to set up the SQL database. Then, we will introduce how to use VB5 and the activity data object ADO 1.5 to create an ActiveX dynamic link library. Finally, we will discuss how to create an ASP Web project, connect to the SQL database, and compile ASP files.
The Server database Server can store images and a large amount of text in the SQL database. The image and text data types are image and text respectively. Suppose that...
