Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
oliviers
Starting Member
7 Posts |
 Posted - 2006-02-21 : 09:07:54
|
| Hello,I'm querying SQL 2005 from VB6 and the MS ADO Data Control bound to a data grid in server side mode. ADO 2.8 is used.The app just runs fine except when the query is a group by.While the data control seems to work ok (I get columns names, a movefirst and one read returns something), there is no data binding when the query is a group by. The grid is thus empty.I started a trace on the SQL side, here is the result:No group by :* sp_cursoropen with the SQL statment* sp_executecursorfetch* sp_executecursorfetch* sp_executecursorfetch* ...With group by :* sp_cursoropen with the SQL statment* SET NO_BROWSETABLE ON* SET FMTONLY ON SQL Statment* SET NO_BROWSETABLE OFF* execution of the SQL Statment (SQL:BatchStartingClass event)I don't see any fetching in the second query execution.Any help on this issue would be greatly appreciated.Olivier |
|
|
|
|
|
ADO Server Side Cursor Issue