I am trying to figure out the possible options we have for accessing SQL Server CE from an existing C++ program that is being ported to WinCE. As far as I can tell, these are the most standard approaches:
1) Use eVC++ 3.0 with OLEDBCE. (Use one of ADS's CE 3.0 images.) This approach gets us stuck with old stuff.
2) Use Visual Studio .NET with ADO .NET. (Use a CE .NET image.) This way we can use the most current images but we have to deal with .NET.
Both those approaches have problems. However, I have heard murmurings that it is somehow possible to use eVC++ 4.0 with OLEDBCE. This might be the best choice for us, if it were possible. But apparently the OLEDBCE libraries (along with ADOCE) were never updated past version 3.1, and I can't see how one would use them with a version 4.x SDK.
So my question is, do ADS's CE .NET images somehow offer a means of using OLEDBCE to access SQLServerCE? If so, how the heck do you do it? Otherwise I think we are stuck having to port large chunks of our code to ADO .NET.
It says "To resolve this problem, contact Microsoft Product Support Services to obtain the fix" but many developers are successfully using the files from the Pocket PC 2002 SDK.