devxlogo

Put Customer Order Information Into SQL Server 7.0

Put Customer Order Information Into SQL Server 7.0

Question:
I have a shopping cart on my e-commerce site. When people submit their orders, instead of getting an e-mail with their order in it, I want that information to be directly put into SQL Server 7.0. How can I do this?

Answer:
If you use Microsoft Internet Information Server 4.0, you can put the customer order information into Microsoft SQL Server 7.0 without any additional software. IIS comes with a feature called Active Server Pages (ASP) which allows for processing to occur on the Web server and send the results of that processing to the Web browser. Most of the time, that processing on the Web server will generate HTML. That HTML gets returned to the Web browser. IIS also comes with Microsoft’s newest data access technologies, OLE-DB and ActiveX Data Objects (ADO). You can use ASP to extract data from a Web page and write data to a SQL Server database.

See also  5 Ways to Improve Customer Experience
devxblackblue

About Our Editorial Process

At DevX, we’re dedicated to tech entrepreneurship. Our team closely follows industry shifts, new products, AI breakthroughs, technology trends, and funding announcements. Articles undergo thorough editing to ensure accuracy and clarity, reflecting DevX’s style and supporting entrepreneurs in the tech sphere.

See our full editorial policy.

About Our Journalist