Microsoft Enterprise Data Access Application Blocks locks up IE

[wey97]

I'm using the DAAB and only make a simple call:

Dim db As Database = DatabaseFactory.CreateDatabase()
 
Dim cmdWrapper As DBCommandWrapper = db.GetStoredProcCommandWrapper("GetCategories")
 
dg.DataSource = db.ExecuteDataSet(cmdWrapper)
dg.DataBind()

I see the data fine and close the page. Then I open Internet Explorer and it locks at "Detecting Proxy Settings...". I have to end task on the aspnet_wp.exe process and it's fine.

Has anyone encountered this and how did you fix it?

[mendhak]

Tools > Internet Options > Connections > Lan Settings ... > Bypass proxy for local addresses....

[wey97]

Well my IE itself is not the problem.

It works fine until I run the web app and my aspnet_wp.exe process seems to be waiting. I check the SQL Server locks and there is a sleeping process executed from .Net SqlClient Data Provider.

I end task on aspnet_wp.exe and the database lock goes away and I can open up a new IE window and use it now.