Re: How to read data from stand alone SQL CE database on mobile device from VB.net 2005

Ok Ginny,

I will use the Primeworks Solution for the moment
which works as you say.
Thnx for your help,

Dikbill
The Netherlands

"Ginny Caughey [MVP]" <ginny.caughey.online@xxxxxxxxxxxxxx> schreef in
bericht news:OEf6YbkCHHA.4808@xxxxxxxxxxxxxxxxxxxxxxx
Dikbill,

On the Microsoft front, currently both Merge Replication and RDA require a
server running IIS to make the connection. Since the Access Sync CTP does
not require IIS, it might be reasonable to guess they'd consider removing
the IIS requirement for SQL Server but I don't know. All I can say for
sure is that the Primeworks solutions is available today and has a good
reputation.

--
Ginny Caughey
Device Application Development MVP


"Dikbill" <dikbill666@xxxxxxxxxxx> wrote in message
news:455d7bfe$0$11825$ba620dc5@xxxxxxxxxxxxxxxxxxxxxx
Ginny,

Thanks for your quick response :-)
I have tried the solution form primeworks with their
trial software. It works, I've only had time to test the
reading part.

Do you know if there are any Microsoft plans to
create such a product? I can imagine that there will
be more developers who will need this.

Thanx agian!

Dikbill
The Netherlands


"Ginny Caughey [MVP]" <ginny.caughey.online@xxxxxxxxxxxxxx> schreef in
bericht news:%2301Mn5XCHHA.3396@xxxxxxxxxxxxxxxxxxxxxxx
Have you considered using Rapi to copy the sdf file from the device to
the desktop, then process the data on the desktop? (You will need the
SQL Compact Edition CTP if the desktop is not a development machine.)
You can also use Rapi to delete the file on the device when you're
finished with it. There is a Rapi wrapper on www.opennetcf.org. There is
also a 3rd party product at www.primeworks.pt that may do what you want.

--
Ginny Caughey
Device Application Development MVP


"Dikbill" <dikbill666@xxxxxxxxxxx> wrote in message
news:455c49c8$0$9463$ba620dc5@xxxxxxxxxxxxxxxxxxxxxx
Hi there,

I have a stand alone SQL CE database on my windows mobile device.
OS = WM 5 Dutch.
I can alter teh local database on the mobile device which will be used
by persons who will store data when they visit a client.

When they come back to the office, where no SQL server is available,
I want to read the SQL CE data from their mobile device.
After their new data is processed in the VB.net application I will
delete the data ont heir mobile device.

The database will be very simple.

The problem is that I can't get a connection with the SQL CE database
from the VB.net application.

This is my code:

Dim conn As New SqlCeConnection("Data Source=\My
Documents\AppDatabase1.sdf")

conn.Open()

Dim cmdView As SqlCeCommand = conn.CreateCommand

cmdView.CommandText = "SELECT * FROM TESTTABEL"

Dim da As New SqlCeDataAdapter(cmdView)

Dim ds As New Data.DataSet

da.Fill(ds, "Test")

DataGrid1.DataSource = ds.Tables(0)

conn.Close()

The VB.net can't find the database but it is there.



Anyone?



Dikbill
The Netherlands










.