Problem with retrieving data using COM components from SQL

[sheshankt]

I am retrieving data from a table which has huge data, around 10,00000 records.I dont have any indexes and i am retrieving based on around 70 fields. I am doing through a COM component and i am using MTS. since the data is huge and processing time is lot, i am getting error saying "omponent-request-denied" and giving an option like SWITCH or RETRY. Can some one help me how to handle this situation.

Thanks

Sheshank

 

[vishnuprasad]

I think this has nothing to do with data, its settings in MTS which is causing the probs.Check u'r Component security. Disable the checkbox for Enable authorization and try it again.