talking to SQLCE from desktop

  • Thread starter Thread starter msnews
  • Start date Start date
M

msnews

Is there a OleDb provider to talk directly to SQLCE from my desktop app ?

I'm querying an ODBC datasource for customers and want to just write that
directly to the SQLCE database

Client doesnt have SQL server on the desktop so i cant use replication

Thanks
 
I need this features too! I know that, at this time, it
doesn't exist but I hope it'll be implemented in near
future!!!
I've read many people that ask for it...

:)
 
I need this features too! I know that, at this time, it
doesn't exist but I hope it'll be implemented in near
future!!!
I've read many people that ask for it...

:)
 
Hi,

Not sure whether u can write to SQL CE directly from desktop.Maybe u can put
the contents to a .csv or .xml file, copy it to device using RAPI and invoke
an application which reads the file and updates ur device database.

Hope this helps..

Girish.
 
I believe that the best answer is 'no'. You could write a sockets-based
application on the PPC which would provide some sort of capability for the
desktop machine to send messages and receive data. Why would you want the
little PPC device to act as an SQL Server rather than your desktop machine
with 5000 times the storage and 100 times the processor capability?

Paul T.
 
In our case time, money and convienience.

To make the assumption that a customer has, or is willing to buy SQL
Server is a big one.
Yes, there is the option of the MSDE, but if the datasets are small,
then it's probably not worth the agro of keeping the thing patched.
Then there's access, but I've not experimented with that (and not an
~absolute~ guarentee that they have that either).

SQLCE at least means the PDA is invependent - replicating a DB across a
dialup can be costly, but downloading source data and building locally
isn't (as much), and it's free...


Paul
 
Back
Top