sql server 2000 vs ado dynamic cursor gives recordcount -1

[TerraSamba]

Hi all,

I want to implement a real time data solution with SQL Server 2000 and ADO 2.7

But where I find myself untill now is stuck on a tricky part: They say the only cursortype that can detect new records serverside is the dynamic cursor. But when I ask for the recordset, the recordcount returned is -1.

I know you can work around this by using an other cursor type. Then I might as well work clientside all together, but then I find myself working with timer object that requery all the time to see if anything is changed. And with 50+ tables ....mmm I don't know

Does anyone have a bright idea for real time data?

Thanx a lot,

Erik

 

[TerraSamba]

Data Access Forum; oops I guess I am someshat of topic now... the Access part is probably "MS Access"; I'll repost somewhere else, sorry

 

[jjlogan]

Have you done a Search in the MS Knowledge Base using "dynamic cursor"? I did and found numerous references to Bugs, fixes, and Information Articles on SQL Server. Might help.
Secondly, and just a thought since I haven't worked with these cursors - but could a result of "-1" mean "No Change"?
Jeff