Re: Does SQL Server Compact 3.1 support multi connection?

As I discuss in my EBook, the SQLCe engine can support multiple connections, but only from the same user. This means the DBMS does not know how to share data between users. I suggest looking at a replication architecture or a DBMS engine like SQL Server (Express) that supports multiple users.

"jpkong" <jpkong@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:7CADE68E-D269-4230-B377-BAEC634C1F3B@xxxxxxxxxxxxxxxx
Hi.


I wonder whether SQL CE editions support multi connection(also multi user),
multi session in connection or not.
If that, how many connections or sessions are supported by it?

For my case, I need the connections from a Web Server and an application to
SQL CE.
And in the application, it need multiple sessions in a connection for
transaction from various parts of the application.

Anyone let me know it?
Thanks in advance.

jp

--
__________________________________________________________________________
William R. Vaughn
President and Founder Beta V Corporation
Author, Mentor, Dad, Grandpa
Microsoft MVP
(425) 556-9205 (Pacific time)
Hitchhiker’s Guide to Visual Studio and SQL Server (7th Edition)
____________________________________________________________________________________________



.

Relevant Pages

  • Re: Industry Standard Security and guest wifi access best practice
    ... with IPSEC VPN clients has not been positive. ... Then they probably won't support other forms of security. ... to switch all connections into SSL mode. ... Use WPA to encrypt wireless traffic, ...
    (alt.internet.wireless)
  • Re: Yes - Off-Line Temporarily
    ... Apache will give you more connections, but will not support the server ... Microsoft MVP - FrontPage ... security concerns at http://www.remotedirector.com. ...
    (microsoft.public.frontpage.client)
  • Success Re: Help and Support Center Problem
    ... My problem in brief: In the Help and Support Center, the Help viewer had these symptoms: 1) the font changed to Times New Roman, 2) links no longer worked, 3) the H & S graphics did not appear and 4) certain lines and phrases were replaced by XOX. ... I'm still left with the minor annoyance that H & S doesn't think I'm connected to the internet. ... That's no big deal, really, because I can still connect to the MSKB and Windows Update through H & S. In fact there are two MSKB articles that describe this problem, but both refer to DSL connections and I have cable. ... > I've tried System File Checker, replacing hh.dat and reinstalling H &> S, ...
    (microsoft.public.windowsxp.help_and_support)
  • Re: Kinda urgent Connection error messages
    ... driver perspective, these are all unexpected problems the driver is suffering ... I guarantee that the driver is making the socket the same way ... Do you hold JDBC connections open indefinitely, ... Maybe the DBMS has an idle connection timeout, ...
    (microsoft.public.sqlserver.jdbcdriver)
  • Re: Multiple User Access through ADO?
    ... SqlCE is can handle connections from multiple applications and threads on the same machine. ... It can also be used with IIS for multiple web requests for data, but this is still on the same machine. ... >>> I have a SQLCE database on a terminal server. ...
    (microsoft.public.sqlserver.ce)