RE: access to SQL Server 2.0 CE from .NET Framework

From: Eric Feng (efeng_at_online.microsoft.com)
Date: 03/22/04


Date: Mon, 22 Mar 2004 18:15:06 GMT

You can use the remote application programming interface (RAPI) to accomplish this functionality of accessing a SQL Server CE database from your
desktop. RAPI allows desktop apps to invoke function calls on your Windows CE device while the device is connected via ActiveSync to the desktop.
Therefore, you could write a device resident app which performed SQLCE functionality and call this app from your desktop.

For more information, refer to http://msdn.microsoft.com/library/en-us/wceactsy/html/cerefRAPIReference.asp.

Thanks,

Eric Feng
This posting is provided "AS IS" with no warranties, and confers no rights.
--------------------
| Thread-Topic: access to SQL Server 2.0 CE from .NET Framework
| thread-index: AcQQCY1vJL3P4pEbQ1S80SDMonID8w==
| X-Tomcat-NG: microsoft.public.sqlserver.ce
| From: "=?Utf-8?B?YW5haXM=?=" <anonymous@discussions.microsoft.com>
| Subject: access to SQL Server 2.0 CE from .NET Framework
| Date: Mon, 22 Mar 2004 04:31:08 -0800
| Lines: 16
| Message-ID: <1BC9A764-47E3-415D-8EB0-FA5B9389DF15@microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 8bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.sqlserver.ce
| Path: cpmsftngxa06.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.sqlserver.ce:11698
| NNTP-Posting-Host: tk2msftcmty1.phx.gbl 10.40.1.180
| X-Tomcat-NG: microsoft.public.sqlserver.ce
|
| Hello,

I am trying to accede to a BD SQL Server 2.0 CE of a PDA from a .NET (C#) application that is executed on a PC, on .NET Framework not with .NET
Compact Framework, without any success.

The procedure wants to bring the .sdf file of the PDA to the PC and also wants to have an application on the PC on .NET able to read what it is wrote on the
bb.dd of the PDA.

My problem is that System.Data.SqlServerCe is valid only if it is executed on .NET Compact Framework, I’m trying to do that with OleDB but I don’t
have any success.

Have someone been able to accede the bb.dd of a PDA device from an application executed on a PC while the PDA is connected to the PC with
ActiveSync?

 

Many thanks in advance

/Anna



Relevant Pages

  • RE: Accessing a Sql Server CE db from server?
    ... RAPI allows desktop apps to invoke function calls on your Windows CE device. ... | X-Newsreader: Microsoft Outlook Express 6.00.2800.1158 ... | Can I access a SQL Server CE db outside of the device over wireless? ... | Eg I have a web app which needs to push and pull data from the device (spec ...
    (microsoft.public.sqlserver.ce)
  • Re: N-Tier Design Question?
    ... but sharing the same class definition. ... > I understand exactly what you are saying, but when I spoke of Business ... >> organizes and maintains all functionality for a single user of your app. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Loading VB files?
    ... How 'bout finding something that'll get VB6 source from an app it ... does it take to start the first dotNet app of the day?... ... functionality", mmmkay? ... tells me these "knowledge or skills" are about 15 years behind... ...
    (microsoft.public.vb.general.discussion)
  • Re: Performance issue after coverting from Framework 1.1 to 2.0
    ... I think that I encountered the same problem: A large program with Framework ... the SQL Server for the dev database. ... when you deploy the app on a different machine where the SQL Server is no ... app was fine on the dev machine. ...
    (microsoft.public.dotnet.framework.performance)
  • Re: C5 woes. How stable is VFP really?
    ... After that I close the SQL server cursor and work with my manual cursor instead. ... a VFP9 app on a really old machine ... app was under more "pressure", VFP showed ...
    (microsoft.public.fox.programmer.exchange)