 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
SQL Server Forum / DB Engine / SQL Server CE / January 2008Struggling with Mobile Development
Hi, I am to begin developing CE database applications that are going to need direct connectivity to a full SQL Sever database or at least *seem* like they are directly connected. I am thinking that SQLServer/ CE is the logical way to proceed, but how do I get the data from the .sdf file into the SQL Sever? I've seen some stuff about using replication, but that seems pretty difficult and I don't know where to find sample code for this. I have been able to connect the application's controls to an SDF file, but how do I get the data from the SDF into the actual server?? Thanks, John John, You can get the definitive book on replication here: http://blogs.msdn.com/robtiffany/ You can also find a nice sample here: http://www.microsoft.com/downloads/details.aspx?FamilyId=80A5C2C5-4F9B-4C1A-BFF6 -2A3C6B68D15B&displaylang=en Also keep an eye on this space for more sync options: http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=1225&SiteID=1 (Sync with mobile devices is not currently supported by Sync Services, but it is under development.) And finally, you can write your own desktop application that can connect to SQL Server and build a SQL Compact database for use on a mobile device using the SqlClient and SqlServerCe namespaces for managed development or OleDb for unmanaged.  SignatureGinny Caughey Device Application Development MVP > Hi, > [quoted text clipped - 11 lines] > > John > And finally, you can write your own desktop application that can connect to > SQL Server and build a SQL Compact database for use on a mobile device using > the SqlClient and SqlServerCe namespaces for managed development or OleDb > for unmanaged. > -- > Ginny Caughey Hi Ginny, thanks for the reply. I am checking out the things you've mentioned, but the SqlClient and SqlServerCe namespace option may be a better choice than replication. Basically, it sounds like I would be creating a "conduit" application that could transfer data to and from the sdf file using an ActiveX control? But I'm having trouble finding any kind of meaningful documentation or example code on how to create an application that can make use of the namespaces. I come from a Win32/Delphi/MSSQL development background, so I'm having a tough time with these new concepts. If you know of a good place to start on that, using VB, I would appreciate it. Thanks, John John, Most people write that conduit app as a normal desktop app using either C# or VB that recreates a SQL Compact sdf file you can transfer to the device. You can use the Remote API (Rapi) to transfer files to/from the device from a desktop app under programmatic control. There is a managed code wrapper for Rapi at http://www.opennetcf.com/FreeSoftware/DesktopCommunication/tabid/90/Default.aspx. Alternatively, you can also connect directly to SQL Server from the device when it is cradled using SqlClient on the device. Probably the most complete and up-to-date guide to Windows Mobile development using maanged code is Microsoft Mobile Development Handbook by Andy Wigley, Daniel Moth and Peter Foot. Highly recommended. SignatureGinny Caughey Device Application Development MVP >> And finally, you can write your own desktop application that can connect >> to [quoted text clipped - 25 lines] > > John > Alternatively, you can also connect directly to SQL Server from the device > when it is cradled using SqlClient on the device. Thanks Ginny. I think this is a strong possibility. The devices won't be cradled, but they are wireless, which, I am hoping, can be the same as being cradled. I'm going to get the book you suggested and I appreciate all the help. John John, Wireless should also work. SignatureGinny Caughey Device Application Development MVP >> Alternatively, you can also connect directly to SQL Server from the >> device [quoted text clipped - 7 lines] > > John On Jan 15, 11:05 am, "Ginny Caughey [MVP]" <ginny.caughey.onl...@wasteworks.com> wrote: > John, > > Wireless should also work. Ginny, Great-- I'm making some serious progress on it now. I've got the client getting data from the SQL Server on a PPC emulator that is "docked", so you've been very helpful in this... Thanks again, John On Jan 16, 6:16 am, ibidibi...@hotmail.com wrote: > On Jan 15, 11:05 am, "Ginny Caughey [MVP]" > [quoted text clipped - 10 lines] > > John Hey John, shoot me an email (bend at practical dot com dot au) if you find you need working example code for getting delphi to talk (i.e. transfer files, edit ppc registry, etc) to a mobile device using the RAPI library (though I believe this will only work when it's in the cradle). Although there is a pascal unit floating around the net which exposes the RAPI api, the api is not OO friendly and I found it difficult to use. I finally got some working code when I found a set of C# wrappers for RAPI and tried translating that code to delphi. |
Reply to this Message |
 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.