Re: Accessing SQL CE 2.0 file located in the desktop PC

A TabletPC *is* a desktop. SqlCE 2.0 requres Windows CE.

--
Ginny Caughey
Device Application Development MVP


"AS" <SubhashiniAnnamalai@xxxxxxxxx> wrote in message
news:1156236754.734056.266270@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Thanks Ginny. I have one more doubt -

How do I connect my device ( a tablet PC) to my desktop? It doesn't
have a network interface card. It only has an USB port.

Also, how do I configure the third party tools to identify my device?

Ginny Caughey [MVP] wrote:

SqlCE 2.0 only runs on devices or emulators, unlike SQL Mobile which can
also run on desktops. So you need to copy the file to a device, then one
of
the 3rd party tools should be able to work with it.

--
Ginny Caughey
Device Application Development MVP


"AS" <SubhashiniAnnamalai@xxxxxxxxx> wrote in message
news:1156150892.461873.26060@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hi,

I have a SQL CE 2.0 database file (*.SDF) in my desktop. I need to
access this file and migrate the data to SQL Express 2005. How do i
accomplish this?

I tried using the "DataPortWizard" of primeworks, but i get an error
saying - "Failed to open the device database".

I also tried accessing this database through a VS 2005 desktop
application, by adding a reference to SqlServerCe from - "C:\Program
Files\Microsoft SQL
Server\90\Tools\Binn\VSShell\Common7\IDE\System.Data.SqlServerCe.dll".
With this application i get the following error while opening
connection to the database - "Invalid database version".




.

Relevant Pages

  • Re: Creating 3.5 databases ?
    ... Ginny Caughey ... Device Application Development MVP ... You can create the database using the Server ... TableAdapter and I can reference it in code. ...
    (microsoft.public.sqlserver.ce)
  • Re: Creating 3.5 databases ?
    ... Ginny Caughey ... Device Application Development MVP ... Can you open a database with tables created using the VS designer in SSMS for example and vice versa? ... "Mike Barrett" wrote in ...
    (microsoft.public.sqlserver.ce)
  • Re: Column Padding
    ... I don't know why adding a column should cause your select statement to begin failing unless the database has become corrupted. ... Ginny Caughey ... Device Application Development MVP ... Then if I copy the sdf to my desktop and then run the exact same query using management studio, ...
    (microsoft.public.sqlserver.ce)
  • Re: Accessing SQL CE 2.0 file located in the desktop PC
    ... Ginny Caughey wrote: ... Device Application Development MVP ... How do I connect my device (a tablet PC) to my desktop? ... I have a SQL CE 2.0 database file in my desktop. ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: custom insert for databound datagridview
    ... "Ginny Caughey MVP" wrote: ... gets put into the database until you hit the save button on the navigation ... Since you're talking about DataGridView, I assume you want to track the ...
    (microsoft.public.sqlserver.ce)