Re: ms sql ce

From: AJK (AJK_at_discussions.microsoft.com)
Date: 08/30/04 

Date: Mon, 30 Aug 2004 06:05:01 -0700

Hi Anamika,

Since I'm also having a logical issue towards creataing of database on
PocketPC 2003 (Emulator).

I need to have copy of Database from SQL 2k server to on PocketPC 2003
(Emulator). The logic which I have is, create the database on Page Load Event
and PULL (RDA) pull the tables from SQL 2k Server database. For each run I
have to do the same. Is it possible to create Database on Pocket PC 2003(
Emulator) permanantly.

Also I have problem while excuting RDA Pull command. Getting following error
message:

Error: 80072EFD
Message: A request to send data to the Computer running IIS has failed.

Have checked the solution in BOL whcih describe as shown below:
-----------------------------------------------------------------------------
The user's device must have network connectivity. For example, the device
might not have a working modem, network card, or universal serial bus (USB)
connection.

I have also checked IIS configuratin using IE. It's working fine and I got
the message "SQL Server CE Server Agent". upon typing of
"http://localhost/nwind/sscesa20.dll). Means config. done is fine !.

But. my SQL 2k Server is NOT running on my developement machine. I have
installed following on my developement machine and managed to run application:

VS.NET 2003
SQL Ce 2.0
Pocket PC SDK etc..
ActiveSync 3.6

Appreciate if you could help me out. Many thanks in advance..

Regards

"anamika" wrote:

> Hello John,
>
> There is currently no direct Win32 mechanism that you can use to
> create a SQL Server CE database on the desktop computer. However, you
> can create the database in the desktop emulation environment or on a
> Microsoft Windows CE device, copy the database to a Win32-based
> computer, and then copy the database to other Windows CE devices as
> necessary.
>
> And if you want to migrate SQL Server adtabase to SQL Server CE then
> You can use the RDA Pull method with the no-tracking option to pull
> all tables to your SQL Server CE database, together with the data. For
> more information, see the Introducing Remote Data Access and
> Implementing RDA topics in SQL Server CE Books Online.
>
> Both RDA and replication can copy tables from SQL Server to the SQL
> Server CE database on the device. This is the "easiest" method to use
> because this method automatically performs data type mappings for you.
> Replication only works with Microsoft SQL Server 2000. If your
> requirement is simple, you may go for using RDA.
>
>
> Anamika
>
> "John H" <john.hutchinson@lycos.com> wrote in message news:<#QdFHzhWEHA.4000@TK2MSFTNGP10.phx.gbl>...
> > Is it possible to create an sdf file on the desktop. I currently have my
> > data in mysql and would like to run an application that could take said data
> > and put it in the sdf for use on the pocketpc
>

Relevant Pages

  • RE: Backups have Shadow Copy Problems
    ... and restarted the server. ... suggested and changed the recovery model to simple on the one database called ... I understand the issue to be: the backup task failed ... You back up data from a volume that contains a Microsoft SQL Server ...
    (microsoft.public.windows.server.sbs)
  • Re: upsizing to sql 2005
    ... the word SERVER in it, ... You can access to the database by multiple means (Access, ... and how does it update the SQL database with the new records in Access? ... Query Name: Arcadia - ARC ...
    (microsoft.public.access.queries)
  • Re: Linked Tables in Access
    ... any use of SQL Passthru, Linked Tables or any other use of MDB / MDE ... server, or would I also need to convert *those* queries to passthrough ... I've been trying to understand why Access database files become corrupt. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Leveling by ID vs. "Standard"
    ... of this trade called Project Management. ... a database for the "Project Tables," ... to write reports on data from the server database. ... product supporting queries created with SQL. ...
    (microsoft.public.project)
  • Re: Trouble Getting VS.Net 2003 WalkThroughs MSDE Connection
    ... Config Tool of SQL Server? ... > link to download the PUBs database. ... >>> Setup and they directed me to install MSDE and they attached a ...
    (microsoft.public.sqlserver.msde)
Quantcast