Hi Friends,



I have a asp page with two drop down boxes. User has to select from first 

drop down box a state. On selection of state I call a javascript to pass 

querystring of statecode and call the same page with statecode. Now second 

drop down box will display cities in that state code selected. 



When the page is reloaded i am geeting error code 80004005 with additional 

information of.



Microsoft OLE DB Provider for SQL Server error '80004005' 



Connection is busy with results for another command 



/webreport/frmabxd.asp, line 113 



this line 113 has code for set rs_rpt = objSqlCmd1.Execute 

where i am passing values to the command object to retrive cities.



Please help.



Thanks,

Mahesh

Hi,



Maybe the javascript is passing something extra on the querystring which 

is affecting the db, Sometimes i have problems with js interferring, I set



Response.Buffer = True



at the top of the page, and that sometimes does the trick



Regards,



Spoon





> Hi Friends,

> 

> I have a asp page with two drop down boxes. User has to select from 

first 

> drop down box a state. On selection of state I call a javascript to pass 

> querystring of statecode and call the same page with statecode. Now 

second 

> drop down box will display cities in that state code selected. 

> 

> When the page is reloaded i am geeting error code 80004005 with 

additional 

> information of.

> 

> Microsoft OLE DB Provider for SQL Server error '80004005' 

> 

> Connection is busy with results for another command 

> 

> /webreport/frmabxd.asp, line 113 

> 

> this line 113 has code for set rs_rpt = objSqlCmd1.Execute 

> where i am passing values to the command object to retrive cities.

> 

> Please help.

> 

> Thanks,

> Mahesh