| fatkenny@gmail.com 2006-10-24, 6:40 pm |
| Hello everyone, I have a question pertaining to using ODBC (and the SQL
Native Client Driver) with Microsoft SQL Server 2000.
I have seen in other programs and APIs the ability to start a query and
then while the query is running access the results as they appear
(without waiting for the query to finish.) For instance SQL Management
Studio and Query Analyser both do this.
I have seen ways of doing this using OLEDB but I was hoping to find a
quick/easy solution to do this using ODBC (or extensions thereof.) We
are using the SQL Native Client Driver specifically, so if there are
solutions which require using that specifically I am fine with that.
I looked at ODBCs asynchronous capabilities, but they seem to operate
only in a per call mode (eg you can make a call to ExecuteSql
asynchronous, but I can't figure out how to FetchSql the data from that
call before it finishes.)
Anyone have any ideas on this?
ken
|