Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
Classic ASP Professional For advanced coder questions in ASP 3. NOT for ASP.NET 1.0, 1.1, or 2.0.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Classic ASP Professional section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
  #1 (permalink)  
Old March 18th, 2005, 12:32 PM
Authorized User
Join Date: May 2004
Location: , , .
Posts: 28
Thanks: 0
Thanked 1 Time in 1 Post
Default HTTP Request.

We have written a small asp page to accept an HTTP request, pass the request onto an Oracle database for processing and then return the results.

This works find when we call it using HTTP/1.0 but if we use HTTP/1.1 or above it doesn't work.

Here's the code.



var strSQL;
var strRequest;
var dbConnection, strConnect;
strConnect = Application("ecentre_ConnStr");
dbConnection = Server.CreateObject("ADODB.Connection");

var doc = new ActiveXObject("msxml2.DOMDocument.3.0");
doc.async = false;
doc.resolveExternals = false;
doc.validateOnParse = false;

// Load an XML file into the DOM instance.

strSQL = "SELECT '<TEST>"+ doc.xml +"</TEST>' as out_xml FROM dual";
rspers = Server.CreateObject("ADODB.Recordset");
rspers.Open(strSQL, dbConnection, adOpenStatic, adLockOptimistic);

if (!rspers.EOF) {
   var vout_xml = rspers("out_xml");


From what we can work out using anything other than HTTP/1.0 results in a NULL being passed into the Oracle script, so I assume its the doc.load(Request); line thats not doing what it should. As I say with HTTP/1.0 it's fine.

Were an Oracle shop so have little experince with ASP so any advice would be really appreciated.

Thanks in advance


Similar Threads
Thread Thread Starter Forum Replies Last Post
Http web request Nadeem ASP.NET 2.0 Professional 5 October 27th, 2008 07:28 AM
xml http request AaronT Ajax 0 May 29th, 2008 11:52 PM
HTTP request works sometimes deBassMan XML 0 June 1st, 2007 08:12 AM
how to send Http request via a trigger kissvineet .NET Web Services 0 October 28th, 2005 04:50 AM
how to send Http request via a trigger kissvineet .NET Web Services 0 October 28th, 2005 04:48 AM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.