Bug #48280 calling an asp page containing mysql connection with xmlhttp
Submitted: 24 Oct 2009 13:06 Modified: 24 Oct 2009 15:13
Reporter: alon s Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server Severity:S2 (Serious)
Version:5.1.39-community OS:Windows (vista)
Assigned to: CPU Architecture:Any
Tags: xmlhttp

[24 Oct 2009 13:06] alon s
Description:
calling an asp file that opens a connection to mysql using server side xmlhttp in asp fails.

my connector is ODBC 5.1.5

How to repeat:
1. I have an asp page that opens a mysql connection:

file: 2.asp
------------
ConnString_DB_Read = "Driver={MySQL ODBC 5.1 Driver}; server=localhost;Port=3306;Database=myDB;User=root; Password=myPWD;Option=3;"

Set cn1 = CreateObject ("ADODB.Connection")
cn1.Open ConnString_DB_Read

2. when i run the file is works fine.

3. when i call this file from another asp file using server side XMLHTTP request, i get a timeout from the xmlhttp object:

file: 1.asp
------------
Set xmlRequest_obj = Server.CreateObject("MSXML2.ServerXMLHTTP.6.0")xmlRequest_obj.open "GET", "http://127.0.0.1/2.asp", False
xmlRequest_obj.send

result: 
--------
msxml6.dll error '80072ee2' 

The operation timed out 
(on the .send line)

i have tryed the same case on a windows server 2008 with a real domain name and no firewall, and i get the same deal...
[24 Oct 2009 14:44] alon s
This only happens when trying to call the 2.asp file from the same domain i'm running the 1.asp file from.

if i try to call it on a different domain, the mysql connection works fine and i get that page's response back to 1.asp sucessfully
[24 Oct 2009 15:13] alon s
seems to be an issue with server side xmlhttp
[26 Oct 2009 8:27] Tonci Grgin
Thanks for sharing this with us Alon.