Monday, March 12, 2012

Good starting point?

What's a good starting point to learning the native c++ OLEDB structure for accessing SQL Server Compact databases? I see several links into the msdn library, but the library seems to hold a ton of links with little to no actual content. I just need to learn how to do the basics...open a database and run simple queries (select, insert, and update). The examples look incredibly convoluted and don't seem to make sense.

I will be developing for a console program in windows ce 5 on VS2005 if that helps, so I don't need all the windows gui code.

Thanks!
Here are a couple of links for you to explore:
http://www.codeproject.com/ce/#Database
Pocket PC Developer Network|||I'd really like to use your atl consumer templates, but I can't get your tutorial to work with VS2005. It seems a lot changed from the eVC++ version of atldbcli.h. In particular I get these errors when using your modified include:

d:\documents and settings\jhshaddix\my documents\visual studio 2005\projects\sqlport\sqlport\atldbcli_ce.h(409) : error C2065: 'atlTraceDBClient' : undeclared identifier
d:\documents and settings\jhshaddix\my documents\visual studio 2005\projects\sqlport\sqlport\atldbcli_ce.h(1738) : error C2504: 'CVirtualBuffer' : base class undefined
d:\documents and settings\jhshaddix\my documents\visual studio 2005\projects\sqlport\sqlport\atldbcli_ce.h(1795) : see reference to class template instantiation 'ATL::CArrayRowset<T,TRowset>' being compiled
d:\documents and settings\jhshaddix\my documents\visual studio 2005\projects\sqlport\sqlport\atldbcli_ce.h(1738) : error C2143: syntax error : missing ',' before '<'

Do you per chance have a working demo or article that uses VS2005? I'd very much appreciate the assistance just to get ATL working!
|||I am using the atldbcli_ce.h file om VS2005 and WM5 SDK without any problems. Interestingly, Microsoft did not publish the atldbcli.h file on this SDK so... Anyway, I'm planning to write a C++ wrapper for OLE DB so it can be used on any device and does not depend on the consumer templates.|||Hmm...well that gives me some hope! Maybe my problem is due to how the project wizard is making the stdafx.h file. I'm selecting a smart device win32 project with the STANDARDSDK_500 x86 device with a console application and the atl includes. Does that sound right, or does the project need to be set up differently for atldbcli_ce.h?

No comments:

Post a Comment