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
• Status: Not a Bug
• Category: MySQL Server
• Severity: S2 (Serious)
• Version: 5.1.39-community
• OS: Windows (vista)
• 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.