Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum / DB Engine / SQL Server CE / November 2007

Tip: Looking for answers? Try searching our database.

SSCE from multiple PCs?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
eselk@surfbest.net - 29 Nov 2007 02:38 GMT
I'm looking for a light-weight database engine I can use for multiple
users accessing the same database over a LAN (and I know that client/
server is recommended, but not an option for me).  I want something
from Microsoft.  I saw SSCE which looks great, but unlike JET Red it
doesn't appear to handle multiple workstations using a shared drive,
is this correct?  I was thinking about JET Red, but I like the small
foot-print of SSCE and that I can include all files in my application
folder -- easy install, and no worry of version conflicts with other
apps.  If SSCE won't allow multiple PCs to open the database file
(spf?), can anyone think of something else that would meet my needs
(again, must be from Microsoft -- I love MS).

Sorry for posting a desktop question in a mobile device group, but I
couldn't find any SSCE specific groups besides this one, and this
really is an SSCE question.
ErikEJ - 29 Nov 2007 08:51 GMT
This IS the proper newsgroup for any SSCE questions. For a discussion of why
SSCE does not allow multiple machine LAN access, see:
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2476694&SiteID=1

Other than Jet, I can't think of any option (apart from SQL Server Express,
which is recommended).

Signature

Erik Ejlskov Jensen, Mobile App Dev MCTS
Check out my SQL Compact blog at
http://erikej.blogspot.com

> I'm looking for a light-weight database engine I can use for multiple
> users accessing the same database over a LAN (and I know that client/
[quoted text clipped - 11 lines]
> couldn't find any SSCE specific groups besides this one, and this
> really is an SSCE question.
Ginny Caughey [MVP] - 29 Nov 2007 15:39 GMT
As Erik pointed out, SQL Express really is the recommended solution for
multi-user access, and yes it is a lot heavier weight to install than SSCE.
I'd recommend checking with the SQL Server or MSDE newsgroup for suggestions
on how to make this process easier for you and your clients.

Signature

Ginny Caughey
Device Application Development MVP

> I'm looking for a light-weight database engine I can use for multiple
> users accessing the same database over a LAN (and I know that client/
[quoted text clipped - 11 lines]
> couldn't find any SSCE specific groups besides this one, and this
> really is an SSCE question.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.