Discussion:
Questions about Sql CE 3.1
(too old to reply)
FACE ONE
2009-10-23 18:04:02 UTC
Permalink
Hi,

i have two questions about SqlCE 3.1

I make a VB.NET software for .NET 2.0 with JET (Access 2003) database.

Now i want to use Sql CE 3.1

Questions:
1) It's possibile to use SQLCE3.1 in a LAN ?
i want to use (from my pc) a db into an other pc folder share

2) it's possible to port Access DB into a SQL CE ?

Thank you

FACE ONE
ErikEJ
2009-10-25 09:08:14 UTC
Permalink
Only a single PC at the time can connect to a SQL Compact database. The
dabase can be located on a LAN drive.

www.primeworks-mobile.com provides some good tools to convert from Access to
SQL Compact.
--
Erik Ejlskov Jensen, Mobile App Dev MCTS
Check out my SQL Compact blog at
http://erikej.blogspot.com
Post by FACE ONE
Hi,
i have two questions about SqlCE 3.1
I make a VB.NET software for .NET 2.0 with JET (Access 2003) database.
Now i want to use Sql CE 3.1
1) It's possibile to use SQLCE3.1 in a LAN ?
i want to use (from my pc) a db into an other pc folder share
2) it's possible to port Access DB into a SQL CE ?
Thank you
FACE ONE
FACE ONE
2009-10-25 15:37:25 UTC
Permalink
Hi ErikEJ,
Post by ErikEJ
Only a single PC at the time can connect to a SQL Compact database. The
dabase can be located on a LAN drive.
www.primeworks-mobile.com provides some good tools to convert from
Access to SQL Compact.
thanks for the reply and the link.

Use SQLCE locally (instead MDB) and SQL Express on the server might be a
good idea?

The sqlce is only for work locally with a copy of db.

Can i synchronize CE 3.1 and express 2005 using replication?

Thank you

FACE ONE
ErikEJ
2009-10-25 20:19:57 UTC
Permalink
You can use RDA or ADO.NET Sync Framework to synchronize, yes.
--
Erik Ejlskov Jensen, Mobile App Dev MCTS
Check out my SQL Compact blog at
http://erikej.blogspot.com
Post by FACE ONE
Hi ErikEJ,
Post by ErikEJ
Only a single PC at the time can connect to a SQL Compact database. The
dabase can be located on a LAN drive.
www.primeworks-mobile.com provides some good tools to convert from Access
to SQL Compact.
thanks for the reply and the link.
Use SQLCE locally (instead MDB) and SQL Express on the server might be a
good idea?
The sqlce is only for work locally with a copy of db.
Can i synchronize CE 3.1 and express 2005 using replication?
Thank you
FACE ONE
FACE ONE
2009-10-26 12:48:48 UTC
Permalink
Hi ErikEJ,
Post by ErikEJ
You can use RDA or ADO.NET Sync Framework to synchronize, yes.
Thank You for reply

FACEONE

Loading...