Question about SqlServerCe

[Jose Luis Bravo]

Hi all,

I'm using VS 2003 to develop an application for a handheld device running
Windows CE NET 4.2;
some days ago, we thought that it would be a good idea to use the *.exe
generated by VS2003
together with the .NET Framework Redistributable to check the application on
the PC.
The point of the idea is that it would allow us to send the EXE to our
customers
(having the .NET Framework Redistributable installed)
so they could test the application on the PC and give us fast feedback (we
are in the middle
of the development process)

All was fine until we started to use SqlServerCe to use a database on the
device
(by now, the database work in an independent way; it doesn't need
communication with
any central database). Now, when i try to launch the EXE in my PC, i obtain
a error
message like this:

The given assembly name or codebase, 'System.Data.SqlServerCe', was invalid.

If i'm not misunderstanding it, the problem is that the .NET Framework
doesn't contain
that assembly. Now my question is... Can i do something to make this work
on the PC?
(like downloading such a assembly from some place) Or it is impossible at
all to
run an application using SqlServerCe on the PC?

Thanks in advance.


Jose Luis Bravo

 

[Paul [Paradise Solutions]]

As best as I know, SQLCE cannot be run on the desktop, and there is no
method to interface with the SDF files that it uses (despite numerous
requests by numerous people to MS to have a desktop engine..).


Paul

 

[Shaun Wilde]

Can we ask again? - my life would be so much easier if we had this

heck if MS just published the structure on this newsgroup we'd have one by
the end of the week

 

[Ginny Caughey [MVP]]

Shaun,

There will be a lot of improvements to SqlServerCE for version 3.0, due out
in 2004, and creating databases on the desktop so they can be copied to a
number of devices is one of them. Be sure to check out Kevin Collins's
message about SqlServerCe 3.0 on this newsgroup:
http://groups.google.com/[email protected]&rnum=1

 

[Shaun Wilde]

Thanks

looks good - lets hope my client has more funding by then