This behaviour is not specific to ADODC. ADODB do the same thing.
I do not know your recordset properties.(maybe you can post it) but I sugest you to change the properties to adUseClient and adOpenStatic (these are for adodb, I hope that are the same in adodc)
Originally posted by chrisp_999
I'm using ADOCE in connection with Odyssey ViaDB to connect to MSSQL Server from PocketPC2002. I have the odd problem that recordset.recordcount returns -1 no matter how many records there are.
I get the correct results when I do a SELECT COUNT(*) on the same data and the recordset *is* actually populated.
Thanks for that information.
CursorType is adOpenStatic, LockType = adLockReadOnly. The adoce recordset object does not support CursorLocation, while the connection object does, but only adUseServer and adUseNone. I will play around with that later on.
Didn't try it, but i guess it should be doable. Set the "ViaDB Remote Provider" property to the name of the system DSN for MySQL on the ViaDB Host. If you need more specific information, drop me a private message and/or open a new thread. I'm willing to dig into this and could do a little testing over the weekend.
I'm not sure if this can be done. Only way I can think of is via SQL Server CE Edition, but I'd expect much hazzle with that. That's the reason why we decided to use ViaDB. SQL Server CE synchronisation tools require an IIS on the db server, that was a k.o. criterion for us.