Re: MSDE Performance and Reliability

How large of an installation at a single site have you seen? My database
with all table will probably be up to 1.5 GB maximum.

I believe the the Express edition has a limit on the number of connections
and the size of the DB. Last I remember was 5-10 connecttionas and 2gb. I
could be wrong on this, but I think the idea is free for small application
and then pay when you grow. I usually use all my DB's with a middleware so
the number of connections is not an issue. You'll need to do some research
on the number of connections and size and see if the free version fits. MS
makes a Small Business server that includes MS SQL and my clients usually
buy that, as it is very affordable, if the Express version does not handle
their needs.

can I access the database remotely over the internet with this version?

Yes, it works just like MS SQL. Again I usually use all my DB's with a
middleware so this is not an issue for me.

RB


.

Relevant Pages

  • Re: Access 2007->SQL Server2005 "connection was forcibly closed",G
    ... I moved every table I was able to move to the SQL ... closed connections - but all of these errors are in the version which used ... the SQL Server 2000 and everything worked ... communication between ODBC (OLEDB and Native Client, ...
    (microsoft.public.sqlserver.connect)
  • Access 2007->SQL Server2005 "connection was forcibly closed",GNE 1
    ... I have a very big problem connecting an SQL ... changing number of clients using the SQL Server with this frontend at the ... connection pooling or if these connections are separated connections). ...
    (microsoft.public.sqlserver.connect)
  • Re: Does SQL Server Compact 3.1 support multi connection?
    ... I consider to use SQL CE 3.5 on WinCE 5.0 if it doesn't need any license ... All apps and web server, SQLCE 3.1 run on the same machine. ... As long as the connections are all on the same machine, ... But I'm meaning simultaneous multiple connections from apps and web ...
    (microsoft.public.sqlserver.ce)
  • RE: scaling out data access
    ... hi kerry, thanks for answering. ... optimizing the sql connections, and code, sql ... > Trying to use a dataset as an in-memory database with hundreds of thousasnds ... > to be sure you are opening connections as late as possible and closing them ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Does SQL Server Compact 3.1 support multi connection?
    ... It's the point that SQL CE not designed for the situation like a web server ... And we expect worst case is like 10 connections. ... But I'm meaning simultaneous multiple connections from apps and web ...
    (microsoft.public.sqlserver.ce)