ADOCE 3.1 and PPC 2003
So, now that I've posted a message saying it's not possible to use the two together, I found a newsgroup post that says otherwise.
I haven't tried this myself to see if it really works. I still think the Windows Mobile team recommends you don't do this -- you should still strongly consider migrating over to SQL-CE.
Sue
Comments
- Anonymous
September 01, 2004
I assume you mean ADOCE with the CEDB provider? From C++, ADOCE or OLE DB are necessary to use SQL Server CE. However, ADOCE is not recommended with C++ according to http://support.microsoft.com/?id=296395, basically making it obsolete since VBCE is also obsolete.
My experience with ADOCE from C++ was painful: you broke one of the fundamental rules of COM and changed the order of methods between ADOCE 3.0 and 3.1, even if the code asks for ADOCE 3.0's ProgID. Not cool.
Then there's the issue where ADOCE using CEDB silently rolls back your changes if you have a connection open when the device is suspended... - Anonymous
September 01, 2004
Actually I meant ADOCE + PPC 2003. I wasn't talking about anything specific to CEDB or C++. I don't think you can use ADOCE with the PPC 2003 SDK without pulling this trick.
I was referring to my older post http://blogs.msdn.com/sloh/archive/2004/05/27/143080.aspx.