Hi, I need a help. From QC using ODBC connectivity we can access the QC database and generate the report in excel using query. I did this very long time before. But I dont remember now. Any one can help me in this...
Query that will give all results of Defects, Test Run status
Excel will get refreshed every few minutes and shows the results.

I need connection details(plugin details), how to connect QC database, the query?