Software

Ask something
Discussion Locked

MS SQL Reponse

0 helpful
2 replies

by berkimdgkr

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
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.

2 replies

by bcunnien

It seems like the ADO is not getting populated. Could you share both the code and the query that you are using? If I saw them, perhaps I could give you a more definitive answer.

Bill

This discussion is closed to new replies.