April 19, 2011

Sql Azure – Error XML HTTP Request does not exist . Parameter Name: typeName

I am trying to connect to SqlAzure database from my windows azure account, when I try to authorize by giving valid database credentials I get the error as XMLHTTP Request does not exist. 

I know that Azure is stateless. But the  connections are maintained with state.Especially when we are trying to use asynchronous  calls using the XMLHTTP request object it doesn't recognize .Hence we should not use  XMLHttpRequest while working with Azure. But in this case I am not using any ajax calls or xmlhttprequests.

azure-error

I thought might be internally azure is using xmlhttprequest. I  also checked the IP addresses of my SQL Azure firewall  to allow proxy IP.  It is  not dynamic,  it’s not changed. If this is the case error will be different message. I also have all latest XML components installed in the box.

Can you guess what is the cause and problem?

The problem is its not getting connected in IE7 or FF3.6.

This  silverlight application interface uses XMLHTTP requests from the client side,  all the operations are made through a service on Azure using port 80, not directly to the SQL Azure server.since the Silverlight application uses local XMLHTTP requests components on your machine, we need to make sure that client machine using azure account has the latest XML components. Upgrading my browser to IE8 solved the issue, I think this updated latest updates and necessary components for XMLHttpRequest for Silverlight4. At least we need to have IE8/ IE9 to work.  The cause is Silverlight 4.0 some problems with XMLHttpRequest in Firefox 3.6.

Sql Azure Tips

We should have sqlserver2008R2 to work with SqlAzure

SQL Azure is only compatible with SQL Server 2008 and SQL Server 2008 R2. If we are planning to migrate database to SQL Azure we should first upgrade it to run on SQL Server 2008 or SQL Server 2008 R2.   We can take help of  SQL Server 2008 Upgrade Advisor for compatibility  test before  migrating to SQL Azure.

The SQL Azure Migration Wizard is a very good tool for testing the compatibility between SQL Server 2008 and SQL Azure. This tooll can analyze SQL Profiler traces to check the compatibility of the T-SQL statements generated by the application.

3 comments:

Chakravarthy said...

This is all about "MSXML 3.0 SP11" add-on from Microsoft. Try to run this ActiveX component and allow the add-on on your Firefox. Hope this would resolve the error.

Chakravarthy said...

This is all about "MSXML 3.0 SP11" add-on from Microsoft. Try to run this ActiveX component and allow the add-on on your Firefox. Hope this would resolve the error.

Please remove the word verification for comments moderation.

banthi said...

Could please write a post on LINQ.

There was an error in this gadget