Create and populate sqlserverce database on webserver

[Guest]

Is it possible to create a sqlserver ce database on the web server so that it
can be transferred via activesync or web service to the pocket pc device? I
need to create a CE Database (VERY LARGE) with static data on the web server
and somehow transfer this database for read only queries to the pocket pc for
my disconnected state. I have an oracle back end so I can't use SQL Server
2000 with all its built in replication stuff (bummer) and passing datasets
via web services is too inefficient.
I attempted to include the system.data.sqlserverce.dll as a reference to my
web service project and create and populate the database, but I get a stack
trace dump when I run the web service that says... "The given assembly name
or codebase, 'System.Data.SqlServerCe', was invalid." while it appears to be
trying to parse the machine.config file. Anyone have any ideas how to create
an SQLServerCE database on the server? Can Compact Framework DLL's be used
on the Web server? Thanks in advance.

 

[Alex Feinman [MVP]]

While you cannot create a database on the desktop, there are tools that
allow creating databases *from* the desktop over ActiveSync. Take a look at
http://www.primeworks.pt/site/en/home_fs.htm and
http://www.gui-innovations.com/html/remotesqlce.html