Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum / DB Engine / SQL Server CE / October 2007

Tip: Looking for answers? Try searching our database.

Classes for SQLServer Native OleDB in CE?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
davepkz@hotmail.com - 16 Oct 2007 00:02 GMT
Are there any 3rd party class libraries that wrap the Native OleDB
calls (like those in the NorthwindOleDb sample) for SqlServer into
Connection and Recordset classes?

We have a lot of existing C++ code using the standard high level
Connection/Recordset interface, and would rather not rewrite it all
for CE.  I am hoping it would be easier to use a 3rd party's wrappers
than write them from scratch.

Thanks
Dave
drs - 16 Oct 2007 17:33 GMT
On Oct 15, 4:02 pm, dave...@hotmail.com wrote:
> Are there any 3rd party class libraries that wrap the Native OleDB
> calls (like those in the NorthwindOleDb sample) for SqlServer into
[quoted text clipped - 7 lines]
> Thanks
> Dave

Jo?o Paulo Figueira has posted a variety of articles in the past on
codeproject for this topic - this would be the closest to a wrapper
library - you'll have to fill in the blanks where he left off in his
samples.

Here's one of his articles:
http://www.codeproject.com/ce/atl_ole_db_ppc.asp

As an aside, I have been using a modified version of the adoce wrapper
found in the following article without any problems on 2003/wm5/wm6
(even though everyone will tell you adoce with c++ is unsupported)
http://www.codeproject.com/ce/ado_ce_ca.asp
João Paulo Figueira - 17 Oct 2007 21:56 GMT
Now here is something I'm looking at right now. As "drs" correctly posted, I
wrote a few articles on CodeProject and a few more on PocketPCDN about this
but always using a modified version of the atloledblci.h file taken from the
Pocket PC 2002 or 2003 SDK. The most recent SDKs do not carry such a file
and this seems to be a clear signal that Microsoft does not want us to use
it, so something different and better than using straight OLE DB interfaces
should be made available. I am finishing an article on the MFC
implementation of a list-based form control for Pocket PC devices and then I
will start looking into this and hopefully will turn this into a series of
articles.

If you want to keep posted about the progress, please bookmark my blog at
http://nativemobile.blogspot.com

Cheers,
João Paulo Figueira
DAD MVP

> Are there any 3rd party class libraries that wrap the Native OleDB
> calls (like those in the NorthwindOleDb sample) for SqlServer into
[quoted text clipped - 7 lines]
> Thanks
> Dave
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.