How To Disable Cookies That Are Sent by Active Server Pages
(163010) - Active Server Pages (ASP) uses cookies to track SessionIDs. As a result, the browser is sent a cookie when a new session is created. Typically this occurs the first time a particular client requests an ASP page in your Web application. If Internet...
How To Lifetime of a COM Component Under IIS, ASP, and RDS
(166279) - When you create your own ActiveX Server components running under Internet Information Server (Inetinfo.exe) for Active Server Pages (ASP) or Remote Data Service (RDS), you may get the following error message when you try to recompile or overwrite your...
How To Display Images Stored in a BLOB Field
(173308) - Using Active Server Pages (ASP), you can view images stored in BLOB (Binary Large Object) fields in your Internet browser. This article provides information on how to display a GIF image stored in the Microsoft SQL Server sample database table...
HOWTO: Use ADO to Return a Summary Row
(194005) - The sample code in this article demonstrates how to extract the value of summary rows using ADO. Summary rows are produced when you use a COMPUTE BY clause with any row aggregate functions in a SQL statement. These summary values appear as additional...
How To Configure a DLL Surrogate for Use with ASP
(194023) - This article explains how to configure the registry to use in-process components outside the main process either on the same machine or on a remote server. IMPORTANT : This article contains information about editing the registry. Before you edit the...
How To Change Information in a Database from ASP
(188713) - There are two different methods for performing updates and inserts. One way is to create a recordset and then insert/update its records. The other way is to use the Execute method to issue a SQL statement which inserts/updates the records.
How To Insert Text String into SQL Table with Embedded Single Quotes from ASP
(190742) - This article shows how to place text strings into a SQL Server table that contains embedded single quotes. When placing a text string into a SQL Server table that contains an embedded single quote, a second single quote must be placed adjacent to it....
How To Query and Update Excel Data Using ADO From ASP
(195951) - This article demonstrates how to query and update information in an Excel spreadsheet using ActiveX Data Objects (ADO) from an Active Server Pages (ASP) page. The article also describes the limitations that are associated with this type of...
How To Implement Visual C++ COM Objects Returning Recordsets
(225131) - This article describes, by example, how to implement a Visual C++ Component Object Model (COM) object that returns a recordset to Active Server Pages (ASP). Implementing this incorrectly can result in memory leaks or one of the following errors: The...
PRB: ASP Session Is Lost When You Use Cisco Local Director and SSL Session to Route
(251027) - When you implement a Web farm and use a routing product such as Cisco Local Director, you may notice that Active Server Pages (ASP) session state is lost.
How To Retrieve Relational Data with OpenXML in an ASP Client
(272271) - Running an OpenXML statement in SQL Server 2000 returns an XML data stream back to the client. This article contains a sample that prints the contents of the XML document back to the client application through an ADODB.Recordset.
How To Determine Parameter Requirements for a Stored Procedure in ASP
(165156) - This article provides the ASP code necessary to programmatically determine the parameter requirements for any stored procedure. The sample code provided determines the parameter name, data type, direction, and size of all parameters in a stored...
How To Retrieve Bitmap from Access and Display It in Web Page
(175261) - This article shows by example how to extract the bitmap photos in the Microsoft Access 97 Nwind.mdb database, and view them from a Web browser using Active Server Pages (ASP). In order to accomplish this task, an ActiveX DLL must be created that...
How To Install Active Messaging 1.1 for Use with Active Server Pages
(174636) - The Microsoft Exchange Active Messaging component, formally known as OLE Messaging, is designed to work with Microsoft Internet Information Server 3.0 (IIS 3.0) as a server-side component. While Active Messaging calls can be made from both server- and...
How To Use ASP with a SQL Trusted Connection with Guest Account
(176380) - When you use Microsoft SQL Server with Integrated or Mixed Security with Microsoft Internet Information Server (IIS), it may be necessary to access SQL Server from a guest account. You can set up a guest account to work around problems connecting an...
How To Populating a FlexGrid Control with ADO and ASP
(189406) - The FlexGrid ActiveX control is a powerful control to display and manipulate data from a database in Internet Explorer. This sample uses Visual InterDev's DataCommand Design-time control to access the datasource. The client-side script uses a call to...
How To Retrieve RAW/LONG RAW Data from Oracle for ASP Page
(194799) - This article explains how to insert and retrieve RAW or LONG RAW data from an Oracle database for use in an Active Server Pages (ASP) page.
How To Implement Visual Basic COM Objects Returning Recordsets
(224424) - This article describes, by example, how to implement a Visual Basic Component Object Model (COM) Object that returns a recordset to Active Server Pages (ASP). Implementing this incorrectly can result in memory leaks or one of the following errors: The...
How To Determine Browser Type in Server-Side Script Without the BrowserType Object
(272413) - There are two common methods in server-side script to determine information about the browser that is being used by the client: The BrowserType object The Request.ServerVariables("HTTP_USER_AGENT") method This article describes the...
How To Pass Form Data from One Page To Another by Using GET and POST in Active Server Pages
(300104) - One of the most commonly performed actions in Active Server Pages (ASP) Web development is passing data from one page to another for processing. This article contains step-by-step examples to demonstrate how to do this. Two techniques are involved:...
PRB: ASP Error 80004005 "Data Source Name Not Found"
(306345) - When you use ActiveX Data Objects (ADO) or ODBC to open a database connection in an Active Server Pages (ASP) page, you may receive the following error message: Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Microsoft][ODBC Driver...
How To Generate a Dump File When ASP.NET Deadlocks in IIS 6.0
(828222) - When you experience a deadlock in Internet Information Services (IIS) 6.0, an error that is similar to the following will appear in the application event log: Event Type: Warning Event Source: W3SVC-WP Event Category: None Event ID: 2262 Date:...
PRB: Server.CreateObject Fails for Local Servers(EXEs)
(156675) - When you call Server.CreateObject on a local server, the following error may occur: Initialization of dynamic-link library C:Winnt35SystemUser32.dll failed. The process is terminating abnormally. As a result, the local server is not launched.
PRB: ASP Error "The Query Is Not Updateable" When You Update Table Record
(174640) - One of the following errors occurs when you update a table record from an Active Server Pages (ASP) page through ADO's Recordset.update method: Source: Microsoft OLE DB Provider for ODBC Drivers Error Number: -2147467259 Description: The query is not...
How To IIS and SQL Server on Separate Machines with Trusted Connection
(176379) - Microsoft SQL Server 6.5 can be used with Active Server Pages (ASP) and Internet Information Server 3.0 (IIS). When SQL Server is configured for Mixed or Integrated Security, certain configuration changes must be made to enable ASP to connect to SQL...
INFO: ADO 2.0 Command Object ConnectionString Property Changes
(192227) - Active Server Pages (ASP) applications written with ActiveX Data Objects (ADO) that pass the ADO ConnectionString property using either HTTP POST or GET fail to connect.
How To Implement Array Arguments in Visual C++ COM Objects for Active Server Pages
(218454) - This article describes, by example, how to implement arrays to be passed as parameters from Active Server Pages (ASP) to a Visual C++ COM Object. It is important to keep in mind that array arguments for methods must be declared as variant data type...
HOWTO: Retrieve a Recordset from an Oracle Stored Procedure Using ADO on ASP
(229919) - This article demonstrates how to call an Oracle package to retrieve a recordset using ADO on Active Server Pages (ASP). This article assumes that: You are proficient with Visual Basic Scripting Edition (VBScript), ActiveX Data Objects (ADO), and...
How To Create ATL COM Wrapper for ATL COM Component to Be Used With ASP
(243667) - This article describes how to create an Active Template Library (ATL) Component Object Model (COM) wrapper component (client) for an existing ATL COM component that can be used with Active Server Pages (ASP). To automate the ATL component you can use...
How To Debug an MTS Visual Basic Component Running Under ASP
(244457) - This article describes how to debug a Visual Basic component registered with Microsoft Transaction Server (MTS) from within the Visual Basic IDE, when created and called from an Active Server Pages (ASP) page.
How To Execute Long Running Queries from Active Server Pages
(261211) - Running a stored procedure or a query that takes a long time to run from Active Server Pages (ASP) may cause the browser and/or ASP page to timeout out before the stored procedure finishes running. Microsoft recommends that you NOT run such procedures...
How To Format an Excel Workbook While Streaming MIME Content
(271572) - This article demonstrates how you can use Active Server Pages (ASP) to create a formatted workbook that can be streamed as MIME content to Microsoft Excel.
How To Repair IIS Mapping After You Remove and Reinstall IIS
(306005) - After you install the Microsoft .NET Framework Software Development Kit (SDK) or Visual Studio .NET, Microsoft Internet Information Service (IIS) mappings are created to associate the new file extensions and settings for ASP.NET. If you did not have...
PRB: Windows 95 Hangs When You Use ADO with Active Server Pages
(164479) - ActiveX Data Objects (ADO) cause Windows 95 to stop responding with Personal Web Server (PWS) under heavy loading conditions.
How To Dynamically Include Files in Active Server Pages
(192144) - Since Active Server Pages (ASP) pages are compiled and executed before being sent to the client (as static HTML), trying to use a variable in place of a file name in a Server Side Include (<!-- #include PathType = FileName -->) fails. To include a...
PRB: ASP/ADO Coding Error Produces ASP 0115 Error
(203573) - When you view an Active Server Pages (ASP) page that uses ADO to access a database, you may find that nothing is written to the page or you may receive the following error message: error 'ASP 0115' Unexpected error /webapp/pagename.asp A trappable...
PRB: Passing Parameters By Reference to a VC COM Object
(197957) - When passing a parameter to a COM Component's method in Active Server Pages (ASP) using VBScript, either the following error occurs: Microsoft VBScript runtime error '800a000d' Type mismatch Or the value stored in the variable passed to the method is...
How To Impersonate a User from Active Server Pages
(248187) - This article describes impersonation and the security context for Active Server Pages (ASP) pages. It provides sample code for a Microsoft Visual Basic ActiveX dynamic-link library (DLL) that can be instantiated from an ASP page to impersonate a user...
PRB: Cannot Access Network Resources in Application_OnEnd or Session_OnEnd Events
(277329) - When you try to access a network resource from the Application_OnEnd or Session_OnEnd event, the action may fail, and the event is terminated. In addition, you may receive an error in the Application Log of the Event Viewer or in the browser window...
How To Create a VBScript Class or JScript Object to Debug ASP Pages
(288965) - When you use server-side Visual Basic Scripting Edition (VBScript) or JScript, you can build a reusable object for debugging that can be easily included in Active Server Pages (ASP) pages during development. Why use this approach rather than the...
How To Return XML from an ASP Web Page
(301244) - Returning XML data from an Active Server Pages (ASP) Web page is a common programming requirement. The method that is adopted to implement this requirement varies depending on the version of Microsoft Internet Information Services (IIS) that is used...
How To Log Events from Active Server Pages
(301309) - This article demonstrates two methods of writing events to an Event Log from Active Server Pages (ASP). ASP does not provide a built-in mechanism to log events to Microsoft Windows Event Logs. One of the popular approaches is to build custom Component...
How To Create an Generic ASP Page to Test XSL Transformations
(301394) - When you develop XML-based, server-side Active Server Pages (ASP) applications, it is a common programming requirement to load Extensible Markup Language (XML) and Extensible Stylesheet Language Transformation (XSLT) documents into instances of the...
How To Debug Visual Basic COM Components That Are Used Within Active Server Pages
(299633) - This step-by-step procedure demonstrates how to debug (or step through) Microsoft Visual Basic (VB) Component Object Model (COM) components that are used within Active Server Pages (ASP) pages. Debugging VB COM Components That Are Used in ASP Pages On...
How To Use Session and Application Variables in an ASP Program
(300883) - This step-by-step procedure demonstrates how to set and retrieve information from both Session and Application objects in an Active Server Pages (ASP) application. Session and Application Variables Basics You can use the Application and Session...
How To Use the AdRotator Control in an ASP.NET Application with Visual Basic .NET
(305035) - This article demonstrates how to use the AdRotator control to display advertisements in an ASP.NET Web site and how to implement custom "click tracking" logic. Many e-commerce sites use banner advertisements to promote products and services on behalf...
How To Hand Code an ADO Data Connection in ASP
(299980) - This step-by-step procedure demonstrates how to hand code an ActiveX Data Objects (ADO) data connection in an Active Server Pages (ASP) page. For the purposes of this article, the sample to follow uses the Northwind sample database and establishes an...
How To Retrieve and Display Records from an Access Database by Using ASP.NET, ADO.NET, and Visual Basic .NET
(308278) - This step-by-step article describes how to programmatically retrieve data from a Microsoft Access database, and then present the data to the user. The goal of this article is not to provide every conceivable approach to the issue. It is intended to...
How To Call SQL Server Stored Procedures in ASP.NET by Using Visual Basic .NET
(306574) - This article demonstrates how to use ASP.NET and ADO.NET with Visual Basic .NET to create and to call a Microsoft SQL Server stored procedure with an input parameter and an output parameter. The code sample in this article first checks whether the...
How To Write Binary Files to the Browser Using ASP.NET and Visual Basic .NET
(307603) - This step-by-step article creates a sample page that demonstrates how to retrieve binary data from a file and then how to write the data out to the browser using ASP.NET and Visual Basic .NET. Although this demonstration uses an Adobe Acrobat (.pdf)...
