MS SQL Reponse

I have a table in MS SQL 2000 database which has almost 400,000 records. I tried to retrive data using by ADO 2.7 in my Visual Basic 6.0 program. The problem is MS SQL server dosen’t send data back, so qurey result is EOF() = True. However when I check data with SQL Qurey Analyzer with same SQL Text, It return data. How can I get rid of this problem.