Is there anyway to create an SQL Server CE Database on the pc desktop, and also a way of taking the SQL Server CE Database from the pda to the desktop using a method other than replication??
SQL Server CE Database : Pda to desktop and back
8 posts
• Page 1 of 1
- 1. get BlueTooth signal quality
How can I get the BlueTooth signal quality in my C# Pocket ap when PPC connect to another BlueTooth devices? - 2. any music/midi library
hi, is there any music/midi library available for c#? i want to input and play midi and chord stuff on pocketpc. thanks! - 3. SqlCeResultSet as DataSource?
Hi All, After looking at the documentation on the SqlCeResultSet I was under the inpression that I could use this as a datasource for a list control such as a ComboBox. However it does not seem to be working for me. What I want to do is bind the ComboBox control such that I can set a DisplayMember and ValueMember. From what I have seen so far the only way I can currently do this is by using a DataSet which is more overhead than I want, especially when I have no need to update the DataSet. I could use a SqlCeDataReader, which would be fast, but I know of no way to set the ValueMember property of the items in the ComboBox using this method. Any thoughts?
Next
SQL Server CE Database : Pda to desktop and back
by Victor » Thu, 07 Aug 2003 22:55:23 GMT
Re: SQL Server CE Database : Pda to desktop and back
by Mark Reddick » Thu, 07 Aug 2003 23:31:23 GMT
You cannot create a CE database on the desktop. You can use RDA (Remote Data Access) to keep a desktop SQL Server db in sync with a CE db. That is what I'm doing. Here is what I did for my app: 1) Create the database I want on desktop SQL Server. Remember not to use stored procs or views as they are not supported on SQLCE. 2) Add any initial data I want into the desktop SQL Server database. 3) In my PPC app, I then use SQLCE and do a CreateDatabase to create a database on the PPC device. 4) I then use RDA and connect to my desktop database and pull all the tables down to my SQLCE database. 5) I then reset my identity columns as they don't come down with RDA. That's it. The app can then use the SQLCE database. You can then use RDA again to push any changes made on the SQLCE db to your desktop DB. I do this so that my desktop database remains my "master" db. HTH, Mark
Re: SQL Server CE Database : Pda to desktop and back
by LawX » Fri, 08 Aug 2003 16:54:13 GMT
so, I'm interested in what you're saying about stored procedures on the desktop DB. Is it really impossible to use stored proc on the server even if my SqlCe doesn't try to use them. I mean, when doing the RDA, where is the prob with stored proc if RDA only copy tables to the SqlCe. I'm quite a beginner in developping C# for mobile but I have a huge solution to make before soon. My databses on the server are already created and use stored procs. You make me nervous by telling me it won't work !! ;-) thanks for explaining me in details how all that work. bye use RDA (Remote Data db. That is what Remember not to use Server database. CreateDatabase to create a pull all the tables down with RDA. can then use RDA desktop DB. I do this from the
Re: SQL Server CE Database : Pda to desktop and back
by Mark Reddick » Fri, 08 Aug 2003 21:27:42 GMT
No no. Sorry to confuse you. You can use sp and views on the desktop database. You just can't use them on the CE database (on the PDA). So, your PDA app has to be able to work without relying on stored procs or views.
Re: SQL Server CE Database : Pda to desktop and back
by LawX » Fri, 08 Aug 2003 23:36:15 GMT
reat thanks for all that. I didn't ask for so much
examples but it's pleasant to feel helped.
Really thank you, RDA and SQL CE have never been so clear
to me.
LawX
and it should work.
PULL, I do that simply
the last value.
the identiy column
(maxValuePlusOne, 1)
them into the
sure when you do
that way it will
do the Push, it will
the host db outside
may update your
values each of
Windows app that writes
into a table that you
data back, you
identity column values as
the CE application
updating their local
have it's own "range"
the same identity
replication. I
involved and you may not
the
to
questions. I
and
then
using
on
(on
stored
impossible to
doesn't
SqlCe.
but I
databses on
You
work.
can
with a
come
You
your
Database
examples but it's pleasant to feel helped.
Really thank you, RDA and SQL CE have never been so clear
to me.
LawX
and it should work.
PULL, I do that simply
the last value.
the identiy column
(maxValuePlusOne, 1)
them into the
sure when you do
that way it will
do the Push, it will
the host db outside
may update your
values each of
Windows app that writes
into a table that you
data back, you
identity column values as
the CE application
updating their local
have it's own "range"
the same identity
replication. I
involved and you may not
the
to
questions. I
and
then
using
on
(on
stored
impossible to
doesn't
SqlCe.
but I
databses on
You
work.
can
with a
come
You
your
Database
Re: SQL Server CE Database : Pda to desktop and back
by John Atkins » Sat, 09 Aug 2003 17:19:46 GMT
ould I jump in and ask a question about RDA? I've not used it yet but when
I read about it, I thought it was only for the desktop PC end. In other
words, I thought the PC had to make the connection to the PPC and then send
to or request data from the PPC.
Could you confirm that the PPC can also make the connection and be in
control?
Regards
John.
"Mark Reddick" < XXXX@XXXXX.COM > wrote in message
news:% XXXX@XXXXX.COM ...
work.
simply
column
will
outside
writes
you
as
local
"range"
not
I read about it, I thought it was only for the desktop PC end. In other
words, I thought the PC had to make the connection to the PPC and then send
to or request data from the PPC.
Could you confirm that the PPC can also make the connection and be in
control?
Regards
John.
"Mark Reddick" < XXXX@XXXXX.COM > wrote in message
news:% XXXX@XXXXX.COM ...
work.
simply
column
will
outside
writes
you
as
local
"range"
not
Re: SQL Server CE Database : Pda to desktop and back
by LawX » Sat, 09 Aug 2003 18:45:36 GMT
s far as I know, only the PPC could use RDA. The device
has to be connected to the Internet and the server could
not know if it is or not. So, in my view, RDA is a way to
call synchronisation, but only the PPC can launch the
service.
Actually, I'm beginner in using C# and mobile devices. I'm
desesperatly trying to connect both PPC and Desktop and
that's not so easy. There are many parameters that come in
the process and, as i don't konw much about MS
environnement, it's hard for me to understand all.
But anyway, many people have been able to use RDA, I'm
sure it works perfectly, it just need a bit of practicing.
If anyone knows any good documentation about all that
stuff, i'll be pleased to be awared.
thanks.
used it yet but when
end. In other
PPC and then send
connection and be in
message
and it should
PULL, I do that
get the last value.
reset the identiy
(maxValuePlusOne, 1)
insert them into the
make sure when you do
so that way it will
do the Push, it
the host db
may update your
column values each of
Windows app that
into a table that
the data back, you
identity column values
the CE application
updating their
have it's own
the same identity
replication. I
involved and you may
desktop.
but the
seem to
questions. I
newsGroup
a
and
then
group
using
(beginner?)
views on
(on
stored
impossible to
doesn't
the
SqlCe.
but I
databses on
procs. You
work.
You can
with a
Server.
SQL
database
come
database. You
your
db.
Database
has to be connected to the Internet and the server could
not know if it is or not. So, in my view, RDA is a way to
call synchronisation, but only the PPC can launch the
service.
Actually, I'm beginner in using C# and mobile devices. I'm
desesperatly trying to connect both PPC and Desktop and
that's not so easy. There are many parameters that come in
the process and, as i don't konw much about MS
environnement, it's hard for me to understand all.
But anyway, many people have been able to use RDA, I'm
sure it works perfectly, it just need a bit of practicing.
If anyone knows any good documentation about all that
stuff, i'll be pleased to be awared.
thanks.
used it yet but when
end. In other
PPC and then send
connection and be in
message
and it should
PULL, I do that
get the last value.
reset the identiy
(maxValuePlusOne, 1)
insert them into the
make sure when you do
so that way it will
do the Push, it
the host db
may update your
column values each of
Windows app that
into a table that
the data back, you
identity column values
the CE application
updating their
have it's own
the same identity
replication. I
involved and you may
desktop.
but the
seem to
questions. I
newsGroup
a
and
then
group
using
(beginner?)
views on
(on
stored
impossible to
doesn't
the
SqlCe.
but I
databses on
procs. You
work.
You can
with a
Server.
SQL
database
come
database. You
your
db.
Database
Re: SQL Server CE Database : Pda to desktop and back
by John Atkins » Sat, 09 Aug 2003 19:56:01 GMT
pologies to you and Mark. I was confusing RAPI with RDA. I thing RAPI can
only be controlled from a PC not a PPC but I could be wrong. RDA is complely
different.
Incidentally a book I can recommend is Microsoft .NET Compact Framework Core
Reference by Wigley and Wheelwright. It does contain a section on RDA.
Try saying Wigley Wheelwright a few times fast! :-)
John.
"LawX" < XXXX@XXXXX.COM > wrote in message
news:0a1101c35d91$d1b22520$ XXXX@XXXXX.COM ...
only be controlled from a PC not a PPC but I could be wrong. RDA is complely
different.
Incidentally a book I can recommend is Microsoft .NET Compact Framework Core
Reference by Wigley and Wheelwright. It does contain a section on RDA.
Try saying Wigley Wheelwright a few times fast! :-)
John.
"LawX" < XXXX@XXXXX.COM > wrote in message
news:0a1101c35d91$d1b22520$ XXXX@XXXXX.COM ...
Similar Threads:
1.Accessing a sql server ce database on a PDA from a desktop applica
Hi, is there a possibility to access a sql server ce databse on a pocket pc through a desktop application (pda is connected via active sync). Applications developed with .Net an Visual Basic Cheers, Egils
2.sql server ce desktop database designer application
greetinns does anyone know any visual desktop program that we can use to create databases and generate the SQL to use on a sql server ce to create the pocket database? thanks almeida
3.How to transfer SQL CE database (sdf) to SQL Server database (mdf)
Hello I have SQL CE database (.sdf file) and want to transfer it to MS SQL Server 2000 (.mdf file). Is there any solution to do it in relatively simple way (without creating database with corresponding tables on SQL Server 2000). My setup is: - SQL Server CE database with a number of tables - SQL Server 2000 database without tables (empty) With RDA it isn't possible, because it works according to pull-push principe. With no tables in SQL Server 2000 one cannot do pull. What about Merge Replication or any other solution? My device is out of order, so any solution related to using ActiveSync is not for me. Thanks in advance. Pavel.
4.problem connecting from desktop to sql mobile database on pda
hi there, i cant get it to connect, i added the reference to System.Data.SQLServerCE.dll, and using the following code (IP is pinged and working okay) ------------ string DATABASE_CONN = "Data Source = \\\\192.168.1.107\\My Documents\\OrdersDB.sdf"; SqlCeConnection conn = new SqlCeConnection(DATABASE_CONN); conn.Open(); ------------ any help appreciated. thanks, Paul
5.How to build SQL CE Database on desktop?
Hi, All, How to build SQL CE Database on desktop? e.g. if I need build 10 different SQL CE databases on desktop, is there any way to do it in batch? Any ideas are welcome. Thanks in advance. -Hank
6. Reading a SQL Ce Database from a desktop machine
7. Database Migration From SQL Server8.0 to Sql server ce 2.1
8 posts
• Page 1 of 1
Who is online
Users browsing this forum: No registered users and 17 guest